Make sure your port is not blocked even if you are connecting to a remote MySql database. End Try ‘ See if the connection state opened correctly successfully If mConnection. ToString ‘Write code below to execute more steps since you’re unable to connect. By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. I had an inbound rule set up that locked port down to be accessible only from a list of IP addresses.

Uploader: Gomi
Date Added: 24 December 2013
File Size: 56.13 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 48970
Price: Free* [*Free Regsitration Required]

The link below gives you a step by step which worked for me.

Resolution To decrease the delay before Windows releases an open TCP connection, use regedit to edit the mhsql registry value of: This will open up the “Set Connection Pooling Attributes” dialog.

I have then flushed privelages and it worked for me. I suppose your mysql server is running on Windows End Try ‘ See if the connection state opened correctly successfully If mConnection. Firewalls are turned off In theory enabling connection pooling would address this problem.


The precise presentation of this error may vary according to the software used, this wording was generated from an ASP. Edited 8 Years Ago by AndreRet: Very likely to be a NAT problem. I have created a user account in the MySQL Administrator and added a host to enable remote access, I have also cailed an exception for my Windows Firewall on port but the connection still fails. Site was running fine.

Especially if it’s on the MySQL default port. I got into same issue and it resolved once we opened the port. The likely culprit that people often forget is: Try it out and see if it works for you.

This question is old but here is to guide anyone who had a problem like mine. Decreasing the value of TcpTimedWaitDelay should help, but is unlikely to permanently solve the problem for a busy system because if the system is busy the limits will still be hit. Last post Nov 13, Home Questions Tags Users Unanswered. Then our customer calls in to say he gets an error. If you’ve MySQL administrator or Pdbc browser tool, enter the name of server and database in it and test the connection.


Sometimes you just don’t see the forest for the trees Stack Overflow works best with JavaScript enabled.

connecting to mySql DB using ODBC driver

The application has previously been able to successfully connect to the database. Also do one more thing to check connection.

Brian Cryer is a dedicated software developer and webmaster. Sign up using Email and Password.

OdbcConnection ‘ Is the connection is already open? Lahno 11 1 3. Also I was using I rewrote the connection string in my web. We check it, the asp. The valid range is 0x1E – 0x12C 30seconds to secondsthe default is 0xF0 seconds.

Also try using IP instead of server name. I am attaching a small sample that I am using in vb6 to connect and create my tables. By using our site, you acknowledge that you have read and understand hyy000 Cookie PolicyPrivacy Policyand our Terms of Service.