请问VB连接INTERBASE数据库（.gdb）的连接字符串如何写？急！谢谢!在线等待！

[aloka]

请问VB连接INTERBASE数据库（.gdb）的连接字符串如何写？急！谢谢!在线等待！

[stwx]

用ODBC吧

[aloka]

连不上

[lihonggen0]

Interbase
ODBC, Easysoft


Local computer:
"Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password"


Remote Computer:
"Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password"
Read more about this driver: Easysoft ODBC-Interbase driver >>

ODBC, Intersolv


Local computer:
"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password"


Remote Computer:
"Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password"

[ningkang]

up

[bluesky35]

可以先建立一个数据源(ODBC),然后通过数据库访问对象DAO,ADO或RDO连接数据源,访问Interbase数据库,举例如下:
ADO的例子:
Dim db as ADODB.connection
Dim rs as ADODB.recordset
Private Sub Form_Load()
dim strconn as string
dim strsql as string
set db=new adodb.connection
strconn="provider=sqloledb;data source=建立的指向interbase数据库的数据源名;u ser id=用户名;password=密码;"
db.open strconn
strsql="sql语句"
rs.open strsql,db,adopenstatic,adlockreadonly
End Sub
有问题可以联系我
QQ:81806701
HOTMAIL:[e-mail]