Subject RE: [firebird-support] Connection String Question
Author Alan McDonald
> I was able to set up a DSN and get connected to a Firebird database and
> execute queries, however I wanted to change to a connection string. I
> am using . . .
>
> Driver=Firebird/InterBase(r) driver;Uid=SYSDBA;Pwd=masterkey;
> Dbname="\\dc1atl\GageInSite\gianyib.gdb";
>
> I've tried some variations (including using Database instead of Dbname
> and using servername), but I keep getting an "Unavailable Database"
> error. Googling it has not turned up anything that works. This is
> Firebird 1.5 and I'm using the 2.0 client. I'm running on XP and
> connecting to the FB database on a Win2003 server.
>
> Any help would be appreciated.
>
> Russell Campbell

I'd stick to TCP convention.
Always refer to
servername:drive:\path\to\filename.ext
not the netbeui notation.

but for the gemini driver I have always used
DRIVER={Gemini InterBase ODBC Driver
2.0};PROTOCOL=2;SERVER=servername/portnumber;DATABASE=drive:\path\to\databas
e.fdb;VERSION=6;DIALECT=3;OPTIONS=256;UID=fbcreator;PWD=metafbcr;

Alan