Specified driver could not be loaded due to systemerror 1114

[Yoorix]

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?

You may try to insert following string into "Initial Statement" input box of the MYSQL ODBC connector (Administrative Tools > Data Sources ODBC > System DSN > Your Datasource > Connect Options tab):

Code: Select all

set character_set_client=greek,character_set_connection=greek,character_set_database=greek,character_set_results=greek,collation_connection=greek_general_ci,collation_database=greek_general_ci,names greek

Regards,
Yoorix

[KS-Soft Europe]

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 utility do you use to access to the MySQL database on windows? I suppose, you use console mysql.exe, right? Could you connect to the database and type following query:

Code: Select all

show variables like 'character_set%';

What output do you see? Could you show us such information?

Regards,
Max

[AntonyP]

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?

You may try to insert following string into "Initial Statement" input box of the MYSQL ODBC connector (Administrative Tools > Data Sources ODBC > System DSN > Your Datasource > Connect Options tab):

Code: Select all

set character_set_client=greek,character_set_connection=greek,character_set_database=greek,character_set_results=greek,collation_connection=greek_general_ci,collation_database=greek_general_ci,names greek

Regards,
Yoorix

That didn't help

[AntonyP]

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 utility do you use to access to the MySQL database on windows? I suppose, you use console mysql.exe, right? Could you connect to the database and type following query:

Code: Select all

show variables like 'character_set%';

What output do you see? Could you show us such information?

Regards,
Max

Query show variables like 'character_set%', Sat Sep 30 11:50:35 2006
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

[KS-Soft Europe]

Query show variables like 'character_set%', character_set_database latin1
character_set_server latin1

So, there are variables from Linux machine.
You should also specify the utf8 encoding for both database and server.
You may use command:

Code: Select all

ALTER DATABASE _Your_DatabaseName_ CHARACTER SET UTF8; 

to set encoding for the database.
To set encoding for the server you should make minor changes in my.ini file (on Windows). On Linux you should do the same changes in my.cnf, but I am not sure.
1. Section [mysql]
Add (or change) the following line: default-character-set=utf8
2. Section [mysqld]
Add (or change) the following line: default-character-set=utf8
Restart the MySql server after changes.
Please note: I suppose, you should backup all databases before making changes, just in case.

Query show variables like 'character_set%' now should output:
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

With foregoing configuraion, HostMonitor works correctly with international characters, like greeks.

To test it you may use ODBC Query test window and prepare several INSERTs with natinal characters and then query SELECT for appropriate values.

Regards,
Max