AnsweredAssumed Answered

vrf Accessing MySQL database

Question asked by VRFuser on May 2, 2002
Mike,

Perhaps this will help

http://www.mysql.com/products/myodbc/manual.html

ODBC can be a pain if easy distribution of your product is an issue.  You
have to create the ODBC data set name (DSN) on each machine when you install
your product.  You might be happier with DSN-less ADO connections in the
long run, but I have not found any hints on how to make that work.

You might try asking your question in a forum for MySQL users.  Many people
there be familiar with ADO.  You will have to do the VEE translation, but
that should be straightforward.

For what it's worth, I found this by searching for "mysql ado" at
http://www.google.com .  I also found articles searching for "mysql" at
http://msdn.microsoft.com but most of them seemed to reference ODBC also.

   ...david

-----Original Message-----
From: SHERRILL,DAVID S (A-hsgAndover,ex1)
[mailto:david_sherrill@hsgmed.com]
Sent: Thursday, May 02, 2002 9:27 AM
To: 'M Watts'
Cc: VEE Reflector (E-mail)
Subject: RE: vrf Accessing MySQL database


Mike,

I would not be surprised if the ADO service for Microsoft SQL Server 7
connections did not work for other SQL servers.  I would suggest installing
the Microsoft product to verify that you can get the demos to run as
originally intended and tested.  Then move on to making them work with
MySQL.

I have heard that the desktop-only version of Microsoft SQL Server 7 is
available for free download, but I have not verified that for myself.  This
version will provide the services of an SQL server but only for applications
running on the same machine.

   ...david

David Sherrill
Software Engineer, Ultrasound
Philips Medical Systems

-----Original Message-----
From: MCINTYRE Craig [mailto:Craig.McIntyre@tenix.com]
Sent: Wednesday, May 01, 2002 8:04 PM
To: 'M Watts'
Cc: VEE Reflector (E-mail)
Subject: RE: vrf Accessing MySQL database


Hi Mike,

You can download MySQL for both unix and windows (see http://www.mysql.org).
I'm certainly not a database guru, but I would assume that since MySQL is
supposed to compatible with SQL that this linkage should be possible.
Perhaps I'm doing something silly, or perhaps it just needs the right
parameters. I also have ODBC drivers for it installed.

The database concerned has come from our customer and since they have
developed all the tools to utilise this database it is a fixed element of
the design of the solution. Certainly a microsoft tool would simplify things
in this regard, but at this stage that is fairly unlikely to happen.

----
Craig McIntyre

Software Engineer
Simulation Group
Electronic Systems Division
Tenix Defence Pty Ltd
100 Arthur St., Nth Sydney, NSW 2060
Ph:  (02) 9963 9733   Fax: (02) 9964 0988   Mob: 0412 779 574
Email: Craig.McIntyre@Tenix.com



-----Original Message-----
From: M Watts [mailto:MikeJWatts@compuserve.com]
Sent: Wednesday, 1 May 2002 8:06 PM
To: MCINTYRE Craig
Subject: vrf Accessing MySQL database


Hi Craig,
         This is of interest to me, although I have not tried it yet.
Isn't MySQL a Linux product?  I just don't know what the linkage is.

I think the way I would approach it is ( assuming you have Access or Excel
): can I connect to it via a Microsoft tool?  If not then you need to find
out the mechanism that you can use to communicate with the database.  What
do you use at present?


Best of Luck,

Mike Watts
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.agilent.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.agilent.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.agilent.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------

Outcomes