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)
代码 如下:
- Delphi(Pascal) code
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;[解决办法]
SQLCONNECTION这个控件是否放到了窗体?没有看到你代码中有这个控件的Create语句。
[解决办法]
- Delphi(Pascal) code
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;