Failed Access ODBC connection to Oracle 10.1

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

Hi all,

I have an Access application with linked tables that are on an Oracle
10.1 back-end. When I create a query in the QBE and select pass-through
query it works just fine. BUT, when I save the query, or include the
connection string in the query properties (without saving), and run it
again it errors out ~ "table or view does not exist". I've don two
things to get the correct connection string 1)I've copied the
connection string from the MSysObjects table, and 2) let query
properties fill the connection string when I select the DSN. I get the
same results in both cases.

So the query works the first time but not if I save it or add a
connection string.

Any suggestions?

Brett
 
Uzytkownik "Brett said:
Hi all,

I have an Access application with linked tables that are on an Oracle
10.1 back-end. When I create a query in the QBE and select pass-through
query it works just fine. BUT, when I save the query, or include the
connection string in the query properties (without saving), and run it
again it errors out ~ "table or view does not exist". I've don two
things to get the correct connection string 1)I've copied the
connection string from the MSysObjects table, and 2) let query
properties fill the connection string when I select the DSN. I get the
same results in both cases.

So the query works the first time but not if I save it or add a
connection string.

Any suggestions?

Brett
Click to expand...
===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================
 
Back
Top