Hi!
I did not get it wrong, that package has all the dll's you need. I had
someone in class have the same issue when she was learning it and connected
the way all here have just posted.
It is a matter of the commands/software in use that gives you those
commands. Just a suggestion on my part about the WAMP and having those
connections/software.
Bruce
Sent: Wednesday, June 01, 2011 6:21 AM
Subject: Re: Reading from MySqlTable?
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
>>
>>
>
>
