| forme_
37603
|
2009/5/29 14:54:46 |
| 强人!!1 |
| penal
32583
|
2008/1/7 15:47:04 |
| 对MSSQL数据库执行有些存贮过程还是有问题，有时传 出参数没法出来，究其原因是没有把所有的结果集读取完。我想改，可惜代码已经定型了。不好改 |
| dfw@94378
24957
|
2006/7/17 10:17:41 |
dbxconnections.ini, dbxdrivers.ini这两个文件是在
C:\Program Files\Common Files\Borland Shared\DBExpress
安装帮助说明文件是
Install Instructions.txt |
| dfw@94378
24956
|
2006/7/17 10:15:09 |
[Installed Drivers]
DB2=1
Interbase=1
MySQL=1
Oracle=1
Informix=1
MSSQL=1
; Dbxoodbc system odbc manager driver:
OpenOdbc=1
OpenOdbcLevel2=1
; Dbxoodbc Direct Drivers:
; Microsoft: SQL Server | Visual FoxPro | MSJet (Access | dBase | Paradox | CSV) | Oracle.
DbxSQLServer=1
DbxMSFoxPro=1
DbxMSJetAccess=1
DbxMSJetDBase=1
DbxMSJetParadox=1
DbxMSJetExcel=1
DbxMSJetCSV=1
DbxMSOracle=1
; IBM: DB2 | INFORMIX.
DbxDB2=1
DbxInformix=1
; ORACLE:
DbxOracle=1
; "MERANT"/"PB INTERSOLV OEM":
; Merant: dBASE3 | dBASE4 | dBASE5 | Clipper | FoxPro1 | FoxPro25 | FoxPro30
DbxMerantDBase=1
DbxMerantFoxPro=1
DbxMerantClipper=1
; SQLite:
DbxSQLite=1
; INTERBASE | FIREBIRD | YAFILL:
DbxIBPhoenix=1
DbxIBEasysoft=1
DbxIBGemini=1
DbxIBXTG=1
; Paradox: INTERSOLV/DataDirect: ( supports Paradox 3.0, 3.5, 4.0, 4.5, 5.0, 7.0, and 8.0 tables)
DbxParadox=1
;OterroRBase
DbxOterroRBase=1
DbxPostgreSQL=1
; todo: need fill the next:
DbxMySQL=0
DbxSAPDB=0
; SQL Base:
DbxGupta=0
DbxSybase=0
DbxThinkSQL=0
DbxPervasizeSQL=0
DbxPostgreSQL=0
DbxCache=0
DbxFlashFiler=0
;----------
[OpenOdbc]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=odbc32.dll
; On linux platform need replace VendorLib to VendorLibLinux:
VendorLibLinux=odbc32.so
OpenOdbc TransIsolation=ReadCommited
Database=
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=17
[OpenOdbc TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[OpenOdbcLevel2]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=2:odbc32.dll
; On linux platform need replace VendorLib to VendorLibLinux:
VendorLibLinux=2:odbc32.so
OpenOdbc TransIsolation=ReadCommited
Database=
User_Name=user
Password=password
RowsetSize=1
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=17;coMixedFetch=0
[OpenOdbcLevel2 TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxSQLServer]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=sqlsrv32.dll
DbxSQLServer TransIsolation=ReadCommited
; 'OS Authentication' option in odbc connection string: Trusted_Connection=Yes
; Other options in connection string: LANGUAGE=Ukrainian;QueryLog_On=Yes
Database=DATABASE=dbdemos;Trusted_Connection=Yes
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coICloneCon=1;coNetPacketSize=8192;coLockMode=17;coCatPrefix=DATABASE
[DbxSQLServer TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxDB2]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=DB2CLI.DLL;LIBDB2.DLL
DbxDB2 TransIsolation=ReadCommited
Database=DATABASE=dbdemos
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DATABASE
[DbxDB2 TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxInformix]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=iclit09bw.dll;iclit09aw.dll;iclit09b.dll;iclit09a.dll
// thread safe library
VendorLib.Linux.TS=iclit09b.so;iclit09a.so;iclit09bw.so;iclit09aw.so;libthcli.so;libifdrm.so;idmrs09b.so;idmrs09a.so;idmrs09bw.so;idmrs09aw.so
// single thread library (no thread safe)
VendorLib.Linux.ST=iclis09b.so;iclis09a.so;iclis09bw.so;iclis09aw.so;libifcli.so
DbxInformix TransIsolation=ReadCommited
Database=DATABASE=dbdemos;HOST=192.168.5.101;SRVR=ol_pult;SERV=turbo;PRO=olsoctcp;CLOC=ua_UA.1251;DLOC=ua_UA.1251;VMB=0;CURB=1;OPT=;SCUR=0;ICUR=0;OAC=1;OPTOFC=1;RKC=0;ODTYP=0;DDFP=0;DNL=0;RCWC=0
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coIgnoreUnkFldType=1;coCatPrefix=DATABASE
[DbxInformix TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMerantDBase]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=IVDBF15.DLL;PBDBF13.DLL
DbxMerantDBase TransIsolation=ReadCommited
; Versions dBASE are supported (CT): dBASE3 | dBASE4 | dBASE5
Database=DB=E:\Borland\Borland Shared\Data\DBASE\VER_5;CT=dBASE5;LCK=RECORD;AUT=1;CSZ=16;DFE=DBF;FOC=0;IS=1;LCOMP=dBASE;MS=1;USF=1;ULN=0;ULQ=1
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DB
[DbxMerantDBase TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMerantFoxPro]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=IVDBF15.DLL;PBDBF13.DLL
DbxMerantFoxPro TransIsolation=ReadCommited
; Versions FoxPro are supported (CT): FoxPro1 | FoxPro25 | FoxPro30
Database=DB=E:\Borland\Borland Shared\Data\FoxPro;CT=FoxPro30;LCK=RECORD;AUT=1;CSZ=16;DFE=FOX;FOC=0;IS=1;LCOMP=Fox;MS=1;USF=1;ULN=0;ULQ=1
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DB
[DbxMerantFoxPro TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMerantClipper]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=IVDBF15.DLL;PBDBF13.DLL
DbxMerantClipper TransIsolation=ReadCommited
Database=DB=E:\Borland\Borland Shared\Data\Clipper;CT=Clipper;LCK=RECORD;AUT=1;CSZ=16;DFE=CLP;FOC=0;IS=1;LCOMP=Clipper;MS=1;USF=1;ULN=0;ULQ=1
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DB
[DbxMerantClipper TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMSFoxPro]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=VFPODBC.DLL;odbc32.dll
DbxMSJetFoxPro TransIsolation=ReadCommited
Database=DRIVER={Microsoft Visual FoxPro Driver};DefaultDir=E:\Borland\Borland Shared\Data\FoxPro
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DefaultDir
[DbxMSJetFoxPro TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxSQLite]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=SQLITEODBC.DLL
DbxSQLite TransIsolation=ReadCommited
Database=DATABASE=E:\Borland\Borland Shared\Data\SQLite\dbdemos.sllite;StepAPI=0;Timeout=17000;NoWCHAR=0
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coCatPrefix=DATABASE
[DbxSQLite TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxOracle]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=SQORA32.DLL
DbxOracle TransIsolation=ReadCommited
Database=DBQ=SMROL;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;FRL=F;MTS=F;CSR=F;PFC=10;TLO=0;UID=Anonymous;PWD=Unknown
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coSchemFlt=0;coCatPrefix=UID
[DbxOracle TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMSOracle]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=MSORCL32.DLL
DbxMSOracle TransIsolation=ReadCommited
Database=DATABASE=dbdemos;FRL=T
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DATABASE
[DbxMSOracle TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMSJetAccess]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=odbcjt32.dll;odbc32.dll
DbxMSJetAccess TransIsolation=ReadCommited
Database=DRIVER={Microsoft Access Driver (*.mdb)};DBQ=E:\BORLAND\Borland Shared\Data\dbdemos.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=17;ImplicitCommitSync=Yes;ExtendedAnsiSQL=1;SafeTransactions=1;UserCommitSync=Yes
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DBQ
[DbxMSJetAccess TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMSJetDBase]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=odbcjt32.dll;odbc32.dll
DbxMSJetDBase TransIsolation=ReadCommited
Database=DRIVER={Microsoft dBase Driver (*.dbf)};DefaultDir=E:\Borland\Borland Shared\Data\DBASE\VER_5;DriverId=533;MaxBufferSize=2048;PageTimeout=17
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DefaultDir
[DbxMSJetDBase TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMSJetParadox]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=odbcjt32.dll;odbc32.dll
DbxMSJetParadox TransIsolation=ReadCommited
Database=DRIVER={Microsoft Paradox Driver (*.db )};DefaultDir=E:\BORLAND\BORLAND SHARED\DATA\PDX5;DriverId=538;FIL=Paradox 5.X;MaxBufferSize=2048;PageTimeout=17
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DefaultDir
[DbxMSJetParadox TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMSJetExcel]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=odbcjt32.dll;odbc32.dll
DbxMSJetExcel TransIsolation=ReadCommited
Database=DRIVER={Microsoft Excel Driver (*.xls)};DBQ=E:\My Documents\MyXlsFile.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=17
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DBQ
[DbxMSJetExcel TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxMSJetCSV]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=odbcjt32.dll;odbc32.dll
DbxMSJetCSV TransIsolation=ReadCommited
Database=DRIVER={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=E:\BORLAND\BORLAND SHARED\DATA\CSV;DriverId=27;FIL=text;MaxBufferSize=2048;PageTimeout=17
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DefaultDir
[DbxMSJetCSV TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxIBPhoenix]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=ODBCJDBC.DLL
DbxIBPhoenix TransIsolation=ReadCommited
Database=Driver=OdbcJdbc;Client=fbclient.dll;Dbname=C:\dbdemos.fdb;CHARSET=CYRL;UID=SYSDBA;PWD=masterkey
Database.Local=Dbname=C:\dbdemos.fdb;...
Database.Local.Embed=Driver=OdbcJdbc;Client=F:\INTERBASE\FIREBIRD\EM\fbembed.dll;Dialect=3;Dbname=E:\Borland\Borland Shared\Data\INTERBASE\dbdemos.fdb;UID=SYSDBA;PWD=masterkey
Database.Tcp=Dbname=MyHost:C:\dbdemos.fdb;...
Database.Pipe=Dbname=\AMD1800\MyHost:C:\dbdemos.fdb;...
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DBNAME
[DbxIBPhoenix TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxIBEasysoft]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=IB6ODBC.DLL
DbxIBEasysoft TransIsolation=ReadCommited
Database=DB=AMD1800:C:\dbdemos.gdb;Dialect=3;CHARSET=CYRL;UID=SYSDBA;PWD=masterkey
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DB
[DbxIBEasysoft TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxIBGemini]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=ibgem20.dll
DbxIBGemini TransIsolation=ReadCommited
Database=PROTOCOL=2;SERVER=AMD1800;DATABASE=C:\dbdemos.gdb;CHARSET=CYRL;VERSION=6;DIALECT=3;OPTIONS=256;UID=SYSDBA;PWD=masterkey
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DATABASE
[DbxIBGemini TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
[DbxIBXTG]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
; ODBC 2.0
VendorLib=ib6xtg10.dll
DbxIBXTG TransIsolation=ReadCommited
; Should be necessarily specified real DSN:
; DSN=dsn_ib6_xtg
; XTG Parameter DATABASE ignores:
; :(
; The password is specified as a pattern. Since in the end there should be a symbol ";":
; PWD=%;
Database=DSN=dsn_ib6_xtg;DATABASE=AMD1800:C:\dbdemos.gdb;UID=SYSDBA;PWD=%;
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DATABASE
[DbxIBXTG TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
; Paradox: INTERSOLV/DataDirect: ( supports Paradox 3.0, 3.5, 4.0, 4.5, 5.0, 7.0, and 8.0 tables)
[DbxParadox]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
; It is required to set path to pbidp13.dll
VendorLib=pbidp13.dll;ivdp15.dll
DbxParadox TransIsolation=ReadCommited
Database=DATABASE=E:\Borland\Borland Shared\Data
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DATABASE
[DbxParadox TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
;OterroRBase
[DbxOterroRBase]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=oterro.dll;2:ot2k_32.dll
DbxOterroRBase TransIsolation=ReadCommited
Database=DBQ=C:\RBTI\Oterro25\Samples\DB\test.rb1
User_Name=
Password=
RowsetSize=1
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DBQ
[DbxOterroRBase TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
;----------
;PostgreSQL
[DbxPostgreSQL]
LibraryName=dbxoodbc.dll
GetDriverFunc=getSQLDriverODBC
VendorLib=psqlodbc.dll
DbxOterroRBase TransIsolation=ReadCommited
Database=DATABASE=dbdemos_unicode;SERVER=127.0.0.1;PORT=5432;Socket=4096;UnknownSizes=0;MaxVarcharSize=2048;MaxLongVarcharSize=8190;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0
User_Name=
Password=
RowsetSize=1
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coLockMode=-1;coCatPrefix=DATABASE
[DbxPostgreSQL TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
[DB2]
GetDriverFunc=getSQLDriverDB2
LibraryName=dbexpdb2.dll
VendorLib=db2cli.dll
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
DB2 TransIsolation=ReadCommited
[Interbase]
GetDriverFunc=getSQLDriverINTERBASE
LibraryName=dbexpint.dll
VendorLib=gds32.dll
Database=database.gdb
RoleName=RoleName
User_Name=sysdba
Password=masterkey
ServerCharSet=
SQLDialect=1
BlobSize=-1
CommitRetain=False
WaitOnLocks=True
ErrorResourceFile=
LocaleCode=0000
Interbase TransIsolation=ReadCommited
Trim Char=False
[MySQL]
GetDriverFunc=getSQLDriverMYSQL
LibraryName=dbexpmysql.dll
VendorLib=libmysql.dll
HostName=ServerName
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
[Oracle]
GetDriverFunc=getSQLDriverORACLE
LibraryName=dbexpora.dll
VendorLib=oci.dll
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Oracle TransIsolation=ReadCommited
RowsetSize=20
OS Authentication=False
Multiple Transaction=False
Trim Char=False
[Informix]
GetDriverFunc=getSQLDriverINFORMIX
LibraryName=dbexpinf.dll
VendorLib=isqlb09a.dll
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Informix TransIsolation=ReadCommited
Trim Char=False
[MSSQL]
GetDriverFunc=getSQLDriverMSSQL
LibraryName=dbexpmss.dll
VendorLib=oledb
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
MSSQL TransIsolation=ReadCommited
OS Authentication=False
[AutoCommit]
False=0
True=1
[BlockingMode]
False=0
True=1
[WaitOnLocks]
False=1
True=0
[CommitRetain]
False=0
True=1
[OS Authentication]
False=0
True=1
[Multiple Transaction]
False=0
True=1
[Trim Char]
False=0
True=1
[DB2 TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
[Interbase TransIsolation]
ReadCommited=1
RepeatableRead=2
[Oracle TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
[Informix TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
[MSSQL TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
[SQLDialect]
1=0
2=1
3=2 |
| dfw@94378
24955
|
2006/7/17 10:14:28 |
| dbxdrivers.ini |
| dfw@94378
24954
|
2006/7/17 10:13:44 |
[DB2Connection]
DriverName=DB2
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
DB2 TransIsolation=ReadCommited
[MySQLConnection]
DriverName=MySQL
HostName=ServerName
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
[IBConnection]
DriverName=Interbase
Database=database.gdb
RoleName=RoleName
User_Name=sysdba
Password=masterkey
ServerCharSet=
SQLDialect=1
ErrorResourceFile=
LocaleCode=0000
BlobSize=-1
CommitRetain=False
WaitOnLocks=True
Interbase TransIsolation=ReadCommited
Trim Char=False
[OracleConnection]
DriverName=Oracle
DataBase=Database Name
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Oracle TransIsolation=ReadCommited
OS Authentication=False
Multiple Transaction=False
Trim Char=False
[InformixConnection]
DriverName=Informix
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Informix TransIsolation=ReadCommited
Trim Char=False
[MSSQLConnection]
DriverName=MSSQL
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
MSSQL TransIsolation=ReadCommited
OS Authentication=False
;----------
[OpenOdbc:Prompt]
DriverName=OpenOdbc
Database=?
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=20
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
[OpenOdbc:SimpleDSN]
DriverName=OpenOdbc
Database=DSN=DBDEMOS
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=20
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
[OpenOdbc:ConnectionString]
' Code a complete ODBC connect string -
' This allows for additions database-specific options (eg DB, LANG etc)
DriverName=OpenOdbc
Database=?
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=20
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DSN=SAMPLE;DB=master;LANG=chinese;UID=user;PWD=secret;coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
[OpenOdbc:FileDSN]
' Set up a file DSN in the working directory
' Useful if you don't want to set up a DSN specially
DriverName=OpenOdbc
Database=?
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=20
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=FILEDSN=C:\Work\odbcsmaple.dsn;coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
[OpenOdbc:DriverDSN]
' Useful if you don't want to set up a DSN specially
DriverName=OpenOdbc
DriverName=?
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=20
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\access\samples\northwind.mdb;coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
;----------
[Dbx:SQLServer(OS Authentication)]
DriverName=DbxSQLServer
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DATABASE=dbdemos;Trusted_Connection=Yes;LANGUAGE=English;coICloneCon=1;coNetPacketSize=8192;coLockMode=17;coCatPrefix=DATABASE
;----------
[Dbx:SQLServer]
DriverName=DbxSQLServer
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DATABASE=dbdemos;Trusted_Connection=No;LANGUAGE=German;coICloneCon=1;coNetPacketSize=8192;coLockMode=17;coCatPrefix=DATABASE
;----------
[Dbx:DB2]
DriverName=DbxDB2
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DATABASE=dbdemos;coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DATABASE
;----------
[Dbx:Informix]
DriverName=DbxInformix
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DATABASE=dbdemos;HOST=192.168.5.101;SRVR=ol_pult;SERV=turbo;PRO=olsoctcp;CLOC=ua_UA.1251;DLOC=ua_UA.1251;VMB=0;CURB=1;OPT=;SCUR=0;ICUR=0;OAC=1;OPTOFC=1;RKC=0;ODTYP=0;DDFP=0;DNL=0;RCWC=0;coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coIgnoreUnkFldType=1;coCatPrefix=DATABASE
;----------
[Dbx:Merant:DBase]
DriverName=DbxMerantDBase
; Versions dBASE are supported (CT): dBASE3 | dBASE4 | dBASE5
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DB=E:\Borland\Borland Shared\Data\DBASE\VER_5;CT=dBASE5;LCK=RECORD;AUT=1;CSZ=16;DFE=DBF;FOC=0;IS=1;LCOMP=dBASE;MS=1;USF=1;ULN=0;ULQ=1;coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DB
;----------
[Dbx:Merant:FoxPro]
DriverName=DbxMerantFoxPro
; Versions FoxPro are supported (CT): FoxPro1 | FoxPro25 | FoxPro30
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DB=E:\Borland\Borland Shared\Data\FoxPro;CT=FoxPro30;LCK=RECORD;AUT=1;CSZ=16;DFE=FOX;FOC=0;IS=1;LCOMP=Fox;MS=1;USF=1;ULN=0;ULQ=1;coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DB
;----------
[Dbx:Merant:Clipper]
DriverName=DbxMerantClipper
; Versions FoxPro are supported (CT): FoxPro1 | FoxPro25 | FoxPro30
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DB=E:\Borland\Borland Shared\Data\Clipper;CT=Clipper;LCK=RECORD;AUT=1;CSZ=16;DFE=CLP;FOC=0;IS=1;LCOMP=Clipper;MS=1;USF=1;ULN=0;ULQ=1;coCatPrefix=DB;coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960
;----------
[Dbx:MS:FoxPro]
DriverName=DbxMSFoxPro
; Versions FoxPro are supported (CT): FoxPro1 | FoxPro25 | FoxPro30
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Microsoft Visual FoxPro Driver};DefaultDir=E:\Borland\Borland Shared\Data\FoxPro;coLockMode=-1;coCatPrefix=DefaultDir
;----------
[Dbx:SQLite]
DriverName=DbxSQLite
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DATABASE=E:\Borland\Borland Shared\Data\SQLite\dbdemos.sllite;StepAPI=0;Timeout=17000;NoWCHAR=0;coCatPrefix=DATABASE
;----------
[Dbx:Oracle]
DriverName=DbxOracle
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DBQ=SMROL;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;FRL=F;MTS=F;CSR=F;PFC=10;TLO=0;UID=Anonymous;PWD=Unknown;coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coSchemFlt=0;coCatPrefix=UID
;----------
[Dbx:MS:Oracle]
DriverName=DbxMSOracle
;Database=DATABASE=dbdemos;FRL=T
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
;Custom String=coNetPacketSize=8192;coLockMode=-1;coBlobChunkSize=40960;coCatPrefix=DATABASE
Custom String=coConnectionString=SERVER=TNS_NAME;UID=anonymous;PWD=password;coLockMode=-1;coSchemFlt=1;coCatPrefix=UID
;----------
[Dbx:MSJet:Access]
DriverName=DbxMSJetAccess
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Microsoft Access Driver (*.mdb)};DBQ=E:\BORLAND\Borland Shared\Data\dbdemos.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=17;ImplicitCommitSync=Yes;ExtendedAnsiSQL=1;SafeTransactions=1;UserCommitSync=Yes;coLockMode=-1;coCatPrefix=DBQ
;----------
[Dbx:MSJet:DBase]
DriverName=DbxMSJetDBase
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Microsoft dBase Driver (*.dbf)};DefaultDir=E:\Borland\Borland Shared\Data\DBASE\VER_5;DriverId=533;MaxBufferSize=2048;PageTimeout=17;coLockMode=-1;coCatPrefix=DefaultDir
;----------
[Dbx:MSJet:Paradox]
DriverName=DbxMSJetParadox
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Microsoft Paradox Driver (*.db )};DefaultDir=E:\BORLAND\BORLAND SHARED\DATA\PDX5;DriverId=538;FIL=Paradox 5.X;MaxBufferSize=2048;PageTimeout=17;coLockMode=-1;coCatPrefix=DefaultDir
;----------
[Dbx:MSJet:Excel]
DriverName=DbxMSJetExcel
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Microsoft Excel Driver (*.xls)};DBQ=E:\My Documents\MyXlsFile.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=17;coLockMode=-1;coCatPrefix=DBQ
;----------
[Dbx:MSJet:CSV]
DriverName=DbxMSJetCSV
Database=?
User_Name=user
Password=password
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=E:\BORLAND\BORLAND SHARED\DATA\CSV;DriverId=27;FIL=text;MaxBufferSize=2048;PageTimeout=17;coLockMode=-1;coCatPrefix=DefaultDir
;----------
[Dbx:IB:Phoenix]
DriverName=DbxIBPhoenix
Database=?
User_Name=SYSDBA
Password=masterkey
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=Driver=OdbcJdbc;Client=fbclient.dll;Dbname=C:\dbdemos.fdb;CHARSET=CYRL;UID=SYSDBA;PWD=masterkey;coLockMode=-1;coCatPrefix=DBNAME
; -- examples:
; Local: Custom String=Dbname=C:\dbdemos.fdb;...
; Local Embed: Custom String=Driver=OdbcJdbc;Client=F:\INTERBASE\FIREBIRD\EM\fbembed.dll;Dialect=3;Dbname=E:\Borland\Borland Shared\Data\INTERBASE\dbdemos.fdb;UID=SYSDBA;PWD=masterkey;coLockMode=-1;coCatPrefix=DBNAME
; TCP: Custom String=Dbname=MyHost:C:\dbdemos.fdb;...
; PIPE: Custom String=Dbname=\AMD1800\MyHost:C:\dbdemos.fdb;...
;----------
[Dbx:IB:Easysoft]
DriverName=DbxIBEasysoft
Database=?
User_Name=SYSDBA
Password=masterkey
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DB=AMD1800:C:\dbdemos.gdb;Dialect=3;CHARSET=CYRL;UID=SYSDBA;PWD=masterkey;coLockMode=-1;coCatPrefix=DB
;----------
[Dbx:IB:Gemini]
DriverName=DbxIBGemini
Database=?
User_Name=SYSDBA
Password=masterkey
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=PROTOCOL=2;SERVER=AMD1800;DATABASE=C:\dbdemos.gdb;CHARSET=CYRL;VERSION=6;DIALECT=3;OPTIONS=256;UID=SYSDBA;PWD=masterkey;coLockMode=-1;coCatPrefix=DATABASE
;----------
[Dbx:IB:XTG]
DriverName=DbxIBXTG
; Should be necessarily specified real DSN:
; DSN=dsn_ib6_xtg
; XTG Parameter DATABASE ignores:
; :(
; The password is specified as a pattern. Since in the end there should be a symbol ";":
; PWD=%;
;Database=DSN=dsn_ib6_xtg;DATABASE=AMD1800:C:\dbdemos.gdb;UID=SYSDBA;PWD=%;
Database=?
User_Name=SYSDBA
Password=masterkey
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DSN=dsn_ib6_xtg;DATABASE=AMD1800:C:\dbdemos.gdb;UID=SYSDBA;PWD=%;coLockMode=-1;coCatPrefix=DATABASE
;----------
[Dbx:Paradox]
DriverName=DbxParadox
Database=?
User_Name=
Password=
RowsetSize=20
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DATABASE=E:\Borland\Borland Shared\Data;coLockMode=-1;coCatPrefix=DATABASE
;----------
[OpenOdbc:OterroRBase2]
DriverName=OpenOdbcLevel2
Database=?
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Oterro Database Driver (*.rb1)};DBQ=C:\RBTI\Oterro25\Samples\DB\test.rb1;coCatPrefix=DBQ;coMixedFetch=0
;----------
[OpenOdbc:OterroRBase3]
DriverName=OpenOdbc
Database=?
User_Name=name
Password=secret
BlobSize=-1
RowsetSize=1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DRIVER={Oterro 3.0 Database Driver (*.rb1)};DBQ=C:\RBTI\Oterro25\Samples\DB\test.rb1;coCatPrefix=DBQ;coMixedFetch=0
;----------
[Dbx:OterroRBase]
DriverName=DbxOterroRBase
Database=?
User_Name=
Password=
RowsetSize=1
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DBQ=C:\RBTI\Oterro25\Samples\DB\test.rb1;coLockMode=-1;coCatPrefix=DBQ
;----------
[Dbx:PostgreSQL]
DriverName=DbxPostgreSQL
Database=?
User_Name=
Password=
RowsetSize=1
BlobSize=-1
; Delphi7Up or 'Delphi6 + SqlExprFix.pas'
Trim Char=True
Custom String=coConnectionString=DATABASE=dbdemos_unicode;SERVER=127.0.0.1;PORT=5432;Socket=4096;UnknownSizes=0;MaxVarcharSize=2048;MaxLongVarcharSize=8190;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;coLockMode=-1;coCatPrefix=DATABASE
;---------- |
| dfw@94378
24953
|
2006/7/17 10:13:07 |
| dbxconnections.ini |
| dfw@94378
24952
|
2006/7/17 10:12:29 |
把Release里的dbxoodbc.dll.rel.7z解出来
有一个dbxoodbc.dll放到delphi安装目录/bin里面
然后看readme.txt修改
dbxconnections.ini, dbxdrivers.ini
重启delphi再拉个SQLConnection来，就看到里面多了好多个连接。 |
| alixer
24936
|
2006/7/15 16:42:37 |
| 楼主啊，如何安装啊，我运行BAT文件，说是找不到路径哦 |
| alixer
24935
|
2006/7/15 16:38:30 |
| 呵呵。谢谢啊！！！ |
| dfw@94378
24588
|
2006/6/27 8:49:48 |
就是让Delphi自带的dbexpress支持更多的数据连接类型。
就像插件一样。
例如:dbexpress本身不支持Access数据库和ODBC连接，用这个就可以了。这样通过ODBC就可以间接的支持Access或其它的数据库. |
| zhenlong
24539
|
2006/6/24 23:55:44 |
| 这个是什么地干活？和delph带的dbexpress有啥出入？偶比较菜。 |
