SQL Pass-Through Query to Oracle fails

I

IT Pro Dave

Hi,
I am having a problem with a SQL Pass-Through Query. The SQL is SELECT
TABS.* FROM TABS; The error is ODBC--call failed. [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00911; invalid character (#911). Access 2003, Microsoft
ODBC for Oracle 2.575.1117.00. I hope there is just a setting I am missing as
the Oracle driver works for the Pass-Through Query but is so slow when
working with tables I would prefer using the Microsoft driver.

Thank you,
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass-Through Query Error 1
Pass through query to Oracle database 0
Pass through query to oracle db 2
SQL Help Please 1
Access pass-through query to Oracle 10g stored procedure - results 1
ODBC Pass-Through Queries 2
Insert Record into Oracle Table 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0

Top