Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • 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;"
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?
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

Have you tried double quotes around the password parameter?
 sConn = "ODBC;DSN=mysql;UID=username ;PWD=\"AB9O]]8y;y\";DATABASE=mydatabase;"
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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