• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

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=username ;PWD=AB9O]]8y;y;  DATABASE=mydatabase;"
0
HemlockPrinters
Asked:
HemlockPrinters
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
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?
0
 
MichaelBusiness AnalystCommented:
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;"

Open in new window

0
 
lomo74Commented:
Have you tried double quotes around the password parameter?
 sConn = "ODBC;DSN=mysql;UID=username ;PWD=\"AB9O]]8y;y\";DATABASE=mydatabase;"
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
HemlockPrintersAuthor Commented:
thanks, but i still can't get it work.
I just changed the password not to include ";"
0
 
lomo74Commented:
Lol there must be a way to do that!
0
 
HemlockPrintersAuthor Commented:
there is no other good solutions
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now