Forum Stats

  • 3,816,099 Users
  • 2,259,141 Discussions
  • 7,893,390 Comments

Discussions

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

2673423
2673423 Member Posts: 4
edited May 15, 2014 12:28AM in ODBC

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,

This discussion has been closed.