如何通过ADO连接INTERBASE?
安装了INTERBASE5.6,需要通过ASP脚本连接,下面是连接字符串:
Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};SERVER NAME=C:\Program
Files\InterBase Corp\InterBase\examples\database\EMPLOYEE.GDB;USER
NAME=SYSDBA;OPEN MODE=READ/WRITE;SCHEMA CACHE
SIZE=8;LANGDRIVER=;SQLQRYMODE=;SQLPASSTHRU MODE=SHARED AUTOCOMMIT;SCHEMA
CACHE TIME=-1;MAX ROWS=-1;BATCH COUNT=200;ENABLE SCHEMA
CACHE=FALSE;SCHEMA CACHE DIR=;ENABLE BCD=FALSE;BLOBS TO CACHE=64;BLOB
SIZE=32;WAIT ON LOCKS=FALSE;COMMIT RETAIN=FALSE;ROLE
NAME=;PASSWORD=masterkey;
调用ADODB.Connection的Open方法时,报告错误:
INTERSOLV][InterBase ODBC Driver]Insufficient infomation to connect the
data source