Solved

password in ODBC connection inclues ";"

Posted on 2013-06-07
6
298 Views
Last Modified: 2013-07-22
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
Comment
Question by:HemlockPrinters
6 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39230895
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
 
LVL 6

Expert Comment

by:Michael
ID: 39231103
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
 
LVL 8

Expert Comment

by:lomo74
ID: 39231189
Have you tried double quotes around the password parameter?
 sConn = "ODBC;DSN=mysql;UID=username ;PWD=\"AB9O]]8y;y\";DATABASE=mydatabase;"
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Accepted Solution

by:
HemlockPrinters earned 0 total points
ID: 39245404
thanks, but i still can't get it work.
I just changed the password not to include ";"
0
 
LVL 8

Expert Comment

by:lomo74
ID: 39245438
Lol there must be a way to do that!
0
 

Author Closing Comment

by:HemlockPrinters
ID: 39345499
there is no other good solutions
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now