Pass through query to Oracle database

K

Kirk P.

Trying to set up the ODBC connection to retrieve data into Access via a pass
through query to Oracle. I'm using the Microsoft ODBC for Oracle driver, and
I need to provide the SERVER in the connection string.

I thought the Oracle TNS file provided all the connection info
penprd01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = dc1db08.dc1.digitalriver.com)
(PORT = 1556)
)
)
(CONNECT_DATA =
(SID = penprd01)
(SERVER = DEDICATED)
)
)

But no matter what I've tried in the SERVER field, I can't get it to
connect. I do have access to the database...

Help?
 

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

Pass-Through Query Error 1
Pass through query to oracle db 2
ODBC Pass-Through Queries 2
Access pass-through query to Oracle 10g stored procedure - results 1
pass-through query to Oracle 0
DSN-Less connections with MS Oracle Driver 4
Append Records to ORACLE via ODBC 0
SQL Pass-Through Query to Oracle fails 1

Top