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!

Ms access 2007(32 bit) does not show oracle 64 bit driver in system data sources when trying to crea

KrithiJul 3 2013 — edited Jul 3 2013

My system is having Oracle database 11gR2 installed (its a windows 2008 -64 bit server).

Oracle 64 bit drivers got installed during installation.This is verified by doing "create data source(ODBC)- system DSN- then in the drivers list Oracle in OraDB11g_home appears and I am able to create a "System DSN" there successfully.

Connectivity is successful here.

Now I want MS access 2007 to connect and get to this ODBC source (the database resides on a 64 bit server) but its not showing up.

I searched and realised that since ms access 2007 is a 32 bit application, it cannot see the oracle 64 bit driver.

So what are the possible solution to make this scenario work now?(other than installing ms access 2010 64 bit, which might work i suppose).

1)Do I have to install oracle 32 bit driver?is that the only option?if so, Please give me the right download link with instructions?

2)Any other way without installing the 32 bit driver, but doing any changes in some settings?

Thanks&regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2013

Added on Jul 3 2013

#odbc, #windows-and-net

2 comments

4,513 views