Hi. I have followed the tutorial on setting up an ODBC connection to MySQL. I am trying to create a system DSN that matches my hosting company's DSN so that I use Ultra Dev to design pages (remote connections are not allowed). I have created the system dsn with the suggested program and entered all of the correct information. When I try to connect to the connection in Ultra Dev, I get this error:

[TCX][MyODBC]Can't connect to MySQL server server on "localhost" (10061)

What could be wrong? The MySQL driver appears to be installed on my Windows ME OS, so I am clueless.

Here is the info on Phakt Data Source Name screen (the same was used on my OS' control panel):

UD:
connection Name: connFries
DB Type: ODBC
URL: jdbc<img src=../images/dmxzone/forum/icon_smile_shock.gif border=0 align=middle>dbc:fries
User Name: Bob
Password: eggs

PHP:
Db type: MySQL
Host: localhost
Db name: freshfood
User name: Bob
Password: eggs

Edited by - Bob6667 on 08/20/2001 21:05:49

The problem here is that you are using a MySQL connection at run-time. It sounds like you need to create another ODBC connection instead.

The reason that you are getting the error is quite simply that there isn't a MySQL Server running on 'Localhost'.

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>