Jump to content

Query : Configuring ODBC DSN for MySQL in Win98


simonwar

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. :?:

Link to comment
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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.