connection to an oracle database

dina78
dina78 used Ask the Experts™
on
I am trying to establish a connection to our oracle Database through ODBC and i am getting the following error
Error: SQL##f - SqlState: IM003, ErrorCode: 160, ErrorMsg: Specified driver could not be loaded due to system error  126

i have test my ODBC connection under control panel- Admin tools- ODBC connection and the connection was established.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
i have windows 7 with 64 bits.  the IT guys think that this is my problem and that i should reformat and use XP 32 bits,, does this make any sense?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Are you running 32 bit Office or 64 bit office?  The Oracle drivers need to match the bit version of the software using it.

There is also a 32bit ODBC administrator.  It is in a different folder:
http://support.microsoft.com/kb/942976

Author

Commented:
How can i find out?
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
The bit version of office?
http://www.howtogeek.com/howto/24259/beginner-discover-if-youre-running-the-32-or-64-bit-version-of-office-2010/

For the Oracle version, ask the person that installed them?

Author

Commented:
ops sorry yes i meant the office..
help about should give you the version  look for 32 bit or 64 bit.

We have the same problem, and 64 bit office doesn't play well with some of our software that was build on 32 bit.

file tab, select help

look in right column for something that says 64 or 32 bit about half way up.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>help about should give you the version  look for 32 bit or 64 bit.

All explained with pictures in the link I posted...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial