You can also download MySqlcc just search for it which connects to MySql, and it is much better than the MySql management console. ToString ‘Write code below to execute more steps since you’re unable to connect. The second link gives you more options as well, although the first was fine for me. I develop my ASP. The link below gives you a step by step which worked for me. Consider whether it is possible to modify the application to re-use database connections instead of closing and reopening them. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.

Uploader: Vim
Date Added: 20 November 2007
File Size: 61.66 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 30191
Price: Free* [*Free Regsitration Required]

Edited 8 Years Ago by AndreRet: Please and thank you!

This question is old but here is to guide anyone who had a problem like mine. Nov 13, May 01, Please note the above connectionstring is for ASP. I’ve been looking all over the internet for an answer, and I didn’t find anything.


[Mysql][ODBC Driver]host couldn’t connect [SOLVED] | DaniWeb

I really hope you find the solution because I know what you are going through.: To read the error, add this to a message box somewhere: I rewrote the connection string in my web. It was eventually the MySql ref. Stack Overflow works best with JavaScript enabled.

Email Required, but never shown. We restart MySQL, and it works fine.

[SOLVED] 1st timer – ODBC connect error – Forums

Might be i need to allow lan access in my sever Mysql. Please be thoughtful, detailed and courteous, and adhere to our posting rules. MsgBox “Unable to connect due to the following error: For more information about connection pooling see http: It test connection, shows databases and tables.

Funny, none of the posts could help. May 29, For his day job he develops websites and desktop applications as well as providing IT odbv.

Forums: [SOLVED] 1st timer – ODBC connect error – Forums

The problem was in the syntax. Note that in declaring the Server, Database, User and Password do not use quotes. This will open up the “Set Connection Pooling Attributes” dialog. I just made a small program just to see if the connection works.


I am attaching a small sample that I am using in vb6 to connect and create my tables. Also try using IP instead of server name. The link below gives you a step by step which worked for me.

Community Websites Community Support. This value does not exist by default and will need to be created.

Firewalls are turned off I develop my ASP. I’ve been trying to fix this error for a couple of days now and seem to be stuck with it. May 02, Close ‘ Initialize a few local variables to store the MySQL username, password, location, driver name and database name.