Driver's SQLAllocHandle on SQL_HANDLE_ENV Failed

I have an error: "Driver's SQLAllocHandle on SQL_HANDLE_ENV Failed" that appears when I try to connect to Oracle Database using MS Excel. Odbc connection works and can connect. I have read up on FAQ on Oracle and have tried the following suggestions:
1. Re-Installed Oracle Client, not working
2. Checked PATH env variable, it is correct
3. Checked and changed permissions, not working

When I use the test on my ODBCAD32.exe, it works and can connect. Even PL/SQL Developer client can connect to Oracle. It is just MS Office and Qlikview that does not want to connect. Qlikview gives me the following error:

"SQL##f - SqlState:IM014,ErrorCode:0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"
Raymond De KockManaging DirectorAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Raymond De KockConnect With a Mentor Managing DirectorAuthor Commented:
I have reloaded all my Oracle Clients several times and eventually it started to work. This can be closed.
0
 
NorieVBA ExpertCommented:
Have you checked the driver?

It might be the correct one but the wrong version?

Also, where exactly and how are you doing this?

Manually or in code?
0
 
Raymond De KockManaging DirectorAuthor Commented:
Hi Imnorie,

I have checked the driver and have installed several versions, i.e. Oracle 9.2, Oracle 10.2.0.4, Oracle 10.2.0.3 and the same is experienced.

My Operating system is Windows 7 64bit. The Oracle driver is a 32 bit driver, the 64 bit driver does not install as it sees my version as too new for its liking.

This is manual, not in code.

ODBC Test works. PL/SQL connection works. It is just MS Excel and Qlikview that does not like it.

My System variable for PATH is set to the following:
C:\oracle\product\10.2.0\client_1\bin;C:\oracle\product\10.2.0\client_1;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\NetSarang;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Windows Live\Shared

This looks correct as far as the suggestions on the internet advises.

I am doing it from MS Excel 2007 -> Data -> Get External Data -> From Other Sources -> From Microsoft Query -> Select ODBC setup for Oracle and then it gives me the error.
0
 
animessengerCommented:
Try installing Qlikview x64 (64-bit version) and that should hopefully take take of the issue.
0
 
Raymond De KockManaging DirectorAuthor Commented:
No solution was provided  by the experts
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.