Richard, have a google on the terms mysql and oledb (I believe you would rather have an oledb drive for ado rather than an odbc one). hopefully, such a query will turn up what you need; once installed, if you follow Ron's instructions for removing the server., plus any provided by the oledb driver, you should be able to get it working.
I did this some time back using a SQLite oledb driver, and an ADO query from a WE VBScript worked fine. this wasn't a script I intended to publish, but was just converting something; the idea though should be exactly the same for you to use mysql. hth, Chip -----Original Message----- From: Richard Emling [mailto:[email protected]] Sent: Wednesday, June 01, 2011 6:21 AM To: [email protected] 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 >> >> > >
