Cannot connect to MySQL 5 with D2007 (cannot find dbxmys30)

Cannot connect to MySQL 5 with D2007 (cannot find dbxmys30)

Post by Jan Dogge » Thu, 20 Sep 2007 00:14:22


Hi all

Delphi2007 Update 1
TSQLConnection (dbExpress4) set to the mySQL test database on localhost

On the SQLConnection.Open (before login) I get 'cannot load
dbxmys30.dll'. It is in c:\program files\codegear\rad studio\5.0\bin
(together with dbxmysA30.dll) and that dir is the first one in my PATH.

Any ideas?

[MySQL] section in dbxdrivers.ini:
DriverUnit=DBXDynalink
DriverPackageLoader=TDBXDynalinkDriverLoader
DriverPackage=DBXCommonDriver110.bpl
DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader
DriverAssembly=Borland.Data.DbxCommonDriver,Version=
11.0.5000.0,Culture=neutral,PublicKeyToken=a91a7c5705831a4f

GetDriverFunc=getSQLDriverMYSQL
LibraryName=dbxmys30.dll
VendorLib=libmysql.dll
HostName=ServerName
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Compressed=False
Encrypted=False

No [mySQLConnection] entry in dbxconnections.ini

I traced the Open statement into the LoadDriverLibrary procedure.
Finally, way deep in
function TDBXDynalinkDriverCommonLoader.Load(DriverDef: TDBXDriverDef):
TDBXDriver;
the call to FMethodTable.FDBXLoader_GetDriver fails
What that code is doing I have no idea ;-)


Thanks in advance
Jan
 
 
 

Cannot connect to MySQL 5 with D2007 (cannot find dbxmys30)

Post by Jan Dogge » Thu, 20 Sep 2007 16:40:24

Followup:

If I try to use data Explorer to connect to the DB
I get 'dbExpress vendor initialization failed'.

 
 
 

Cannot connect to MySQL 5 with D2007 (cannot find dbxmys30)

Post by Ghrot » Sat, 29 Sep 2007 23:46:34

>Hi all

Try to copy your dlls in your project's directory.



--- posted by geoForum on http://www.yqcomputer.com/