ODBC connection to Oracle9i database

R

Robbie

Hi

I am hoping someone can help. We use a Oracle9i database at work but
also have a Access database linked to some of the Oracle tables. This
is used to perform extra reports and perform data analysis.

Currently we use Novell to connect to the network however we will soon
be moving to a new warehouse were they use Citrix. On the Novell
network each PC is configured to access the Oracle database, Ie
TNSNAMES files etc. But when using Citrix everything is running off of
the server, so it needs to be configured so each PC can connect to the
database. In July this was set up and was working fine, the Access
Database also connected via its ODBC link.

Last week the Citrix server went wrong and everything onit had to be
installed. We have the connection to the Oracle 9i database but the
Access connection does not work. In Access we are getting ODBC
Connection to (database name) failed, error messages. We have tried
installing Microsoft data access packs on the server but it still does
not work. Is there anything else we can do?
 

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
Can't send emails on new PC 1
ODBC Connection with Windows 7 2
Access2010 redistribuible + runtime e ODBC issue 2
MS Oracle ODBC failure in Access 07 3
Dumb question alert! What program to use? 0
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
ODBC Connection through Access VBA using Windows 7 1

Top