Error when connecting to oracle 11g via access 2013

Hi All,
I am trying to connect to an oracle database using access 2013
The  ODBC Data driver can connect successfully to the data source see below.
dsn
But when I try to use this data source within Access 2013 I get an error message. See below
call fail
it  is 32 bit access running on 64 bit windows 7
Any guidance appreciated. Thanks
blossomparkAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
create a connection in odbc 32bit

you created a connection in the 64 odbc

from start, type odbc, you should 32bit and 64bit versions
blossomparkAuthor Commented:
Hi Geert,
thanks for your response.
when I type odbc, i get two options
Microsoft ODBC administrator
Set up data source ODBC.
no 32 64 bit options
Geert GOracle dbaCommented:
use explorer to look in  C:\Windows\SysWOW64

odbcad32.exe

windows 10 displays both.
I guess you still use windows 7
SolarWinds® IP Control Bundle (IPCB)

Combines SolarWinds IP Address Manager and User Device Tracker to help detect IP conflicts, quickly identify affected systems, and help your team take near instantaneous action. Help improve visibility and enhance reliability with SolarWinds IP Control Bundle.

Alex [***Alex140181***]Software DeveloperCommented:
Yes, Geert is correct. Use the corresponding version of ODBC:

32 bit: C:\Windows\SysWOW64\odbcad32.exe
64 bit: C:\Windows\System32\odbcad32.exe
blossomparkAuthor Commented:
looking at the existing installed drivers they seem to be 32 bit?
32
Alex [***Alex140181***]Software DeveloperCommented:
Why that?! Because of the "32" within the filename?! I'd give a damn about that ;-)
odbcad32.exe exists as 32 as well as 64 bit version with the SAME name...

Are you using 64 bit Access?!
blossomparkAuthor Commented:
no 32 bit access
blossomparkAuthor Commented:
i am using 32 bit access
Alex [***Alex140181***]Software DeveloperCommented:
Oracle Client is 32 or 64 bit?!
Geert GOracle dbaCommented:
to check for the oracle client version

check what oracle paths you have
dos:
set path
> this will display all the paths to the oracle software installed ... and other software

run sqlplus
> it should state what version it started 64-bit or not

if you have multiple clients, move the 32bit path before the 64bit path in the path environment variable
blossomparkAuthor Commented:
the only client i can see in environment variables is
C:\downloaded applications\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1
This is the one I installed ...
I will remove this and install the 32 bit version?
Geert GOracle dbaCommented:
not sure if the instant client is enough
you could try
and if that doesn't work, install the runtime version of oracle client
Alex [***Alex140181***]Software DeveloperCommented:
x64 indicates 64 bit architecture. This client won't work with 32 bit ODBC (and thus not with Access)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Alex [***Alex140181***]Software DeveloperCommented:
not sure if the instant client is enough
No, you have to get the ODBC "AddOn" from Oracle ;-) should be right below the Download list on that page
blossomparkAuthor Commented:
sorry...there is a previous entry in the PATh
C:\app\product\11.2.0\dbhome_2\bin; not sure if this 32 or 64
Alex [***Alex140181***]Software DeveloperCommented:
Looks like the DB installation.
Try this from command line and check 32 or 64 bit:

SET ORACLE_HOME=C:\app\product\11.2.0\dbhome_2
SQLPLUS / AS SYSDBA (or whatever login)

look for 64 bit on "welcome screen"...
blossomparkAuthor Commented:
Hi Alexander,
not  able to get the expected results  with the commands above,
i will install the 32 bit client and set this as first in the PATH
blossomparkAuthor Commented:
Hi Alexander and Geert,
thanks for your assistance,
i installed the 32 bit oracle client and now working ok...
Thank you!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.