UtterAccess.com
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    
 
   
lex
post Apr 9 2017, 01:34 PM
Post#1



Posts: 637
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?

Thanks
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th August 2017 - 07:30 PM