Forum Stats

  • 3,827,685 Users
  • 2,260,804 Discussions
  • 7,897,340 Comments

Discussions

Problem after 10g to 11g conversion with ACCESS app ODBC connection.

Shellie Bricker
Shellie Bricker Member Posts: 12
edited Mar 20, 2014 5:01PM in ODBC

We have recently upgraded one of our Oracle Databases from 10.2.0.4 to 11.2.0.4.0.  We used Data Pump export from 10g database and Data Pump import to the new 11g database.  Everything went fine.  We have several users who use an Access database with an ODBC connection to our Oracle database.  We have installed the 11g client on their pcs and setup the tnsnames file to point to the new 11g database.  We have a read-only account setup that everyone uses to logon to the Oracle11g database thru the Access application.  We have one user that is getting an error, even though that machine was setup just like everyone elses.  She is getting a odbc error, that the account is locked.  I had the read-only account on our 10g database locked, so everyone would be forced to use the 11g database, because we couldn't totally shutdown the 10g database.  We have searched her c:\ drive and can only find 1 tnsnames file and it is pointed to the new 11g database.  However when we unlock the read-only account on 10g database, her Access application works just fine.  It is like she is still pointed to the 10g database, but we can't find any link to it.  This user also can logon to a different pc that the ODBC connection to 11g server is working with the Access app and it doesn't work with them logged on.  Any help would be appreciated!! 

Best Answer

  • Shellie Bricker
    Shellie Bricker Member Posts: 12
    Answer ✓

    Our resolution was a slight reordering to Oracle items in the Path Environment Variable in Desktop/Properties/Advanced System Settings to make sure the proper path containing the accurate tnsnames.ora file was represented was all that was needed.

Answers

This discussion has been closed.