Jump to content


Photo

Query : Configuring ODBC DSN for MySQL in Win98


  • Please log in to reply
1 reply to this topic

#1 simonwar

simonwar
  • New Members
  • Pip
  • Newbie
  • 1 posts
  • LocationUnited Kingdom

Posted 22 March 2003 - 01:38 PM

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

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 24 March 2003 - 04:22 PM

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.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users