krishna
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: SQL Results Table Display
Just now, krishna said: 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. @Mike Suding0Views0likes0CommentsRe: SQL Results Table Display
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.1View0likes0Comments