Forum Discussion

Athique_Ahmed's avatar
Athique_Ahmed
6 years ago

SQL Results Table Display

Hi, LogicMonitor beginner here! I have a sql statement which outputs outstanding orders currently in the system and what date they are outstanding from. It may show as follows... 1...
krishna's avatar
krishna
6 years ago

hi Mike,

many thanks for the blog post and it was helpful in connecting to SQL Server.

however, i tried to connect to MySQL DB and getting below error. 

QueryException: Could not connect: Access denied for user 'COLLECTORUSER'@'localhost' (using password: NO)
Current charset is windows-1252. If password has been set using other charset, consider using option 'passwordCharacterEncoding'

code is changed as below for MySQL :

//Build connection string (set integrated security here)
String Connection_String = 'jdbc:mysql://##HOSTNAME##:3306/##DBNAME##?connectTimeout=30000&socketTimeout=30000&passwordCharacterEncoding=windows-1252'

 

could you please help fix the isssue.