Windows Oracle Data Access Components (MOSC)

MOSC Banner

oracle 11g ODBC Driver

edited Nov 24, 2011 7:56PM in Windows Oracle Data Access Components (MOSC) 11 commentsAnswered
   Hi,

Our company has Oracle 10g on the server.   Recently, I installed the oracle client 11g (11. 2.0.1.0) on my new window 7 computer.   I realize there are some problems with the client 11g.

I use ODBC DSN (oracle 11g driver) to connect data from Oracle to Access 2003, after I switch to 11g client.  My DSN connection is much slower.  Also, when I did an update with join query in Access, it took almost 15 minutes to update 3000 records, and when it done, it set all 3000 records to null.   Here is my query in Access:

UPDATE Oracle_Target_Table INNER JOIN Access_Source_Table ON Oracle_Target_Table.ID = Access_Source_Table.ID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center