SIBPROvider Interbase OLE DB Provider connection strings

Interbase

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;