Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Other Database Engines _ Odbc To Oracle

Posted by: lex Apr 9 2017, 01:34 PM

I have an ODBC DSN setup and can link tables and run queries, but they are slow. I therefore want to use a Pass-Thru.

When I setup the query using the linked-table the query runs. Then I change it to pass thru and it runs. if I save, then try to open, I get

If I click the 3 dots in Property Sheet > ODBC Connect Str and create the connection string, I get the same thing.

Why? I obviously have permissions if I can get data before saving?