Forum Discussion
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.
Related Content
- 4 months ago
- 2 months ago