Richard,
If you want to access a MySQL database from VBScript, then you must have
the ODBC connector installed. An example of connecting to an existing
database can be found here:
http://www.visualbasicscript.com/MySQL-DB-Connection-VBScript-Updated-m36318.aspx
Have you considered something else like SQLite? It's much more portable,
and unless you need access to scads of data or stored procedures, then
it may do the job. An example of calling it from VBScript is at
http://www.djhweb.co.uk/sqlite2.htm
Regards,
Steve
On 6/1/2011 3:34 AM, Richard Emling wrote:
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
--
Stephen Clower
Product support specialist
GW Micro, Inc. * 725 Airport North Office Park, Fort Wayne, IN 46825
260-489-3671 * gwmicro.com
