Subject RE: [firebird-support] Re: Firebird, Access and views, ODBC tracing
Author Alan McDonald
> Hi Alan,
> Thanks for going over my queries and table definitions.
> I'm guessing that the problem with Access inserts is due to SQL
> incompatibilities between Access' Jet SQL and Firebird's dialect 3, or
> an incompatibility/bug in the ODBC driver relating to inserting
> into views.
> Do you or anyone else know any good ways of tracing what SQL Access/ODBC
> actually passes to Firebird?
> Thanks,
> Eric

If you use a System DSN for the ODBC connection and not a DSN-less
connection, then the ODBC Manager provides for tracing of any/all drivers.