oracle 11g ODBC Driver
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