Access violation: check MS SQL Server

mholloway_uk · Post by **mholloway_uk** » Tue Aug 26, 2008 11:08 am

Hi,

We keep getting errors of the following format in a number of "check MS SQL Server" tests:

"Access violation at address 00F3197C in module '_mssql.pyd'. Read of address 76726557"

Manual tests verify that the databases are available and accessible from the monitoring server. Logging onto the Hostmonitor UI and refreshing the individual tests seems to resolve the issue.

Please can someone advise us what might be causing this and how we can resolve it.

Thanks in advance

MH

KS-Soft · Post by **KS-Soft** » Tue Aug 26, 2008 11:38 am

Looks like error occurs in MS Client library. What version of MS SQL Client do you use?
You may try to put the following DLL into HostMonitor folder: www.ks-soft.net/download/ntwdblib.zip (sometimes old clients and ODBC drivers work better than new one...)
Just unzip the file and restart HostMonitor.

Regards
Alex

mholloway_uk · Post by **mholloway_uk** » Thu Aug 28, 2008 2:45 am

Thanks for your help.

I tried this. It didn't seem to work immediately... the error reoccurred a couple of times within a few hours of installing this dll and restarting. It seems to be ok now though... I've not seen the error for 2 days, but I'll keep watching.

Just to make sure, please can you confirm that I placed the dll in the correct location: C:\Program Files\HostMonitor5 i.e. the location that hostmon.exe is installed.

(BTW, I.m using V7.22c on Win Server 2003. Forgot to put this in the original post!)

Cheers

MH

KS-Soft · Post by **KS-Soft** » Thu Aug 28, 2008 11:17 am

Just to make sure, please can you confirm that I placed the dll in the correct location: C:\Program Files\HostMonitor5 i.e. the location that hostmon.exe is installed.

Yes, Windows should load DLLs located in startup folder instead of DLLs located in the folders specified in PATH string.

I tried this. It didn't seem to work immediately... the error reoccurred a couple of times within a few hours of installing this dll and restarting
"Access violation at address 00F3197C in module '_mssql.pyd'. Read of address 76726557"

I cannot find any information regarding "_mssql.pyd" file. I though it comes with MS SQL Client software but it does not. ".PYD" extension can be used for Python extension modules.
How it can be used with your MS SQL Server?? Where did you get this file?

Regards
Alex

ironcurtain · Post by **ironcurtain** » Tue Sep 02, 2008 6:17 am

The Python mssql extension can be found from :
http://pymssql.sourceforge.net/