oracle ODBC test return ORA-12154:TNS:Could not resolve serv

seteor · Post by **seteor** » Wed May 04, 2011 1:49 am

We are using Hostmonitor version 8.6 running on Windows Server 2003 Enterprise X64 Edition SP2. At the moment we are using ODBC Query，it returns ORA-12154:TNS:Could not resolve service name.

Oracle client is 10.2.0.1 win32

I use sqlplus test is fine.
Test in odbcad32.exe is fine too.
Test in hostmonitor is not fine.

Then I test ODBC Query with win7-32+oracle client 10.2 win32 in hostmonitor 8.6 is fine.

KS-Soft Europe · Post by **KS-Soft Europe** » Wed May 04, 2011 7:39 am

Looks like problem is related to different ODBC settings for x64 and x86 applications.
I assume, you are using x64 ODBC datasource C:\WINDOWS\SYSTEM32\odbcad32.exe to configure ODBC drivers.
Please use 32 bit ODBC datasource C:\WINDOWS\SysWOW64\odbcad32.exe to configure ODBC for HostMonitor.
Quote from manual:

Windows x64
HostMonitor is 32bit application that can be started on 64bit Windows OS. If you are using Windows x64 Edition and you want to setup ODBC Logging or ODBC test method, you should setup ODBC datasources using 32-bit ODBC Data Source Administrator (e.g. C:\WINDOWS\SysWOW64\odbcad32.exe).

seteor · Post by **seteor** » Thu May 05, 2011 3:03 am

I am sure, I was used 32 bit ODBC datasource C:\WINDOWS\SysWOW64\odbcad32.exe to configure ODBC for HostMonitor.
If Use 64 bit ODBC datasource C:\WINDOWS\System32\odbcad32.exe to configure ODBC for HostMonitor then the DataSourec can't be found in hostmonitor

I test connect with C:\WINDOWS\SysWOW64\odbcad32.exe is fine.

KS-Soft · Post by **KS-Soft** » Fri May 06, 2011 5:18 am

Does path to folder where HostMonitor is installed contain '(' or ')' symbols?
Then this problem can be caused by bug in Oracle software.

As we know Oracle fixed this problem in version 10.2.0.3

Regards
Alex