By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Query using ODBC quit working

P: 2
I have an ODBC to several tables in an Oracle 10g installation. I created an Access 2003 query using several of the tables from that ODBC. When I created it, it worked as expected and returned the necessary info. Due to another application that uses the Oracle TNS names entry that the ODBC was using, the Entry in TNS Names had to be editied. Now the original query will not run, the error is ODBC connect error. If I place an additional entry in TNS names that matches the original entry (when the query was created) then the query will work. I checked all the linked tables that use this ODBC and they all opened successfully (without the special entry) however the only way the Query will work is if I have the extra entry in TNS Names.

thanks in advance for any suggestions
Dec 30 '08 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
Did you try to reconnect the tables to a new ODBC definition ?

Nic;o)
Dec 30 '08 #2

P: 2
I thought about that and if that is the only solution I may have to do it that way. This particular query has a large number of joins and I was wanting to avoid re-creating them. What I did try to do is to view the query in SQL mode, then cut and paste that into a new query window in SQL mode. Unfortuneately that did not work.
Dec 30 '08 #3

nico5038
Expert 2.5K+
P: 3,072
You don't have to recreate the query, just relink the tables.
Open the "Tools/Database utilities/Linked table manager" and reconect to a working ODBC definition.

Nic;o)
Dec 31 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.