Richard,
Have you installed the ODBC connector for MySQL, and did you add the
database in the ODBC control panel applet?
Regards,
Steve
On 5/31/2011 8:59 AM, Richard Emling wrote:
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
--
Stephen Clower
Product support specialist
GW Micro, Inc. * 725 Airport North Office Park, Fort Wayne, IN 46825
260-489-3671 * gwmicro.com
