SQLCONNECTION 连接数据库问题
SQLCONNECTION
在SQLCONNECTION 控件上 直接 填写 内容 以及PARAMS里的内容,是可以连接到数据库的内容,但是用代码控制 一直提示错误
Exception class EAccessViolation with message 'Access violation at address 01011244 in module 'dbxfb.dll'. Read of address 0013D76F'. Process Project1.exe (2300)
代码 如下:
with SQLFB do begin Connected:=False; DriverName:='Firebird'; GetDriverFunc:='getSQLDriverINTERBASE'; LibraryName:='dbexpint.dll'; VendorLib:='fbclient.dll'; Params.Values['User_Name']:='sysdba'; Params.Values['Password']:='masterkey'; Params.Values['SQLDialect']:='3'; Params.Values['Interbase TransIsolation']:='ReadCommited'; Params.Values['Database']:='192.168.11.9:D:\HC.fdb'; try Connected:=True; Caption:='Connect OK'; except MessageDlg('Connect Error',mtError,[mbyes],0); end; end; with SQLFB do begin Connected:=False; DriverName:='Firebird';//这行不能写到参数里 GetDriverFunc:='getSQLDriverINTERBASE'; LibraryName:='dbexpint.dll'; VendorLib:='fbclient.dll'; Params.Append('user_name=sysdba'); Params.Append('password=masterkey'); Params.Append('sqldialect=3'); Params.Append('interbase transisolation=readcommited'); Params.Append('database=192.168.11.9:D:\HC.fdb'); try Connected:=True; Caption:='Connect OK'; except MessageDlg('Connect Error',mtError,[mbyes],0); end; end;