MySQL database from vbscript; ODBC to MySQL

[Shrp]

I have some vbscripts that query ODBC, but I want to
have it query some MySQL databases I have, instead.

Currently I have:

...
Set numConnection = Server.CreateObject("ADODB.Connection&quot
numConnection.Open "dbname"
NumQuery = "SELECT * from dbname WHERE field = " & Field1
Set rsNumList = numConnection.Execute(NumQuery)
...

How would these statements change with a MySQL database?

Overall, I wanted to find someone to host my web pages, but
find that ODBC is rarer and pricier and more places will
host MySQL, instead. So I wanted to migrate my pages from
ODBC to MySQL.

Thanks!

 

[snowboardr]

Hosting: Ophelus.com the owner of the company is doing the final testing of mysql and should be up with a day or so. But this host is the BEST, they off MSsql too. good pricing.


I wrote a tutorial on connecting to MySQL at pscode.com if you get a chance vote on it.. thanks

http://pscode.com/vb/scripts/ShowCode.asp?txtCodeId=7739&lngWId=4

www.vzio.com

/

 

[snowboardr]

You won't have to change much though, just the connection. www.vzio.com

/