Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft ODBC for Oracle
setting up a new Windows PC. have already installed the Oracle client and the application that uses that seems to work fine. however, we need ODBC access to the Oracle data as well and on an older PC i'm able to Add New Data Source and see "Microsoft ODBC for Oracle" in the list of drivers. on this new PC, i just don't see it.
is there something from Microsoft i need to acquire? or because i installed the Oracle client, are the drivers on my system, but Windows just can't see them? the ODBC driver file is MSORCL32.DLL and is located in c:\windows\system32 and on the new system, i see the file located in c:\windows\syswow64 folder.
i've tried doing a SET PATH=%PATH%;c:\windows\sys
can anyone point me in the right direction?
odbc_oracle1.png
odbc_oracle2.png
is there something from Microsoft i need to acquire? or because i installed the Oracle client, are the drivers on my system, but Windows just can't see them? the ODBC driver file is MSORCL32.DLL and is located in c:\windows\system32 and on the new system, i see the file located in c:\windows\syswow64 folder.
i've tried doing a SET PATH=%PATH%;c:\windows\sys
can anyone point me in the right direction?
odbc_oracle1.png
odbc_oracle2.png
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
THANK YOU! that worked perfectly. all of our previous machines have been 32-bit, so the fact it was 64-bit thru me for a loop. thanks.
Your Welcome... This has bitten me on too many occasions.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.