X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Odbc To Oracle    
post Apr 9 2017, 01:34 PM

Posts: 702
Joined: 20-October 05

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

Attached File  2017_04_09_14_27_38.jpg ( 25.24K )Number of downloads: 1

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?

Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    17th March 2018 - 11:14 PM