Access linked ODBC tables, connection failed error msg

B

BARBARA FLOYD

Hi,

Im an ODBC novice and am having a problem that an old hand
would probably know about!

I have an Access database which has some linked ODBC
tables to an Oracle database.
I get an error "ODBC - connection to 'oracleDBname'
failed".

I have tried going into "Data Sources ODBC" in Control
panel and creating a System DSN, with Driver Microsoft
ODBC for Oracle.
The DataSource Name parameter matches the DNS name for the
Linked tables in Access, and the UserName parameter is the
username I can successfully connect to the oracle DB with -
though there is no space to enter the password.

Am I doing somehting wrong or is there anything else I
should be doing to get this to work?

thanks very much for any help!

Barbara
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Table Security in Access 2013 1
Access 2003 not linked to Oracle 11g 3
ODBC Connection 0
ODBC - Connecting MS Access to Oracle 10g 0
Manage ODBC 2
Problem connecting Access to Oracle 0
How to login "Oracle ODBC Driver Connect" in the programmatically 2

Top