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".
---------------------------------------------------------------------
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".
---------------------------------------------------------------------
I'm trying to access a MySQL server using the "SQLServerUsingADO.vee"
example, however I am finding that it can't locate the MySQL server. The
server is local to the machine where Vee is installed and so I am specifying
"(local)" in the "server" field as is recommended in the notes on the
example. The error message I get back is "[DBNMPNTW] Specified SQL server
not found".
Are there any special tricks to getting the two to work? Does ADO work with
MySQL, or is it just SQL?
----
Craig McIntyre
Software Engineer
Simulation Group
Electronic Systems Division
Tenix Defence Pty Ltd
---------------------------------------------------------------------
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".
---------------------------------------------------------------------