Subject Re: [firebird-support] IBPhoenix ODBC drivers not working with iOBDC under Linux
Author Helen Borrie
At 04:10 PM 16/12/2003 +0000, you wrote:
>Has anyone ever made it to get the IBPhoenix ODBC drivers to work with
>iOBDC under Linux???
>
>It seems to me they are not compatible.

The best place to inquire about that would be on the firebird-odbc-devel
list. Subscription links are on the Firebird and IBPhoenix sites. iODBC
is pretty old, whereas the IBP driver is relatively recent...


>I get the following two error messages at the same time:
>
>"Invalid Connection String attribute"

This is a driver message

>and then
>"File is not a valid database"

This is a server message


>Any help would be greatly appreciated.

Both messages suggest either a bad connection string or that you are trying
to access a database that is not located on a physical drive of the host's
own filesystem. You can't connect to databases on network drives. Did you
know that you can't make a table an ODBC datasource as you can with some
desktop dbms?

Use a monitor tool to check the connection string. The connection string
must resolve to

hostname:/path/to/database (if the host & database are on POSIX)

or

hostname:drivename:\path\to\database (if the host & database are on Win32)

/heLen