Dear Scripters,
I am about to write a WE App wich uses stuff from a MySql Database. As far
as i heard, I can make use of ADO to retrive this information. Sadly i get
an Error in Line 5, telling me that variable isn't declared. Here my code:
option explicit
dim myserver, mydatabase, myconn, connection, sql
myserver = "localhost"
mydatabase = "test"
set myconn = server.createobject("adodb.connection")
connection = "driver={MySQL};server=myserver;uid=demo;database=mydatabase"
myconn.open (connection)
set result = server.createobject("adodb.recordset")
sql = "SELECT * FROM test"
set result = myconn.execute(sql)
if not result.EOF then
' print lines
end if
Who can give my some advice, or can provide with a working solution for
mysql connections from VB-Script?
Best wishes
Richard
