BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Driving me nuts!!          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Ant Guest Posted: Mon Aug 09, 2004 11:04 am    Post subject: Driving me nuts!! Hello, I am having difficulties connecting to MySLQ Server 4.0.20d using dbexpress. I am able to connect to the server fine using either command line or MySQLCC using the same username and password I am trying to use with dbExpress conection. I get this error - Failure to Connect: dbExpress Error: [0x000C] Invalid Username/Password SQL Server Error: Can't connect to MySQL server on 'localhost' (10061) I have checked the username and password in the edit connection, in HostName, I entered the hostname where MySQL is running, and checked that I have correct settings to allow me to access the database I have chosen. For whaever reason, if I am reading the error message correctly, it looks like it is looking for the server on my machine, as it mentions localhost, even though I have entered the actual hostname in the HostName property as both the windows netbios name and also as the actual ip address. Can anyone tell me why it is trying to connect to localhost and not the Server I am specifying? Thanks in advance My machine Using Delphi 7 Pro with update 7.1 WinXP libmysql.dll in system32 folder copied from server MySQLbin Server MySQL 4.0.20d Windows 2003 Server Back to top Shaggy Guest Posted: Mon Aug 09, 2004 11:29 am    Post subject: Re: Driving me nuts!! ....Check if the connection component doesn't connect to localhost. Set it to inactive before compiling. Cu, Ron "Ant" <ant (AT) nowhere (DOT) com> wrote Quote: Hello, I am having difficulties connecting to MySLQ Server 4.0.20d using dbexpress. I am able to connect to the server fine using either command line or MySQLCC using the same username and password I am trying to use with dbExpress conection. I get this error - Failure to Connect: dbExpress Error: [0x000C] Invalid Username/Password SQL Server Error: Can't connect to MySQL server on 'localhost' (10061) I have checked the username and password in the edit connection, in HostName, I entered the hostname where MySQL is running, and checked that I have correct settings to allow me to access the database I have chosen. For whaever reason, if I am reading the error message correctly, it looks like it is looking for the server on my machine, as it mentions localhost, even though I have entered the actual hostname in the HostName property as both the windows netbios name and also as the actual ip address. Can anyone tell me why it is trying to connect to localhost and not the Server I am specifying? Thanks in advance My machine Using Delphi 7 Pro with update 7.1 WinXP libmysql.dll in system32 folder copied from server MySQLbin Server MySQL 4.0.20d Windows 2003 Server Back to top Teo Guest Posted: Mon Aug 09, 2004 8:59 pm    Post subject: Re: Driving me nuts!! User on localhost is a separate user... You should check the server if your username@localhost excists and has access rights. Regards, Teo "Shaggy" <shaggy (AT) nowhere (DOT) com> schreef in bericht news:41175f6d$0$31042$ee9da40f (AT) news (DOT) wanadoo.nl... Quote: ...Check if the connection component doesn't connect to localhost. Set it to inactive before compiling. Cu, Ron "Ant" <ant (AT) nowhere (DOT) com> wrote in message news:41175a4a (AT) newsgroups (DOT) borland.com... Hello, I am having difficulties connecting to MySLQ Server 4.0.20d using dbexpress. I am able to connect to the server fine using either command line or MySQLCC using the same username and password I am trying to use with dbExpress conection. I get this error - Failure to Connect: dbExpress Error: [0x000C] Invalid Username/Password SQL Server Error: Can't connect to MySQL server on 'localhost' (10061) I have checked the username and password in the edit connection, in HostName, I entered the hostname where MySQL is running, and checked that I have correct settings to allow me to access the database I have chosen. For whaever reason, if I am reading the error message correctly, it looks like it is looking for the server on my machine, as it mentions localhost, even though I have entered the actual hostname in the HostName property as both the windows netbios name and also as the actual ip address. Can anyone tell me why it is trying to connect to localhost and not the Server I am specifying? Thanks in advance My machine Using Delphi 7 Pro with update 7.1 WinXP libmysql.dll in system32 folder copied from server MySQLbin Server MySQL 4.0.20d Windows 2003 Server Back to top Bruce Michener Guest Posted: Wed Aug 11, 2004 4:05 pm    Post subject: Re: Driving me nuts!! It seems to me that I had the same problem when trying to connect to a MySQL server on a Linux box when the user on that Linux install specified any host (i.e. %). I can't remember how I solved that problem. It could have been that I merely re-created the user or I moved from DbExpress components to Zeos. I know this is not a good solution, but just to test it out, create a user on your MySQL server and specify the IP address of your client to see if that gets you past the login. Good Luck. On Mon, 9 Aug 2004 12:04:36 +0100, Ant <ant (AT) nowhere (DOT) com> wrote: Quote: Hello, I am having difficulties connecting to MySLQ Server 4.0.20d using dbexpress. I am able to connect to the server fine using either command line or MySQLCC using the same username and password I am trying to use with dbExpress conection. I get this error - Failure to Connect: dbExpress Error: [0x000C] Invalid Username/Password SQL Server Error: Can't connect to MySQL server on 'localhost' (10061) I have checked the username and password in the edit connection, in HostName, I entered the hostname where MySQL is running, and checked that I have correct settings to allow me to access the database I have chosen. For whaever reason, if I am reading the error message correctly, it looks like it is looking for the server on my machine, as it mentions localhost, even though I have entered the actual hostname in the HostName property as both the windows netbios name and also as the actual ip address. Can anyone tell me why it is trying to connect to localhost and not the Server I am specifying? Thanks in advance My machine Using Delphi 7 Pro with update 7.1 WinXP libmysql.dll in system32 folder copied from server MySQLbin Server MySQL 4.0.20d Windows 2003 Server Back to top Ant Guest Posted: Wed Aug 11, 2004 10:28 pm    Post subject: Re: Driving me nuts!! "Bruce Michener" <bmichene (AT) boe (DOT) ca.gov> wrote Quote: It seems to me that I had the same problem when trying to connect to a MySQL server on a Linux box when the user on that Linux install specified any host (i.e. %). I can't remember how I solved that problem. It could have been that I merely re-created the user or I moved from DbExpress components to Zeos. I know this is not a good solution, but just to test it out, create a user on your MySQL server and specify the IP address of your client to see if that gets you past the login. Good Luck. This drove me insane for a few days, it was so frustrating, I could conncet no problem from command prompt and login as root or standard user via command line, but not so through DBExpress, then I looked on BDN and saw a driver for dbexpress for Delphi 5 -7 for MySQL 4.1, 4 and 3.2x it is from crlabs but I downloaded and installed it and it worked first time no problem but still not on direct, but this I can live with distributing the libmysql.dll file on client installs is not as big a pain as having to wait for some one from sysadmin to be available to set up ODBC drivers, since this functionality is locked to all but admins. The parameters for the dbexpress driver and the crlabs driver are identical, so I guess there is a problem with 4.x versions of MySQL and delphi dbexpress drivers, well you would think that, except on another machine with MySQL Server installed locally, the native delphi dbExpress drivers work fine. thanks for the help anyway Back to top Guest Guest Posted: Fri Feb 04, 2005 10:00 pm    Post subject: Re: Driving me nuts!! Quote: Hello, I am having difficulties connecting to MySLQ Server 4.0.20d using dbexpress. I am able to connect to the server fine using either command line or MySQLCC using the same username and password I am trying to use with dbExpress conection. I get this error - Failure to Connect: dbExpress Error: [0x000C] Invalid Username/Password SQL Server Error: Can't connect to MySQL server on 'localhost' (10061) I have checked the username and password in the edit connection, in HostName, I entered the hostname where MySQL is running, and checked that I have correct settings to allow me to access the database I have chosen. For whaever reason, if I am reading the error message correctly, it looks like it is looking for the server on my machine, as it mentions localhost, even though I have entered the actual hostname in the HostName property as both the windows netbios name and also as the actual ip address. Can anyone tell me why it is trying to connect to localhost and not the Server I am specifying? Thanks in advance My machine Using Delphi 7 Pro with update 7.1 WinXP libmysql.dll in system32 folder copied from server MySQLbin Server MySQL 4.0.20d Windows 2003 Server User submitted from AEWNET (http://www.aewnet.com/) Back to top Guest Guest Posted: Fri Feb 04, 2005 10:07 pm    Post subject: Re: Driving me nuts!! I had the same problem. I fixed it by switching to a different"libmysql.dll". Of the four different varieties I had installedon my computer (240kb,244kb,916kb,1040kb), the one that workedwas the 244kb one. It came with either mysqlcc, mysql querybrowser, or with the server install package; sorry that I don'tremember which. Quote: Hello, I am having difficulties connecting to MySLQ Server 4.0.20dusing dbexpress. I am able to connect to the server fine using either commandline or MySQLCC using the same username and password I am trying to use withdbExpress conection. I get this error - Failure to Connect: dbExpress Error: [0x000C] InvalidUsername/Password SQL Server Error: Can't connect to MySQL server on 'localhost'(10061) I have checked the username and password in the editconnection, in HostName, I entered the hostname where MySQL is running, andchecked that I have correct settings to allow me to access the database I havechosen. For whaever reason, if I am reading the error messagecorrectly, it looks like it is looking for the server on my machine, as it mentionslocalhost, even though I have entered the actual hostname in the HostNameproperty as both the windows netbios name and also as the actual ipaddress. Can anyone tell me why it is trying to connect to localhostand not the Server I am specifying? Thanks in advance My machine Using Delphi 7 Pro with update 7.1 WinXP libmysql.dll in system32 folder copied from server MySQLbin Server MySQL 4.0.20d Windows 2003 Server User submitted from AEWNET ([url]http://www.aewnet.com/)[/url] Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.