Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

2673423May 14 2014

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,

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 11 2014
Added on May 14 2014
0 comments
81 views