KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

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

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports
View previous topic :: View next topic  
Author Message
seteor



Joined: 04 May 2011
Posts: 2

PostPosted: Wed May 04, 2011 1:49 am    Post subject: oracle ODBC test return ORA-12154:TNS:Could not resolve serv Reply with quote

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
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Wed May 04, 2011 7:39 am    Post subject: oracle ODBC test return ORA-12154:TNS:Could not resolve serv Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
seteor



Joined: 04 May 2011
Posts: 2

PostPosted: Thu May 05, 2011 3:03 am    Post subject: Reply with quote

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
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12339
Location: USA

PostPosted: Fri May 06, 2011 5:18 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index