At 05:51 PM 06-09-01 +0200, you wrote:

><snip>
>
> > Are you trying to use BDE 5.1 and the IB 5.x ODBC driver with a
> > Dialect 3 database?
> >
> > H.
>
>Hello again,
>
>In fact I use this odbc driver: OdbcJdbc-20010711.zip
>downloaded from
>http://www.ibphoenix.com/ibp_60_odbc.html
>
>Dialect is 3 on and Interbase6 db (ODS=10)
>BDE is the version from Delphi 5 (could be 5.1, not sure) I cannot
>verify for the moment since I'm on linux now, do you want me to check
>it?

No, it's sufficient to know that you are using that old version of the BDE - which might be a source of your problem, since IB 6 didn't exist at the time it was produced.

>More Info?

Yes - it's a Delphi question rather than a driver one...it occurred to me because you mentioned you were using the same client program to connect to either Paradox or IB 6. How do you make the connectivity for the Paradox data access objects? From the info you provided earlier, I wonder if you created a separate ODBC datasource for each table connection...

In Interbase, you need to create one single ODBC datasource for the entire database. IB tables don't map to physical files as Paradox tables, Excel spreadsheets, etc. do.

Just a thought.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________