SQLConnection使用CREATE建立的問題以下是程式碼
------------------------------------------------------------------------------------------
SQLConnection:=TSQLConnection.Create(self);
sqlquery:=TSQLQuery.Create(self);
dsp:=TDataSetProvider.Create(self);
cds:=TClientDataSet.Create(self);
ds:=TDataSource.Create(self);
if not Assigned(datamodule1) then begin
datamodule1:=datamodule1.create(self);
end;
SQLConnection.DriverName:='interbase';
SQLConnection.GetDriverFunc := 'getSQLDriverINTERBASE';
SQLConnection.LibraryName := 'dbexpint.dll';
SQLConnection.VendorLib := 'gds32.dll';
SQLConnection.LoadParamsFromIniFile('c:\MyLoveERP\dbxconnections.ini');
SQLConnection.Open; <====無法OPEN
-------------------------------------------------------------------------------
請問我那有錯誤呢
感謝

你好:

TSQLConnection.LoadParamsFromIniFile 會用 dbxdrivers.ini dbxconnections 的機制去設定相關屬性.

你前面已 Assign SQLConnection 相關屬性(DriverName/LibraryName/GetDriverFunc及VendorLib),

後面只需單純的用 SQLConnection.Params.LoadFromFile('xxx.ini')

xxx.ini 內容(Sample)
===============
DriverName=Interbase
Database=database.gdb
RoleName=RoleName
User_Name=sysdba
Password=masterkey
ServerCharSet=
SQLDialect=3
ErrorResourceFile=
LocaleCode=0000
BlobSize=-1
CommitRetain=False
WaitOnLocks=True
Interbase TransIsolation=ReadCommited
Trim Char=False
===============

另外 TSQLConnection.Params 從 Delphi 2006 起, 變更為 TWideStrings...處理上要注意一下