Oracle ODBC Drivers problem

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
User avatar
Gilali
Posts: 35
Joined: Fri Aug 22, 2008 4:04 am
Location: Belgium

Oracle ODBC Drivers problem

Post by Gilali »

Hi,
I have installed the new HM on Windows 2008 R2 x64 server.
I have used instantclient windows x64 ver 12.1.0.2.0 to install Oracle Driver.
I have defined all my DB's oracle connectors rightly.
To verify if all is correct, I try connection from windows ODBC data source administrator, and the result is "Connection Successful" from all my connectors. :D

When I tried to use these connectors in HM to make my Oracle DB tests by ODBC query, I can't see the connector in Data source combo ???!! :o
I have verified the registry, and all connectors are defined in HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI. :roll::roll:

Help will be appreciate ':)

Regards,
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

Some quotes from the manual

1) 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).

2) User DSN/System DSN
As you know Windows has system data source names (System DSN) and user data source names (User DSN). System data sources are local to a computer but not user-dedicated; any user with privileges can access a system DSN. User data sources are local to a user and accessible only by the specified user. Using "User DSN/System DSN" option you can choose which data sources list will be used by HostMonitor.
This option located on Misc page in Options dialog.
Please note if you start HostMonitor as service, it will not be able to use User DSN. Only System DSN will be used . So, if you are planning to start HostMonitor as service and as regular application, use "System DSN" option. In this case HostMonitor will work equally in both modes.

3) Usually ODBC drivers from Oracle have many bugs and can lead to various problems. We recommend to use Microsoft ODBC driver for Oracle

Regards
Alex
User avatar
Gilali
Posts: 35
Joined: Fri Aug 22, 2008 4:04 am
Location: Belgium

Post by Gilali »

Hi Alex,

Thank's for your quick reply :lol:
you should setup ODBC datasources using 32-bit ODBC Data Source Administrator
I saw it, but too late, I have already sent my post ... :oops:
3) Usually ODBC drivers from Oracle have many bugs and can lead to various problems. We recommend to use Microsoft ODBC driver for Oracle
Ok, I'll uninstall oracle ODBC for Microsoft ODBC.

One more time, thank's for your help ... as usual, it's perfect :wink:

Regards,
Post Reply