Subject Re: [ib-support] ODBC-problem
Author Paul Reeves
Patrick Beyltjens wrote:


> I tried to connect to firebird with the ODBC
> The following connect-string makes an error.
>
> "DRIVER={XTG systems Interbase6 ODBC driver};DB=BK:C:\firebird-database\bk.gdb;UID=myname;PWD=secret;"
>
> where myname = my userid and secret = my password
>
> The error is something like this : No connection could be established with these parameters.
>
> Can someone help me ?
>

This looks like a file dns. Can you connect with a system or user dns? I
know the IBPhoenix driver cannot connect with a file dns, so may the XTG
driver has the same problem.

You might also want to look at the source for the driver. It may be
looking for different keywords instead of the DB, UID and PWD that you
have supplied. Again, I know that when I last looked at a similar part
of the code for the IBP driver that there seemed to be a mismatch in
that area.


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase