Please be thoughtful, detailed and courteous, and adhere to our posting rules. That is why the error says ‘localhost’ remove all the single quotes from your connection string. May 01, The error seems to manifest itself under “stress” conditions, when lots of connections are being made opened and closed in a short space of time minutes. My adrenaline is still pumping after 8 hours of trouble with this!! Please note the above connectionstring is for ASP.
|Date Added:||19 May 2010|
|File Size:||10.54 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Please note the above connectionstring is for ASP.
I restart the MySQL Service and check to see if I can connect to using the mysql consol in dos and it just won’t let me in, orbc it can’t connect to mysql! Edited 8 Years Ago by AndreRet: I am attaching a small sample that I am using in vb6 to connect and create my tables. I just made a small program just to see if the connection works.
[SOLVED] 1st timer – ODBC connect error – Forums
It was eventually the MySql ref. Yes you can most certainly connect to mySql using musql. Could somebody please help resolve this problem? If you’ve MySQL administrator or Query browser tool, enter the name of server and database in it and test the connection.
It took .351 about a week to find the solution to the same problem and with many posts. I got into same issue and it resolved once we opened the port.
Firewalls are turned off These notes have been tested against MySQL version 4. The link below gives you a step by step which worked for me. The error seems to manifest itself under “stress” conditions, when lots of connections are being made opened and closed in a short space of time minutes.
OdbcConnection ‘ Is the connection is already open? I develop my ASP. The valid range is 0x1E – 0x12C 30seconds to secondsthe default is 0xF0 seconds. This question is old but here is to guide anyone who had a problem like mine. Make sure your port is not blocked even if you are connecting to a remote MySql database. We check it, the asp.
Sometimes you just don’t see the forest for the trees I have un-installed MySql completely and then went and re-installed to all its default values. I’ve been trying to fix this error for a couple of days now and seem to be stuck with it.
Forums: [SOLVED] 1st timer – ODBC connect error – Forums
Close ‘ Initialize a few local variables to store the MySQL username, password, location, driver name and database name. Community Websites Community Support. Consider whether it is possible to modify the application to re-use database connections instead of closing and reopening them. You will also note that I have used older drivers, 3.
Note that in declaring the Server, Database, User and Password do not use quotes. Deepmadan, as I said previously, I had major headaches sorting it.
Here is the connection code I used to get my desktop application 35.1 work. My adrenaline is still pumping after 8 hours of trouble with this!! Apr 12,