Splunk ODBC 32-bit on Windows 7 64-bit

[asohahn_splunk]

I have installed Splunk ODBC 32-bit on Windows 7 64-bit.
Installation was fine but when I try to configure DSN, an error was occured.

Saying...

The setup routines for the Splunk ODBC
Driver ODBC driver could not be loaded
due to system error code 126: The
specified module could not be found.
(C:\Program Files (x86)\Splunk ODBC
Driver\lib\SplunkDSII.dll).

But that file exists at that exact location.
Since my Office is 32-bit, is there any workarounds to use Splunk ODBC 32-bit on 64-bit OS?

[skylasam_splunk]

Please capture traces and email them to devinfo@splunk.com so that we can investigate further.

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Splunk ODBC Driver\Driver
set LogLevel to 5 and LogPath to a valid directory such as "c:" (without quotes) and then run the repro.

[kbluech]

It's not made any log. But, I am trace the LOG with ODBC driver Trace log. I will email. Thank you.

[kbluech]

Yes, but it's not make any log files when excute ODBC(Excel Microsoft Query and Tableau 32bit)in the LogPath DIR.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Splunk ODBC Driver\Driver]
"ErrorMessagesPath"="C:\Program Files (x86)\Splunk ODBC Driver\ErrorMessages"
"LogLevel"="5"
"LogPath"="C:\Temp"

[kbluech]

I Have same Issue that Tableau(32bit) and Excel(32bit) has ERROR "SQL_HANDLE_ENV with SQLAllocHandle"

On my Windows 7 64bit, C++ x86,Splunk ODBC Driver(32bit)

[ywu_splunk]

It seems that you are using a VM, so this might be a permission issue involving remote desktop. Please refer to the follow page for a solution. Let us know if that solves the problem or not.

http://dbcrusade.blogspot.com/2007/10/oracle-odbc-drivers-sqlallochandle-on.html

[ywu_splunk]

To track this down, could you please capture traces? To get it, set LogLevel to 5 and LogPath to a valid directory such as "c:\" (without quotes).

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Splunk ODBC Driver\Driver

[asohahn_splunk]

I'm not using remote desktop. I'm accessing my Windows 7 VM directly from VirtualBox console. Tried to follow the steps described on the link but didn't work due to different OS. Thanks anyway.

[skylasam_splunk]

Hi Asohahn,
When do you get this error - "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed."? Please provide the steps that you're doing in Excel.

[asohahn_splunk]

Open Excel > Data > From Other Sources > From Microsoft Query > Splunk ODBC > OK

I get the message right after clicking OK.

[abrown_splunk]

Hey Asohahn,
I believe that if you're using a 32-bit application, you need to install the 32 bit C++ redistributable. Take a look at this and let me know if it helps:

http://docs.splunk.com/Documentation/ODBC/latest/UseODBC/Prerequisites

[asohahn_splunk]

Thanks for your answer.
The error message has gone after re-installing 32bit C++ redistributable.

But another problem has occurred. Saying...

"Driver's SQLAllocHandle on SQL_HANDLE_ENV failed."

I've created a fresh new Windows 7 64-bit machine on my VirtualBox followed by installing 32bit MS Office 2010, 32bit C++ redistributable, Splunk ODBC 32-bit and tested again but had no luck.

Both tested on remote machine (another VM with Splunk 6 installed under same subnet) and localhost.

Tested turning off splunkd SSL in order to access through http instead of https.

[richgalloway]

This fixed the problem for me.

[richgalloway]

I get the same error message on Windows Server 2008 R2.