Connection string special characters
Posted by: Sven Jupp
Date: January 02, 2024 12:19PM

I have a visual studio Windows form programme that I connect to a MySQL database. I recently updated the server and now it wants special characters in the password. The problem I have is when the connection string is passed to the database the special characters through an error. I have connected to the database via and ODBC connection in excel, so I know my connection string works its just when Visual Studio 2019 sends it to the server that something goes wrong. I have no idea how to solve this one. I am using the latest The password has a * character in it. I have tried other characters with no success.

I writing my programme in vb, but I have tried the connection string builder to no effect. I am using vsto 2019. I have updated the to the latest ( The database is MariaDB 10. The project is a Windows Forms Application with .NET framework 4.8.

When I pass the connection string with a special character in the password I get the following error message: 'Object cannot be cast from DBNull to other types.'.

When I pass the connection string with the special character removed (as a test really) I get the following error message: 'Authentication to host '' for user 'SDJ' using method 'mysql_native_password' failed with message: Access denied for user 'SDJ'@'' (using password: YES)'

I can connect to the database using an ODBC connection via excel, so its something to do with how vsto is passing the password during connection.

Options: ReplyQuote

Written By
Connection string special characters
January 02, 2024 12:19PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.