<div>
What programming language and why don't you click on &quot;Request Attention&quot; and get this put in the MySQL zone if that is the database you're using?
</div>


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?

<div>
How about putting the password in a string variable first, then putting that in the connection string:<br />
<br />

<pre><code id="code-20-39231103-1">sPass = &quot;AB9O]]8y;y&quot;
sConn = &quot;ODBC;DSN=mysql;UID=username ;PWD=&quot; &amp; sPass &amp; &quot;; DATABASE=mydatabase;&quot;</code></pre>
</div>


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;"

<div>
Have you tried double quotes around the password parameter?<br />
&nbsp;sConn = &quot;ODBC;DSN=mysql;UID=userna<wbr />me ;PWD=\&quot;AB9O]]8y;y\&quot;;DATABA<wbr />SE=mydatab<wbr />ase;&quot;
</div>


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

<div>
Lol there must be a way to do that!
</div>


<div>
there is no other good solutions
</div>


<div>
<div class="content wysiwyg-content">
I have a problem to connect to mysql database using ODBC and found that the password is <br />
AB9O]]8y;y which include &quot;;&quot;<br />
<br />
How can I write password in the connection string correctly?<br />
<br />
Here is the connectin string<br />
<br />
sConn = &quot;ODBC;DSN=mysql;UID=userna<wbr />me ;PWD=AB9O]]8y;y; &nbsp;DATABASE=mydatabase;&quot;
</div>
</div>


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;"

password in ODBC connection inclues &quot;;&quot;

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

password in ODBC connection inclues &quot;;&quot;

password in ODBC connection inclues ";"