0 Replies Latest reply: Apr 25, 2013 8:22 AM by user8684352 RSS

    MSACCESS ODBC ORACLE11

    user8684352
      Hi all,

      we run a 11203 ee-db on solaris 10. Clients are windows based (XP). Problem is:
      Connection to Oracle-db via MSAccess with "import table". Import of data is very slow (280000 rows in about 14 minutes). ODBC-driver used is 11g.
      When using MSQuery with the same ODBC, DSN, database, user, table I see data within a second (when using it with EXCEL it is as slow as with msaccess).
      The table is just a plain table mostly varchar and some dates. Date conversion might cause some problem.

      I have no idea about access (just using the functionality as this is supposed to become a production db and I am the dba).
      The DNS used is a file-dns. Is there a difference in use between file and system dns?

      Any idea where to look and find the culprit? What can I find out from ODBC-logging file?

      Any help appreciated.

      FJH