连接Interbase的字符串

ODBC, Easysoft

Local computer

Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydatabase.gdb; Uid=myUsername;Pwd=myPassword;

Remote Computer

Driver={Easysoft IB6 ODBC};Server=myServerAddress;Database=ComputerName:C:\mydatabase.gdb; Uid=myUsername;Pwd=myPassword;

ODBC, Intersolv

Local computer

Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;Database=localhost:C:\mydatabase.gdb; Uid=myUsername;Pwd=myPassword;

Remote Computer

Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=myServerAddress;Database=ComputerName:C:\mydatabase.gdb; Uid=myUsername;Pwd=myPassword;

OLE DB, SIBPROvider

Standard

provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;Password=masterkey;

Version 2.x

Provider=SIBPROvider.2;Data Source=localhost:c:\databases\gdbs\mygdb.gdb;Persist Security Info=False;

Specifying character set

provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;Password=masterkey;character set=ISO8859_1;

Specifying role

provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;Password=masterkey;role=DIGITADORES;