Change log to MS SQL ODBC

ThorreP · Post by **ThorreP** » Mon Mar 14, 2016 8:44 am

Hi Folks,

I'm struggeling to get the logging changed to database MS SQL. The needed ODBC connection can be created successfully (64 Bit and 32 Bit) but I can't selected it in the HostMon logging dropbox. When I enter the ODBC name manually I get error "The specified DSN contains architecture missbatch between the Driver and the Application".

Any ideas to get this settled?

Thanks a lot

ThorreP

KS-Soft · Post by **KS-Soft** » Mon Mar 14, 2016 9:44 am

>I can't selected it in the HostMon logging dropbox

"can't selected" == "datasource is not in the list"?
Have you created User DSN or System DSN?

Are you using HostMonitor GUI or RCC (Remote Control Console)?
HostMonitor started as application or service?

HostMonitor version?
Windows? Service Pack?

Regards
Alex

ThorreP · Post by **ThorreP** » Thu Mar 17, 2016 1:26 am

Hi Alex,

thanks for picking up. It looks like that I'm not using the correct ODBC Drivers. Can you tell me which one is correct one so this can be sorted out?

Here the answers to you questions
- Datasource is not in the list
- System DSN
- RCC is used
- Started as service
- Version 10.08
- Windows Server 2008 R2 x64 Enterprise

Regards
ThorreP

KS-Soft · Post by **KS-Soft** » Thu Mar 17, 2016 6:09 am

It looks like that I'm not using the correct ODBC Drivers. Can you tell me which one is correct one so this can be sorted out?

Driver for MS SQL server? "SQL Server" I think.
It does not matter what driver do you use - you should see datasource you created in the list (wrong driver will not work but you should see it anyway).

Here the answers to you questions
- Datasource is not in the list
- System DSN
- RCC is used

Have you created datasource on system where HostMonitor running (not RCC)?
Have you selected "DSN: System DSN" option on Misc page (HostMonitor/RCC Options dialog)?

Regards
Alex

ThorreP · Post by **ThorreP** » Thu Mar 17, 2016 9:39 am

Yup MS SQL is in use.
That datasource got created directly on HostMon Service Server and "DSN: System DSN" is enabled on Misc page.
I see some datasources in the list but they are not from the local HostMon Service Server. Looks like they are coming from a remote server.....
When I enter the created ODBC datasource name I get the architecture mismatch error.

Regards
ThorreP

KS-Soft · Post by **KS-Soft** » Thu Mar 17, 2016 10:24 am

Remote server?
May be you setup test for RMA (Remote Monitoring Agent)?
Could you please send screen shots to support@ks-soft.net?

Regards
Alex

ThorreP · Post by **ThorreP** » Fri Mar 18, 2016 4:40 am

There is no RMA setup in use.
Sent the requested screen shots

Regards
ThorreP

KS-Soft · Post by **KS-Soft** » Fri Mar 18, 2016 7:50 am

Wrong path to odbcad32.exe
Should be C:\Windows\SysWOW64\odbcad32.exe

Regards
Alex