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
>
>
