Error Hyt00 Mysql Odbc 3.51 Driver Can T Connect
Contents |
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/Oracle, MySQL, Sybase, Informix and other databases/ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server... ERROR [HY000] [MySQL][ODBC mysql odbc 3.51 driver can't connect to mysql server on 'localhost' (10061) 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061) RSS 7 replies
Mysql Odbc 3.51 Driver Windows 7
Last post Nov 13, 2011 11:43 AM by tonewilliams ‹ Previous Thread|Next Thread › Print Share Twitter Facebook mysql odbc 3.51 driver could not find driver Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply Doods Member 1 Points 55 Posts ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on
Mysql Odbc 3.51 Driver Access Denied For User
'localhost' (10061) Apr 12, 2006 09:32 AM|Doods|LINK Greetings all! I have this weird error "ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061)" on my website that is supposed to connect to a MySQL database on a different server (NOT localhost). Here's the scenario: I develop my ASP.Net 2.0 website on my PC using this connection string mysql odbc 3.51 driver access denied for user 'root'@'localhost' (using password yes) for my ObjectDataSource: <add name="ConnectionString" connectionString="Driver={MySQL ODBC 3.51 Driver};server:localhost; database=MYDBASE;uid=MYUID;pwd=MYPWD" providerName="System.Data.Odbc" /> After testing and finding all pages working fine, I changed my connection string by replacing the server name to that specified by my Internet Hosting Company (along with the relevant dbase, uid, andpwd), buit my website and published it to a different virtual address on my local server (using Web Deployment Manager), and then copied the files onto my internet webspace. The weird thing is that the error keeps referring to the LOCALHOST server (this is the one I use in my Local PC). Could somebody please help resolve this problem? I've been trying to fix this error for a couple of days now and seem to be stuck with it. :(
Thanks. Reply deokule2003 Member 30 Points 351 Posts Re: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061) May 01, 2006 12:53 PM|deokule2003|LINK Hello, Recheck your connection string. Also do one more thing to check connection. If you've MySQL administrator or Query browser tool, enter the name of server and databaTips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions...
Connection Failed Hy000 Mysql Odbc 3.51 Driver Can't Connect To Mysql Server On
C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards...
Connection Failed Hy000 Mysql Odbc 5.1 Driver Access Denied For User
Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C connection failed hy000 mysql odbc 5.1 driver can't connect to mysql server on (10060) / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight http://forums.asp.net/t/981421.aspx?ERROR+HY000+MySQL+ODBC+3+51+Driver+Can+t+connect+to+MySQL+server+on+localhost+10061+ / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? http://www.codeproject.com/Questions/205153/Article General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost'; (10048)" Rate this: Please Sign up or sign in to vote. See more: C# .NET MySQL when i connect the odbc connection. it's connect & execute the query but after some time it display the exception as "ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost'; (10048)" but it's working fine when we ignore the exception Posted 1-Jun-11 19:21pm vrushali katkade1.4K Add a Solution 1 solution Rate this: Please Sign up or sign in to vote. Solution 1 Accept Solution Reject Solution Hi, Please folow below link for detail http://www.cryer.co.uk/brian/mysql/trouble_odbc_cant_connect_on_localhost.htm[^] Regards Asutosha Permalink Posted 2-Jun-11 0:03am Asutosha5K Add a Solution Add your solution here B I U S small BIG code Plain TextC++CSSC#Delphi / PascalF#HTML / XML / ASPJavaJavascriptObjective-CSQLPerlPHPPythonVBXMLvar < > & link [^] encode untab case indent outdent OK Paste as Strip HTML Encode HTML Paste as-is Code block Quoted Text Best guess To display as The content must be at least 30 c
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10048) The precise presentation of this error may vary according to the software used, this wording was generated from an ASP.NET application. Other symptoms: The http://www.cryer.co.uk/brian/mysql/trouble_odbc_cant_connect_on_localhost.htm application has previously been able to successfully connect to the database. Waiting a minute or so, and the application can connect again without the error. 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). These notes only apply to the error above when the "other symptoms" are present. Cause The error is caused not by mysql odbc MySQL or the MySQL ODBC driver, but by the behaviour of Windows. For performance reasons Windows maintains a connection on a TCP port after it is closed for (by default) 4 minutes. The advantage of this is that if the connection needs to be reopened it can be done at a lower cost. The trouble is that under heavy load when lots of connections are opened and closed to the database, the system mysql odbc 3.51 can hit a limit on the maximum number of connections allowed (even though as far as the application is concerned these connections have been closed). Resolution To decrease the delay before Windows releases an open TCP connection, use regedit to edit the following registry value of: HKLM\ SYSTEM\ CurrentControLSet\ Services\ Tcpip\ Parameters\ TcpTimedWaitDelay This value does not exist by default and will need to be created. It should be a DWORD. The valid range is 0x1E - 0x12C (30seconds to 300 seconds), the default is 0xF0 (240 seconds). 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). Consider whether it is possible to modify the application to re-use database connections instead of closing and reopening them. In theory enabling connection pooling would address this problem. For more information about connection pooling see http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169470. To enable connection pooling for the MySQL driver: Start > Control Panel > Administrative Tools > Data Sources (ODBC). This will open up the "ODBC Data Source Administrator". On the "Connection Pooling" tab, double click the ODBC Driver you are using to connect to MySQL. This will open up the "Set Connection Pooling A