🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.dbexpress
Article #86

dbexpress to access MySQL4.0.20 tables

#86
From: 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
Technical Details
Message-ID: <411bb035$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,b069534d756acd17,start
X-Google-Attributes: gidfb4e2,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Lotfi" <llbaghli(nospam)@ifrance.com>
Newsgroups: borland.public.cppbuilder.database.dbexpress
Subject: dbexpress to access MySQL4.0.20 tables
Date: Thu, 12 Aug 2004 20:02:58 +0200
Lines: 79
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4939.300
NNTP-Posting-Host: 82.66.254.150
Message-ID: <411bb035$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1092333621 82.66.254.150 (12 Aug 2004 11:00:21 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail