Kiwi Syslog, Log to Oracle error
I'm running latest Kiwi Syslog version on Windows 2008 R2. I want Kiwi Syslog to Log to Oracle 12c which is running on the same server. The DSN is set and works. When I try to set Kiwi Syslog to Log to Oracle I select the DSN, type the user and password and get an unspecified error.
ASKER
Oracle Net Manager is version 12.1.0.0.2.
Oracle ODBC Driver is version 12.01.00.01.
Both became available as part of the 12c setup.
The Oracle ODBC Driver is available ONLY on the x64 ODBC Admin. The x86 ODBC Admin doesn't list the Oracle ODBC Driver. I've created a User DSN and it works (the connection test returns OK). When I set Kiwi Syslog to use this DSN I get the error.
Oracle ODBC Driver is version 12.01.00.01.
Both became available as part of the 12c setup.
The Oracle ODBC Driver is available ONLY on the x64 ODBC Admin. The x86 ODBC Admin doesn't list the Oracle ODBC Driver. I've created a User DSN and it works (the connection test returns OK). When I set Kiwi Syslog to use this DSN I get the error.
Is Kiwi Syslog 32Bit or 64Bit software?
ASKER
Both Service and Manager are 32bit.
I know what you are going to tell me, but, where do I get Oracle 12c x86 (32bit) ODBC Drivers? Perhaps you know Oracle's site better than me.
Thank you for taking the time. Let me know.
I know what you are going to tell me, but, where do I get Oracle 12c x86 (32bit) ODBC Drivers? Perhaps you know Oracle's site better than me.
Thank you for taking the time. Let me know.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I couldn't set successfully the Instant Client (32 bit) on the same server hosting Oracle 64 bit. There must be some kind of coexistence issue when both Oracle components (32 and 64 bit) are on the same box... but that is another issue I must investigate upon.
In order to make sure Kiwi is able to Log to Oracle 12c and close this question, I installed the Oracle 32 bit client on a fresh box (a 7 x64 with no Oracle installed). I set the connection using Oracle's Net Manager (test OK), set the ODBC using the TSN created (test OK), set Kiwi to Log to Oracle (test OK!).
The result is: Kiwi can Log to Oracle as long as you have a working 32 bit ODBC driver.
Thank you for your help.
In order to make sure Kiwi is able to Log to Oracle 12c and close this question, I installed the Oracle 32 bit client on a fresh box (a 7 x64 with no Oracle installed). I set the connection using Oracle's Net Manager (test OK), set the ODBC using the TSN created (test OK), set Kiwi to Log to Oracle (test OK!).
The result is: Kiwi can Log to Oracle as long as you have a working 32 bit ODBC driver.
Thank you for your help.
ASKER
My last post explains in detail.
There are two ODBC admin programs on a 64Bit system:
http://support.microsoft.com/kb/942976
you also need the correct Bit version of the Oracle ODBC driver.