Subject Re: [ib-support] ODBC connection string error
Author Martijn Tonies
Hi,


> I am tyring to connect to a FB database using XTG Systems InterBase6
> ODBC driver. They claim that it supports the following conection
> string:
>
> "DRIVER={XTG Systems InterBase6 ODBC
> driver};DB=myserver/:c:\mypath\mydb.gdb;UID=myname;PWD=secret;CHARSET=
> WIN1250;ROLE=myrole;"
>
> I modified this to fit my test program which is tyring to access the
> employee.gdb database that is shipped with FB.
> My connection string is the following:
>
> "DRIVER={XTG Systems InterBase6 ODBC
> driver};DB=localhost/:c:\employee.gdb;UID=SYSDBA;PWD=masterkey;"

I think that in order to connection with TCP/IP you should use:

localhost:c:\employee.gdb

> When i try to test this connection using a Data Link file, I get the
> following error: "Test connection failed ... Invalid Conection
> String attribute"


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."