3 Replies Latest reply: May 16, 2014 3:06 AM by sdhamoth RSS

    oracle client 12 slow on window 7 32 bit????

    1d37362b-6db3-4baa-8576-10a90281de99

      Hi,

       

      we have recently update oracle database to 12c enterprise 64 bit from 11g. As client we use window 7 32 bit and MS access office 2013.

       

      Found couple of issue.

      1. slowness on some query.

      2. could not able use Microsoft ODBC driver for oracle on MS Access 2013(VBA).

          received following error.

                ODBC -- connection to '{Microsoft ODBC for Oracle}databaseName' failed. Only way found was the re-link table on access.

       

      Are there any drawbacks of connecting to 12c enterprise 64 bit version through  oracle client 12.1.0 on windows 7 32 bit/MS access 2013

       

       

      failed use ODBC;DRIVER={Microsoft ODBC for Oracle};UID="user";PWD="password";SERVER="server"; (Please guide).

      can only use DSN used connection.

          ODBC;DSN={dsnanme};UID="user";PWD="password";SERVER="server";

       

       

      Where could I wrong??? thanks,