Forums
This topic is locked
Unknown MySQL Server Host
19 Aug 2001 23:04:34 Tian Ci posted:
When Iám tryong to view my Ultra Dev page through the Live Data Window or via my browser I get the following message: "Warning: Unknown MySQL Server Host 'http' (0) in ./adodb/adodb-mysql.inc.php on line 85". Iám connecting to a MySQL Database using MyODBC, and the Test in the UltraDev Connection Section says "Connection was made succesfully".
What change should I made to correct this warning?
Replies
Replied 20 Aug 2001 14:55:07
20 Aug 2001 14:55:07 Tim Green replied:
The problem here is that in your connection you have probably put your MySQL server as :-
ipnumber or
whatever.com
This is wrong. You are told that the connection is successful as this only checks that communication can occur between UD and whatever address you specified. In this case it will be picking up your webserver.
MySQL does not work via the HTTP Protocol. So when you are creating a connection use either the IP Address, or the domain name. Don't specify the part. I would also check your MyODBC DSN, as it is possible that the problem occurs there too. Or it could be just a problem in your DSN. Either way, this is what the problem is.
Hope this helps
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
ipnumber or
whatever.com
This is wrong. You are told that the connection is successful as this only checks that communication can occur between UD and whatever address you specified. In this case it will be picking up your webserver.
MySQL does not work via the HTTP Protocol. So when you are creating a connection use either the IP Address, or the domain name. Don't specify the part. I would also check your MyODBC DSN, as it is possible that the problem occurs there too. Or it could be just a problem in your DSN. Either way, this is what the problem is.
Hope this helps
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Replied 23 Aug 2001 09:13:05
Replied 23 Aug 2001 12:44:57
23 Aug 2001 12:44:57 Tim Green replied:
Excellent !
Glad I could be of help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Glad I could be of help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>