HOW TO run query using Oracle tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

TWIMC,

I have a query that I want to execute via code but the tables used are
linked Oracle tables, thus when the query is executed it asks for a user name
and password, so the question is how do I run the query via code with
supplying the user name and passowrd?

TIA
KM
 
Try and create a pass through query to execute the query.
The advantage is, that the operation will be executed on the server rather
then the station.
When you define in the query properties the ODBC connection, i will ask you
if you want to save the user and password, say yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Passthrough Query to Disable Triggers 4
Poor performance running queries with tables linked to Oracle Back 4
ODBC Pass-Through Queries 2
Insert Record into Oracle Table 1
Linked Oracle Tables - Query - SLOW!!! 2
Update Query with Oracle Table 4
Access pass-through query to Oracle 10g stored procedure - results 1
Weird characters in query results 1

Back
Top