Jump to content


This topic is now archived and is closed to further replies.


Query : Configuring ODBC DSN for MySQL in Win98

Recommended Posts

I am new to Dynamic Web Page Authoring, so no laughs at this question please !


I am using Dreamweaver MX and about to create a Dynamic Page. I activate the \'Create a Connection to a Database\' pop up box and have to create a \'DSN\' or \'String based\' Connection.


I select DSN and continue to configure, however, on selecting the \'TEST Connection\' button, I get an error.....


[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General Network Error ....etc.


So I check that the DSN is set up correctly in the WIN32ODBC Settings on my machine. When I go into this through \'Control Panel\' and go to \'System DSN\', I attempt to configure the SQL Server Driver, but again do not understand what I have to do exactly ???


For example : I click on the \'Configure\' button and get through the first screen, names etc, but the next screen does not allow me to click \'Next\', as I get an error as follows .....


Connection failed:

SQL State: \'01000\'

SQL Server Error: 10061

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(connect()).

Connection failed:

SQL State: \'08001\'

SQL Server Error: 11

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.


It is clear that I am not setting up a link to a database, but how do you Configure a link to a MySQL Database and therefore set up a DSN in the ODBC setup ?



For information .....

I have PWS and MySQL serving in the background....


Thanks. Simon. :?:

Share this post

Link to post
Share on other sites

Now if u are trying to connect to a remote MSQL then I am sure u have given a wrong IP which is resulting in the failure.


Now if u are trying to access the mysql database in a remote machine


u have to get urself the mysql ODBC driver which is available @ mysql.com.


Once u have installed that then u have to create a connection using the ODBC.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.