标签归档:Delphi

dbexpress增加Firebird连接

修改 dbxconnections.ini。

增加内容:

[FBConnection]
DriverName=Firebird
Database=database.fb
RoleName=RoleName
User_Name=SYSDBA
Password=masterkey
ServerCharSet=
SQLDialect=1
ErrorResourceFile=
LocaleCode=0000
BlobSize=-1
CommitRetain=True
WaitOnLocks=True
Interbase TransIsolation=ReadCommited
Trim Char=False

修改 dbxdrivers.ini:

[Installed Drivers]
DB2=1
Firebird=1    
Interbase=1
MySQL=1
Oracle=1
Informix=1
MSSQL=1

增加内容:

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

[Firebird TransIsolation]
ReadCommited=1
RepeatableRead=2

delphi7用dbexpress连接mysql5

delphi7官方dbexpress驱动只能连接mysql4及以前的版本,要连接mysql5,到ttp://www.justsoftwaresolutions.co.uk/delphi/dbexpress_and_mysql_5.html下载dbxopenmysql50.dll,然后在配置文件中增加mysql5的相关设置:
[MySQL5]
GetDriverFunc=getSQLDriverMYSQL50
LibraryName=dbxopenmysql50.dll
VendorLib=libmysql.dll
HostName=ServerName
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000