You can try

Provider=SIBPROvider.2;Password=masterkey;Data
Source=localhost:d:\data\fbdata\myfbdata.fdb;Persist Security Info=True

Or

Provider=SIBPROvider.2;Password=masterkey;User ID=SYSDBA;Data
Source=localhost:d:\data\fbdata\myfbdata.fdb;Mode=Share Deny None;Extended
Properties="";Persist Security
Info=True;SIB:Dialect=3;SIB:IBErrorMessages=15;SIB:Auto Recognize
Parameters=True;SIB:AllowNamedParameters=True;SIB:Case
Sensitive=False;SIB:Cache Schemas=0;SIB:Lock Resolution=9;SIB:Default
Isolation Level=4096;SIB:Bracket Symbols="""""";SIB:Default Cursor
Type=0;SIB:Compatibility Mode=0;SIB:Map Numeric Type To=131;SIB:Column Probe
Generator=True;SIB:Column Ask Server For Default=True;SIB:Always Trim
Char=True

Peter Gore

-----Original Message-----
From: constantijnw [mailto:cw.s@...]
Sent: 14 July 2004 17:15
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Can't connect with SIBProvider dirver

Hi,


I want to connect to Fb 1.5 via OLE DB with the SIBProvider 2.2.2
driver.
Other drivers work fine but this one gives me a headache.

Can anyone tell how the connectionstring looks like?


TIA

Constantijn





Yahoo! Groups Links