61 users online (1 members and 60 guests)  


  Results 1 to 2 of 2

Related

  1. Generating reports from databases    Forum: CGI Perl Forum
    Replies: 2
  2. databases    Forum: Databases
    Replies: 1
  3. Replies: 9
  4. Shopping carts and databases    Forum: Website Scripts Forum
    Replies: 1
  5. Shopping carts and databases    Forum: HTML Forum
    Replies: 0
  1. #1
    Zamees's Avatar
    New User

    Status
    Offline
    Join Date
    Sep 2003
    Posts
    19

    Changing Databases???

    Hi, I'm moving a database from one server to another server...both have told me the server name is localhost.

    So when I am on one server, its localhost, but how do i go about accessing the localhost on the other server. I tried using mydomainname/localhost but that didn't do it.

    Anyone know.

    Heres the example of the code.

    PHP Code:
    Set newobjRecordset Server.CreateObject("ADODB.Connection")
    newobjRecordset.Open "driver={MySQL};server=gamertags.phenominet.com/localhost;database=forum","*","*"
    Set objRecordset Server.CreateObject("ADODB.Connection")
    objRecordset.Open "driver={MySQL};server=localhost;database=roth5000","*","*" 

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    localhost is a loopback address meaning, basically, 'the machine I am on'.

    if its a different machine, then you need the address for it. The machine also has to be set to allow you to remotely access that database.

    I would speak to your hosts to see if they allow this.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?



Tags for this Thread