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,