Developers community number 1 connection string reference

Connection strings for Interbase

Providers to use when connecting to Interbase

» SIBPROvider Interbase OLE DB Provider
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» Easysoft ODBC
» Intersolv InterBase ODBC Driver
» .NET Framework Data Provider for ODBC (OdbcConnection)

Finding this site useful?

-Say "Thanks" to Cetin Basoz and the other contributing developers!

-Thank you! »

SIBPROvider Interbase OLE DB Provider

Type: ODBC Driver
Usage: provider=sibprovider

Manufacturer: SIBPROvider

Customize string
example values »

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;

.NET Framework Data Provider for OLE DB

Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection

Manufacturer: Microsoft
More info about this wrapper class library »

Customize string
example values »

Bridging to SIBPROvider Interbase OLE DB Provider

This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.

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

Easysoft ODBC

Type: ODBC Driver
Usage: Driver={Easysoft IB6 ODBC}

Manufacturer: Easysoft

Customize string
example values »

Local computer

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

Loading ad...

Remote Computer

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

Intersolv InterBase ODBC Driver

Type: ODBC Driver
Usage: Driver={INTERSOLV InterBase ODBC Driver (*.gdb)}

Manufacturer: DataDirect Technologies
More info about this driver »

Customize string
example values »

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;

This driver are provided by DataDirect Technologies (formerly Intersolv)

.NET Framework Data Provider for ODBC

Type: .NET Framework Wrapper Class Library
Usage: System.Data.Odbc.OdbcConnection

Manufacturer: Microsoft
More info about this wrapper class library »

Customize string
example values »

Bridging to Easysoft ODBC

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

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