ODBC Error: Cannot execute SQL query. ErrorCode 4294967295

Wolfgang Bach · Post by **Wolfgang Bach** » Fri May 22, 2009 2:13 am

Hello KS-Soft,

i have a problem with an ODBC query alert. Nearly 30% of the total tests on this item are replying "unknown" with this syslog entry:

[22.05.2009 08:06:44] Sys Error: Cannot execute SQL query. ErrorCode 4294967295: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server existiert nicht oder Zugriff verweigert
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())

I have nearly 20 tests of ODBC tests an all are fine, except this one.

Running Hostmon 8.00 on Windows Server 2003.

Regards.

KS-Soft Europe · Post by **KS-Soft Europe** » Fri May 22, 2009 2:27 am

Do you mean all your 20 ODBC tests use the same ODBC Source?
If I understand properly, error means "the server does not exists", right?
Could you check if ODBC source is setup properly?
Do you get this error on regular basis or time after time?
What exact MS SQL driver do you use? Version?
What exact query?

On the other hand, such a behavior can be caused by antiviruses. Do you use any antivirus on tha machine, where HostMonitor is running?

Regards,
Max

Wolfgang Bach · Post by **Wolfgang Bach** » Tue Jun 02, 2009 6:13 am

Hello Max,

Do you mean all your 20 ODBC tests use the same ODBC Source?

No, the test which fails uses its own ODBC-Source

If I understand properly, error means "the server does not exists", right?

Correct.

Could you check if ODBC source is setup properly?

Looks good and i can succesfully test the odbc-source in Computer-Management.

Do you get this error on regular basis or time after time?

unregular.

What exact MS SQL driver do you use? Version?

How can i see it?

What exact query?

SELECT Sparte, System, Funktion FROM V_SY_MONITORING

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 02, 2009 6:29 am

Wolfgang Bach wrote:Do you get this error on regular basis or time after time?
unregular.

Hm. Looks like SQL server or some third party software (antivirus, firewall, etc.) blocks connection sometimens. I do not see another explanation...
I can suggest you a simple workaround. You may setup additional "ODBC Query" test with disabled "Execute SQL query" option and mark this test as "Master" for you initial "ODBC Query" test. It means dependant test will be performed only when first test check connection successfully.

As alternative, you may add "Repeat test" action to the alert profile and adjust another actions in this profile to be fired after second "Bad" attempt. Quote from the manual: http://www.ks-soft.net/hostmon.eng/mfra ... #actRepeat
======================================
This action simply forces the program to perform the test one more time (not waiting until time of the test interval is elapsed). It does not have any extra parameters except common action parameters.

This action can be helpful in situations when the condition being checked is not stable. If, for some reason, the accuracy of the test is questionable, you can add this action into alert profile, and take the necessary measures based on the results of the follow-up test.
======================================

Wolfgang Bach wrote:What exact MS SQL driver do you use? Version?
How can i see it?

You may find it out using standard Windows "ODBC Data Source Administrator" applet ("Start" -> "Programs" -> "Adminisrative Tools" -> "Data Sources (ODBC)").

Regards,
Max

KS-Soft · Post by **KS-Soft** » Tue Jun 02, 2009 12:48 pm

May be both problems caused by the same reason...
Please update software, check system for trojan and then try to disable antivirus.

Regards
Alex