If you run your own SQL server, and want to interact with it, you can
use the ADODB Connection object
(http://msdn.microsoft.com/en-us/library/ms807027.aspx) to retrieve and
work with Recordset objects (http://support.microsoft.com/kb/168336). If
you're looking to access a local, non-server database, you might
investigate SQLite, although you may need to use another language than
VBScript to access its components.
Aaron
On 6/1/2011 6:21 AM, Richard Emling wrote:
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
--
Aaron Smith
Web Development * App Development * Product Support Specialist
GW Micro, Inc. * 725 Airport North Office Park, Fort Wayne, IN 46825
260-489-3671 * gwmicro.com
To insure that you receive proper support, please include all past
correspondence (where applicable), and any relevant information
pertinent to your situation when submitting a problem report to the GW
Micro Technical Support Team.
