Specified driver could not be loaded due to systemerror 1114

AntonyP · Post by **AntonyP** » Tue Jun 06, 2006 2:53 am

I have setup HM to record all events to a MYSQL database using ODBC. I am getting many errors like the one below. Do you have any idea what may be wrong?

[2006-06-06 11:26:13] Sys ODBC log error. Error code: 4294967295 (Specified driver could not be loaded due to system error 1114 (MySQL ODBC 3.51 Driver).) Logging initiated by "Free hard disk space" test.

Added to this, i am also getting this notification:

[2006-06-06 11:18:58] Sys More than 20 consecutive ODBC errors occured.
ODBC logging paused for 10 min (use Options dialog to enable it again).

Where is this option available? What causes this 10min pause?

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 06, 2006 3:27 am

AntonyP wrote:[2006-06-06 11:26:13] Sys ODBC log error. Error code: 4294967295 (Specified driver could not be loaded due to system error 1114 (MySQL ODBC 3.51 Driver).) Logging initiated by "Free hard disk space" test.

What version of MySQL do you use? Do you use User DSN or System DSN? What version of libmysql.dll do you have?

AntonyP wrote:[2006-06-06 11:18:58] Sys More than 20 consecutive ODBC errors occured.
ODBC logging paused for 10 min (use Options dialog to enable it again).
Where is this option available? What causes this 10min pause?

It is correct behaviour. Quote from manual:
if there are more than 20 consecutive ODBC errors occur, HostMonitor suspends ODBC logging for 10 min. It helps to avoid reduction of performance when SQL Server unavailable.
If you correct problem (e.g. restart SQL Server or correct mistake in SQL Query), you may resume ODBC logging manually using Options dialog (just open dialog and click "Save" button).

Regards,
Max

AntonyP · Post by **AntonyP** » Tue Jun 06, 2006 3:33 am

I use SystemDSN, a MUSQL ODBC driver 3.51.12.
I could not find the file libmysql.dll anywhere!

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 06, 2006 3:39 am

AntonyP wrote:MUSQL ODBC driver 3.51.12.

Ok, but I would like to know what MySQL Server version do you use, not ODBC driver. 4? 5?

Regards,
Max

AntonyP · Post by **AntonyP** » Tue Jun 06, 2006 3:44 am

MySQL 5.

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 06, 2006 3:50 am

Are there any errors when you press Test button in Options > Advanced logs dialog? What account do you use to start HostMonitor? Does it have read/execute permissions on myodbc3.dll (located in windows\system32 directory)?

Regards,
Max

AntonyP · Post by **AntonyP** » Tue Jun 06, 2006 4:07 am

If i use the test function of the ODBC in HM, i get the same error

Error code: 4294967295 (Specified driver could not be loaded due to system error 1114 (MySQL ODBC 3.51 Driver)

If i test the connection through the ODBC in Control Panel of Windows, i get a normal connection with no errors. HM is started as local admin, which also has full read/write rights to the file you mentioned.

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 06, 2006 5:07 am

Very strange problem. According to Microsoft:
Error 1114 - A dynamic link library (DLL) initialization routine failed.

That means HostMonitor cannot load one of ODBC related dll's.
Do you use MySQL test or ODBC Query test? Are they works fine?
Any errors in EventLog?

Regards,
Max

AntonyP · Post by **AntonyP** » Tue Jun 06, 2006 5:22 am

I restarted the computer and everything is ok now. What can i say..

Thanks for your help anyway

AntonyP · Post by **AntonyP** » Wed Sep 27, 2006 3:49 am

I am having the exact same problem all over. No errors in the event viewer.

AntonyP · Post by **AntonyP** » Wed Sep 27, 2006 7:15 am

About the error i reported, i made some changes in the structure of the mysql database and i believe this may solve the problem. I will let you know asap.

I have now come across another problem, it has to do with the messages that HM sends to the mysql database (localization issues to be more specific).

I have setup 2 different mysql databases, one on a windows pc (mysql version 5.0.24a) and one on a linux pc (mysql version 5.0.16), using the same odbc connector (version 3.51.12 which is the latest stable one).

I configured the windows pc to use greek as default language and then set mysql (both win and linux) to use greek language and collations. When this did not work, i used utf-8 settings instead of greek. This didn't work either.

What i am getting so far from HM are strange characters (? or |) instead of greek ones.

I also thought it may be a problem with the oc running HM, so i also installed HM on another pc, also with greek default language, and tried to log in the above mysql databases. Again, the same weird characters.

What is your opinion about this?

KS-Soft · Post by **KS-Soft** » Wed Sep 27, 2006 12:52 pm

What i am getting so far from HM are strange characters (? or |) instead of greek ones.

HostMonitor does not show any Greek characters by itself, it uses English words only. So, question is where HostMonitor gets Greek words? Is it displayed as Reply value of some test? ODBC Query test? HostMonitor shows correct Greek characters as Reply value of the test?

PS Its better to use different topics for different problems

Regards
Alex

AntonyP · Post by **AntonyP** » Wed Sep 27, 2006 11:59 pm

No, i meant the greek words of the test names or comments.

AntonyP · Post by **AntonyP** » Thu Sep 28, 2006 1:23 am

I believe that HM writes data on the log files using PC ANSI. I think the problem with the characters on the mysql would be fixed if HM wrote the data using a more generic character set, like utf-8. Is this possible?

KS-Soft · Post by **KS-Soft** » Thu Sep 28, 2006 7:54 pm

H'm... HostMonitor uses SQLExecDirect function to record ODBC logs. According to Microsoft ODBC API reference this is the fastest way to submit an SQL statement. Unfortunately I cannot find in the manual any option to change character set

Regards
Alex

Specified driver could not be loaded due to systemerror 1114

Specified driver could not be loaded due to systemerror 1114

Re: Specified driver could not be loaded due to systemerror