HemlockPrinters
asked on
password in ODBC connection inclues ";"
I have a problem to connect to mysql database using ODBC and found that the password is
AB9O]]8y;y which include ";"
How can I write password in the connection string correctly?
Here is the connectin string
sConn = "ODBC;DSN=mysql;UID=userna me ;PWD=AB9O]]8y;y; DATABASE=mydatabase;"
AB9O]]8y;y which include ";"
How can I write password in the connection string correctly?
Here is the connectin string
sConn = "ODBC;DSN=mysql;UID=userna
What programming language and why don't you click on "Request Attention" and get this put in the MySQL zone if that is the database you're using?
How about putting the password in a string variable first, then putting that in the connection string:
sPass = "AB9O]]8y;y"
sConn = "ODBC;DSN=mysql;UID=username ;PWD=" & sPass & "; DATABASE=mydatabase;"
Have you tried double quotes around the password parameter?
sConn = "ODBC;DSN=mysql;UID=userna me ;PWD=\"AB9O]]8y;y\";DATABA SE=mydatab ase;"
sConn = "ODBC;DSN=mysql;UID=userna
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Lol there must be a way to do that!
ASKER
there is no other good solutions