Hi,
I saw that I would have to register in order to download the ODBC-Driver.
Isn't there some other *.dll file out, wich i could package with my script
and load the needed parts from there? Do i explizitly need Ado or ODBC? If
possible, provide me with an example how to establish a mysql connection
from within vbs.
Thanks in advance
Richard
----- Original Message -----
From: "Stephen Clower" <[email protected]>
To: <[email protected]>
Sent: Tuesday, May 31, 2011 3:04 PM
Subject: Re: Reading from MySqlTable?
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
