dbexpress to access MySQL4.0.20 tables

Thread View: borland.public.cppbuilder.database.dbexpress

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Lotfi Thu, 12 Aug 2004 18:02

#86

Author: Lotfi
Date: Thu, 12 Aug 2004 18:02

75 lines
2208 bytes

ok, after being flamed even if the subject interest many newsgroup...
I post again only in this newsgroup this time

I tried a simple connection to access MySQL table
as described in :
http://jmcarayon.developpez.com/dbexpress/
but for BCB 6 Pro

with only one component :
TSQLConnection
I can't connect (1st step)
in fact, It can't even load libmysql.dll (it is in winnt\system32 and in
working directory)
so here is the pb, any ideas ?


here is also my : dbxdrivers.ini

[Installed Drivers]
Interbase=1
MYSQL=1

[Interbase]
GetDriverFunc=getSQLDriverINTERBASE
LibraryName=dbexpint.dll
VendorLib=GDS32.DLL
BlobSize=-1
CommitRetain=False
Database=database.gdb
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=
SQLDialect=1
Interbase TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True

[MYSQL]
GetDriverFunc=getSQLDriverMYSQL
LibraryName=dbexpmys.dll
VendorLib=libmysql.dll
BlobSize=-1
Database=test
ErrorResourceFile=
HostName=localhost
LocaleCode=0000
Password=
User_Name=root

[AutoCommit]
False=0
True=1

[BlockingMode]
False=0
True=1

[WaitOnLocks]
False=1
True=0

[CommitRetain]
False=0
True=1

[Interbase TransIsolation]
ReadCommited=1
RepeatableRead=2

[SQLDialect]
1=0
2=1
3=2

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads