BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Delphi6 and MySQL4.1.4          BorlandTalk.com Forum Index -> Delphi Databases (dbExpress) View previous topic :: View next topic   Author Message Alistair Guest Posted: Wed Sep 15, 2004 9:15 pm    Post subject: Delphi6 and MySQL4.1.4 Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top paladin Guest Posted: Wed Sep 15, 2004 11:55 pm    Post subject: Re: Delphi6 and MySQL4.1.4 Alistair, I'm sure you read all the borland.public.delphi.database.dbexpress hits regarding this, but let me summarize my view: I don't think D6 supported anything later than MySQL 3.23.nn If you wire up D6 with an early version of MySQL, it just works. There was a beta libmysql.dll placed in Borland's CodeCentral by Ramesh that was purported to work with MySQL 4.01, but I never personally tested it. I have D7.1 and have tested it with both MySQL versions 3. and 4. and it seems to work perfectly. (well, aside from the bugs, which you will also see if you google for 'mysql' in b.p.d.database.dbexpress) hth, paladin "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote Quote: Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top Alistair Guest Posted: Thu Sep 16, 2004 12:19 am    Post subject: Re: Delphi6 and MySQL4.1.4 Well, I must be doing something wrong. I have uninstalled MYSQL4, and reinstalled V3.23.55. Same error.."Unable to Load LibMYSQL.dll". paladin wrote: Quote: Alistair, I'm sure you read all the borland.public.delphi.database.dbexpress hits regarding this, but let me summarize my view: I don't think D6 supported anything later than MySQL 3.23.nn If you wire up D6 with an early version of MySQL, it just works. There was a beta libmysql.dll placed in Borland's CodeCentral by Ramesh that was purported to work with MySQL 4.01, but I never personally tested it. I have D7.1 and have tested it with both MySQL versions 3. and 4. and it seems to work perfectly. (well, aside from the bugs, which you will also see if you google for 'mysql' in b.p.d.database.dbexpress) hth, paladin "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top paladin Guest Posted: Thu Sep 16, 2004 4:00 pm    Post subject: Re: Delphi6 and MySQL4.1.4 make sure that the libmysql.dll that came with the 3.23 version is the ONLY one on your system, and it is in your path somewhere. It is easy to get these confused, since they are all named the same, but the version is important. Or copy it to the directory where D6 makes your project's .exe file. dbl-click on your sqlconnection component. Make SURE the following fields are correct: name, password, database, and hostname. look at the object inspector for sqlconnection. Make SURE Connection name = connection used above DriverName = MYSQL LibraryName = dbexpmysql.dll ( <---- NOT dbexpmys.dll ) VendorLib = LIBMYSQL.DLL make SURE dbexpmysql.dll is in your path or project's .exe directory. I just re-configured my machine for D6 and connected to 3.23.58 with no problems. (There were a couple of updates for D6 you should get from Borland's download site, but I don't think they should be affecting your basic connectivity problem.) good luck paladin "Alistair" Quote: Well, I must be doing something wrong. I have uninstalled MYSQL4, and reinstalled V3.23.55. Same error.."Unable to Load LibMYSQL.dll". paladin wrote: Alistair, I'm sure you read all the borland.public.delphi.database.dbexpress hits regarding this, but let me summarize my view: I don't think D6 supported anything later than MySQL 3.23.nn If you wire up D6 with an early version of MySQL, it just works. There was a beta libmysql.dll placed in Borland's CodeCentral by Ramesh that was purported to work with MySQL 4.01, but I never personally tested it. I have D7.1 and have tested it with both MySQL versions 3. and 4. and it seems to work perfectly. (well, aside from the bugs, which you will also see if you google for 'mysql' in b.p.d.database.dbexpress) hth, paladin "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top Alistair Guest Posted: Mon Sep 20, 2004 1:11 am    Post subject: Re: Delphi6 and MySQL4.1.4 A miracle has happened and I have been able to connect. Next problem: I can not connect to any tables or run any queries! Again, I have searched for info on this with no success. I have the connection, ACTIVE, in my data module. I have put a table component on the form, selected my connection as the connection, but when I drop down to select a table, there are none... If I change the connection property of 'Keep Connected' to true, then I get a 'Invalid Translation'. Any ideas? paladin wrote: Quote: make sure that the libmysql.dll that came with the 3.23 version is the ONLY one on your system, and it is in your path somewhere. It is easy to get these confused, since they are all named the same, but the version is important. Or copy it to the directory where D6 makes your project's .exe file. dbl-click on your sqlconnection component. Make SURE the following fields are correct: name, password, database, and hostname. look at the object inspector for sqlconnection. Make SURE Connection name = connection used above DriverName = MYSQL LibraryName = dbexpmysql.dll ( <---- NOT dbexpmys.dll ) VendorLib = LIBMYSQL.DLL make SURE dbexpmysql.dll is in your path or project's .exe directory. I just re-configured my machine for D6 and connected to 3.23.58 with no problems. (There were a couple of updates for D6 you should get from Borland's download site, but I don't think they should be affecting your basic connectivity problem.) good luck paladin "Alistair" Well, I must be doing something wrong. I have uninstalled MYSQL4, and reinstalled V3.23.55. Same error.."Unable to Load LibMYSQL.dll". paladin wrote: Alistair, I'm sure you read all the borland.public.delphi.database.dbexpress hits regarding this, but let me summarize my view: I don't think D6 supported anything later than MySQL 3.23.nn If you wire up D6 with an early version of MySQL, it just works. There was a beta libmysql.dll placed in Borland's CodeCentral by Ramesh that was purported to work with MySQL 4.01, but I never personally tested it. I have D7.1 and have tested it with both MySQL versions 3. and 4. and it seems to work perfectly. (well, aside from the bugs, which you will also see if you google for 'mysql' in b.p.d.database.dbexpress) hth, paladin "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top Alistair Guest Posted: Mon Sep 20, 2004 3:34 am    Post subject: Re: Delphi6 and MySQL4.1.4 And now something even worse is going on. Whenever I restart the computer, and try to establish a connection, it says the user name and password are invalid, even though I never changed it. I uninstalled and reinstalled it, connected ok, then restarted without changing anything, and got the same error. Alistair wrote: Quote: A miracle has happened and I have been able to connect. Next problem: I can not connect to any tables or run any queries! Again, I have searched for info on this with no success. I have the connection, ACTIVE, in my data module. I have put a table component on the form, selected my connection as the connection, but when I drop down to select a table, there are none... If I change the connection property of 'Keep Connected' to true, then I get a 'Invalid Translation'. Any ideas? paladin wrote: make sure that the libmysql.dll that came with the 3.23 version is the ONLY one on your system, and it is in your path somewhere. It is easy to get these confused, since they are all named the same, but the version is important. Or copy it to the directory where D6 makes your project's .exe file. dbl-click on your sqlconnection component. Make SURE the following fields are correct: name, password, database, and hostname. look at the object inspector for sqlconnection. Make SURE Connection name = connection used above DriverName = MYSQL LibraryName = dbexpmysql.dll ( <---- NOT dbexpmys.dll ) VendorLib = LIBMYSQL.DLL make SURE dbexpmysql.dll is in your path or project's .exe directory. I just re-configured my machine for D6 and connected to 3.23.58 with no problems. (There were a couple of updates for D6 you should get from Borland's download site, but I don't think they should be affecting your basic connectivity problem.) good luck paladin "Alistair" news:4148DC0D.4010706 (AT) co-sys (DOT) co.nz... Well, I must be doing something wrong. I have uninstalled MYSQL4, and reinstalled V3.23.55. Same error.."Unable to Load LibMYSQL.dll". paladin wrote: Alistair, I'm sure you read all the borland.public.delphi.database.dbexpress hits regarding this, but let me summarize my view: I don't think D6 supported anything later than MySQL 3.23.nn If you wire up D6 with an early version of MySQL, it just works. There was a beta libmysql.dll placed in Borland's CodeCentral by Ramesh that was purported to work with MySQL 4.01, but I never personally tested it. I have D7.1 and have tested it with both MySQL versions 3. and 4. and it seems to work perfectly. (well, aside from the bugs, which you will also see if you google for 'mysql' in b.p.d.database.dbexpress) hth, paladin "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote in message news:4148b105$2 (AT) newsgroups (DOT) borland.com... Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top paladin Guest Posted: Mon Sep 20, 2004 6:45 pm    Post subject: Re: Delphi6 and MySQL4.1.4 you might also consider starting the MySQL server on *your* dev machine, and use 'localhost' as the machine name / IP address. This will eliminate the possibilities of hardware, loose connections, cables, etc. Then again make SURE of all versions, make sure only ONE copy of the .dll's exist (and are in the path). hth! pal "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote Quote: And now something even worse is going on. Whenever I restart the computer, and try to establish a connection, it says the user name and password are invalid, even though I never changed it. I uninstalled and reinstalled it, connected ok, then restarted without changing anything, and got the same error. Alistair wrote: A miracle has happened and I have been able to connect. Next problem: I can not connect to any tables or run any queries! Again, I have searched for info on this with no success. I have the connection, ACTIVE, in my data module. I have put a table component on the form, selected my connection as the connection, but when I drop down to select a table, there are none... If I change the connection property of 'Keep Connected' to true, then I get a 'Invalid Translation'. Any ideas? paladin wrote: make sure that the libmysql.dll that came with the 3.23 version is the ONLY one on your system, and it is in your path somewhere. It is easy to get these confused, since they are all named the same, but the version is important. Or copy it to the directory where D6 makes your project's .exe file. dbl-click on your sqlconnection component. Make SURE the following fields are correct: name, password, database, and hostname. look at the object inspector for sqlconnection. Make SURE Connection name = connection used above DriverName = MYSQL LibraryName = dbexpmysql.dll ( <---- NOT dbexpmys.dll ) VendorLib = LIBMYSQL.DLL make SURE dbexpmysql.dll is in your path or project's .exe directory. I just re-configured my machine for D6 and connected to 3.23.58 with no problems. (There were a couple of updates for D6 you should get from Borland's download site, but I don't think they should be affecting your basic connectivity problem.) good luck paladin "Alistair" news:4148DC0D.4010706 (AT) co-sys (DOT) co.nz... Well, I must be doing something wrong. I have uninstalled MYSQL4, and reinstalled V3.23.55. Same error.."Unable to Load LibMYSQL.dll". paladin wrote: Alistair, I'm sure you read all the borland.public.delphi.database.dbexpress hits regarding this, but let me summarize my view: I don't think D6 supported anything later than MySQL 3.23.nn If you wire up D6 with an early version of MySQL, it just works. There was a beta libmysql.dll placed in Borland's CodeCentral by Ramesh that was purported to work with MySQL 4.01, but I never personally tested it. I have D7.1 and have tested it with both MySQL versions 3. and 4. and it seems to work perfectly. (well, aside from the bugs, which you will also see if you google for 'mysql' in b.p.d.database.dbexpress) hth, paladin "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote in message news:4148b105$2 (AT) newsgroups (DOT) borland.com... Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top Alistair Guest Posted: Tue Sep 21, 2004 10:21 pm    Post subject: Re: Delphi6 and MySQL4.1.4 I am running it with Localhost, the dll is in my search path, and there is only one version of it. I must be doing something real obvious wrong. I have checked everything as far as I know. I can connect using PHPMYAdmin. Did you read the previous question about not gettng any tables to work? paladin wrote: Quote: you might also consider starting the MySQL server on *your* dev machine, and use 'localhost' as the machine name / IP address. This will eliminate the possibilities of hardware, loose connections, cables, etc. Then again make SURE of all versions, make sure only ONE copy of the .dll's exist (and are in the path). hth! pal "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote And now something even worse is going on. Whenever I restart the computer, and try to establish a connection, it says the user name and password are invalid, even though I never changed it. I uninstalled and reinstalled it, connected ok, then restarted without changing anything, and got the same error. Alistair wrote: A miracle has happened and I have been able to connect. Next problem: I can not connect to any tables or run any queries! Again, I have searched for info on this with no success. I have the connection, ACTIVE, in my data module. I have put a table component on the form, selected my connection as the connection, but when I drop down to select a table, there are none... If I change the connection property of 'Keep Connected' to true, then I get a 'Invalid Translation'. Any ideas? paladin wrote: make sure that the libmysql.dll that came with the 3.23 version is the ONLY one on your system, and it is in your path somewhere. It is easy to get these confused, since they are all named the same, but the version is important. Or copy it to the directory where D6 makes your project's .exe file. dbl-click on your sqlconnection component. Make SURE the following fields are correct: name, password, database, and hostname. look at the object inspector for sqlconnection. Make SURE Connection name = connection used above DriverName = MYSQL LibraryName = dbexpmysql.dll ( <---- NOT dbexpmys.dll ) VendorLib = LIBMYSQL.DLL make SURE dbexpmysql.dll is in your path or project's .exe directory. I just re-configured my machine for D6 and connected to 3.23.58 with no problems. (There were a couple of updates for D6 you should get from Borland's download site, but I don't think they should be affecting your basic connectivity problem.) good luck paladin "Alistair" news:4148DC0D.4010706 (AT) co-sys (DOT) co.nz... Well, I must be doing something wrong. I have uninstalled MYSQL4, and reinstalled V3.23.55. Same error.."Unable to Load LibMYSQL.dll". paladin wrote: Alistair, I'm sure you read all the borland.public.delphi.database.dbexpress hits regarding this, but let me summarize my view: I don't think D6 supported anything later than MySQL 3.23.nn If you wire up D6 with an early version of MySQL, it just works. There was a beta libmysql.dll placed in Borland's CodeCentral by Ramesh that was purported to work with MySQL 4.01, but I never personally tested it. I have D7.1 and have tested it with both MySQL versions 3. and 4. and it seems to work perfectly. (well, aside from the bugs, which you will also see if you google for 'mysql' in b.p.d.database.dbexpress) hth, paladin "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote in message news:4148b105$2 (AT) newsgroups (DOT) borland.com... Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. Back to top paladin Guest Posted: Wed Sep 22, 2004 3:31 pm    Post subject: Re: Delphi6 and MySQL4.1.4 "Alistair" <alistair (AT) co-sys (DOT) co.nz> wrote Quote: I am running it with Localhost, the dll is in my search path, and there is only one version of it. I must be doing something real obvious wrong. I have checked everything as far as I know. I can connect using PHPMYAdmin. Did you read the previous question about not gettng any tables to work? yes, I did. bizarre. do you have all D6 updates loaded? I'm not sure I know what to suggest next for you to try. But trying an entirely different computer comes to mind.... sorry I couldn't help. -paladin Back to top hu zhenghui Guest Posted: Sat Oct 16, 2004 8:49 am    Post subject: Re: Delphi6 and MySQL4.1.4 dbexpmysql.dll in delphi 7 is "Borland dbExpress MySQL 3.23.x driver". After you install delphi 7.1 update, it will be "Borland dbExpress MySQL 4.0.xx driver", the same with delphi 8. It will works fine with MySQL 4.0.18. -- If my answer can't solve you problem, welcome mail me the project files. [email]webmaster (AT) huzhenghui (DOT) 51.net[/email] "Alistair" <alistair (AT) co-sys (DOT) co.nz> ???? news:4148b105$2 (AT) newsgroups (DOT) borland.com... Quote: Hi there, I have had no end of problems trying to connect to MySQL using dbexpress. I am using Delphi6, and have MySQL4.1.4 installed. I can use PhpMyAdmin to connect to it. I have put a DBExpress SQLConnection on my Form, Selected MYSQL from the DriverName list, tried to connect, and got "Unable to Load LibMYSQL.dll". What can I be doing wrong? Some old newsgroup discussions have suggested using the LibMySQL.dll from MYSQL 3.53.22? I have tried this and it still doesn't work... Please help. 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 (dbExpress) 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.