topic Splunk ODBC 32-bit on Windows 7 64-bit in All Apps and Add-ons

Splunk ODBC 32-bit on Windows 7 64-bit

asohahn_splunk — Wed, 22 Jan 2014 02:33:28 GMT

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?

Re: Splunk ODBC 32-bit on Windows 7 64-bit

richgalloway — Wed, 29 Jan 2014 16:33:20 GMT

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

Re: Splunk ODBC 32-bit on Windows 7 64-bit

abrown_splunk — Wed, 29 Jan 2014 17:47:03 GMT

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

Re: Splunk ODBC 32-bit on Windows 7 64-bit

richgalloway — Wed, 29 Jan 2014 18:20:01 GMT

This fixed the problem for me.

Re: Splunk ODBC 32-bit on Windows 7 64-bit

asohahn_splunk — Mon, 28 Sep 2020 15:47:31 GMT

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.

Re: Splunk ODBC 32-bit on Windows 7 64-bit

skylasam_splunk — Mon, 28 Sep 2020 15:47:42 GMT

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.

Re: Splunk ODBC 32-bit on Windows 7 64-bit

asohahn_splunk — Mon, 03 Feb 2014 23:07:02 GMT

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

I get the message right after clicking OK.

Re: Splunk ODBC 32-bit on Windows 7 64-bit

ywu_splunk — Mon, 03 Feb 2014 23:57:13 GMT

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

Re: Splunk ODBC 32-bit on Windows 7 64-bit

asohahn_splunk — Tue, 04 Feb 2014 01:40:56 GMT

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.

Re: Splunk ODBC 32-bit on Windows 7 64-bit

ywu_splunk — Mon, 28 Sep 2020 15:48:22 GMT

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

Re: Splunk ODBC 32-bit on Windows 7 64-bit

kbluech — Mon, 28 Sep 2020 16:22:45 GMT

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)

Re: Splunk ODBC 32-bit on Windows 7 64-bit

skylasam_splunk — Mon, 28 Sep 2020 16:23:01 GMT

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.

Re: Splunk ODBC 32-bit on Windows 7 64-bit

kbluech — Mon, 28 Sep 2020 16:23:18 GMT

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"

Re: Splunk ODBC 32-bit on Windows 7 64-bit

kbluech — Tue, 15 Apr 2014 04:15:31 GMT

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