Raymond De Kock
asked on
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"
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
ASKER
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\c lient_1\bi n;C:\oracl e\product\ 10.2.0\cli ent_1;C:\P rogram Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\NetSarang;%SystemRoo t%\system3 2;%SystemR oot%;%Syst emRoot%\Sy stem32\Wbe m;%SYSTEMR OOT%\Syste m32\Window sPowerShel l\v1.0\;C: \Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\P rogram Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\P rogram Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Pro gram Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShe ll\Common7 \IDE\;C:\P rogram Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssem blies\;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.
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\c
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.
Try installing Qlikview x64 (64-bit version) and that should hopefully take take of the issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No solution was provided by the experts
It might be the correct one but the wrong version?
Also, where exactly and how are you doing this?
Manually or in code?