View previous topic :: View next topic |
Author |
Message |
seteor
Joined: 04 May 2011 Posts: 2
|
Posted: Wed May 04, 2011 1:49 am Post subject: oracle ODBC test return ORA-12154:TNS:Could not resolve serv |
|
|
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. |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Wed May 04, 2011 7:39 am Post subject: oracle ODBC test return ORA-12154:TNS:Could not resolve serv |
|
|
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:
Quote: | 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). |
|
|
Back to top |
|
|
seteor
Joined: 04 May 2011 Posts: 2
|
Posted: Thu May 05, 2011 3:03 am Post subject: |
|
|
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. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12794 Location: USA
|
Posted: Fri May 06, 2011 5:18 am Post subject: |
|
|
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 |
|
Back to top |
|
|
|