Sorry, but I think you misunderstood me there. I already have a Mysql Server
running. What i need is a library *.dll, to access its contents from within
a vb-Script.
best
Richard
----- Original Message -----
From: "BT" <[email protected]>
To: <[email protected]>
Sent: Wednesday, June 01, 2011 12:16 PM
Subject: Re: Reading from MySqlTable?
Hi
There is a wamp or window Apache Mysql PHP software that is free.
That is the best software out there and it will give you all you need.
Just go to the WAMP web site and download the one for your system.
Bruce
Sent: Wednesday, June 01, 2011 3:34 AM
Subject: Re: Reading from MySqlTable?
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
