<div>
thanks, i came already to this stage but didnt had success before, somehow that works<br />
only for me if i follow in detail your given sample from<br />
<a href="http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForMySQL" rel="ugc">http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForMySQL</a><br />
including all the options, guess that was the problem.<br />
<br />
One more thing, will this work with the latest mysql version 5 as well ?<br />
<br />

</div>


thanks, i came already to this stage but didnt had success before, somehow that works
only for me if i follow in detail your given sample from
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForMySQL [http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForMySQL]
including all the options, guess that was the problem.

One more thing, will this work with the latest mysql version 5 as well ?



<div>
Yes, this driver should compatible for latest mysql version 5.
</div>


Yes, this driver should compatible for latest mysql version 5.

<div>
<div class="content wysiwyg-content">
Hi,<br />
i'm using vbscript and would like to know how i could do the following ado statement to a mysql<br />
server:<br />
<br />
'used on a ms sql:<br />
Set objDBConnection = CreateObject(&quot;ADODB.Connec<wbr />tion&quot;) <br />
sConnectionString &nbsp;= &quot;Provider=SQLOLEDB; Data Source=&quot; &amp;&nbsp;sSQLServer &amp;&nbsp;&quot;; Initial Catalog=&quot; &amp;&nbsp;sCatalog &amp;&nbsp;&quot;; User Id=user; Password=pass&quot;<br />
objDBConnection.Open sConnectionString <br />
Set objRs = objDBConnection.Execute(&quot;S<wbr />ELECT field FROM table order by arg&quot;)<br />
objRs.movefirst<br />
Do While Not objRs.EOF<br />
&nbsp; .....<br />
&nbsp; objRs.movenext<br />
&nbsp;loop<br />
<br />
Many thanks<br />
Matt. <br />
&nbsp;
</div>
</div>


Hi,
i'm using vbscript and would like to know how i could do the following ado statement to a mysql
server:

'used on a ms sql:
Set objDBConnection = CreateObject("ADODB.Connection") 
sConnectionString  = "Provider=SQLOLEDB; Data Source=" & sSQLServer & "; Initial Catalog=" & sCatalog & "; User Id=user; Password=pass"
objDBConnection.Open sConnectionString 
Set objRs = objDBConnection.Execute("SELECT field FROM table order by arg")
objRs.movefirst
Do While Not objRs.EOF
  .....
  objRs.movenext
 loop

Many thanks
Matt. 
 

Mysql select statement with vbscript

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.