[数据库连接字符串] Interbase 连接字符串

来源：互联网发布：青年网络公开课哪里看编辑：程序博客网时间：2024/05/17 22:25

*{font-family:Tahoma;font-size:9pt;}.csProviderHeader{font-size:12pt;font-weight:bold;color:#333333;padding-top:40px;border-bottom: none;}.csProviderHeaderLine{background-image: url('http://www.connstr.cn/images/greylinegradientwider.gif');background-repeat:no-repeat;}.csConnectionStringHeader{font-size:10pt;font-weight:bold;color:#333333;padding-top:10px;padding-bottom:5px;padding-left: 12px;}.csConnectionStringSummary{padding-bottom:13px;padding-left:100px;width: 600px;}.csConnectionStringRow{padding-left: 10px;}.csConnectionStringTable{width:100%;}table{border: none;}.csConnectionString{padding: 3px 6px 3px 6px;border:solid 1px #999999;font-family: Courier New;font-size: 8pt;background-color: #eeeeee;}.csKeyword{color:blue;}.csValue{color:Navy;}.CopyToClipboard{font-size:8.25pt;vertical-align: top;text-align: right;padding-top:10px;width:50px;display:block;}a {color:Black;text-decoration:none;}img{border:0px;}.style1 {font-size: 12pt;font-weight: bold;color: #008000;padding-top: 40px;border-bottom: none;} ODBC, Easysoft 本地计算机

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

远程计算机

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

ODBC, Intersolv 本地计算机

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

远程计算机

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

OLE DB, SIBPROvider 标准

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

版本 2.x

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

指定字符集

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

指定角色

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