Well, no need to use a native driver for that. A simple "standard" SQL statement issued through an ODBC connection against the INFORMATION_SCHEMA.TABLES table would do the job. ----------------- Benoit St-Jean Yahoo! Messenger: bstjean Blog: lamneth.wordpress.com A standpoint is an intellectual horizon of radius zero. (Albert Einstein) ________________________________ From: Mariano Martinez Peck <marianopeck@gmail.com> To: Pharo-project@lists.gforge.inria.fr Sent: Tuesday, September 1, 2009 9:23:23 AM Subject: Re: [Pharo-project] ODBC: table names and column names/types? You can use the native MySQL driver if you want to do what Benoit St-Jean said. SqueakDBX with MySQL doesn't work yet under Windows, but there is a lot of people asking about that, so I think we must get MySQL another round :( Is somewhere a C (under Windows) guru here? Because the problem is: I can compile OpenDBX with the MySQL client library in Windows but in runtime, when I try to run the OpenDBX tests, I have a crash :( And In windows I cannot see even the stack...If there is someone capable to help me, please send me a private email. I will really appreciate the help. Best, Mariano 2009/9/1 Benoit St-Jean <bstjean@yahoo.com> Which version of MySQL? Since version 4.1, there's all you need in the "INFORMATION_SCHEMA" database, in the "TABLES" table. But because of some bug in 4.1, query against that database sometimes caused the server to crash. I'd recommend that method only for 5.x and upwards.
----------------- Benoit St-Jean Yahoo! Messenger: bstjean Blog: lamneth.wordpress.com A standpoint is an intellectual horizon of radius zero.
(Albert Einstein)
________________________________ From: "Schwab,Wilhelm K"
<bschwab@anest.ufl.edu> To: "Pharo-project@lists.gforge.inria.fr" <Pharo-project@lists.gforge.inria.fr> Sent: Tuesday, September 1, 2009 6:58:49 AM
Subject: Re: [Pharo-project] ODBC: table names and column names/types?
Primarily MySQL running on Windows (Linux as soon as reasonable to do so) accessed from both Windows and Linux. There will also be the occaisional .mdb file.
________________________________ From: pharo-project-bounces@lists.gforge.inria.fr >[mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Mariano
Martinez Peck Sent: Tuesday, September 01, 2009 3:18 AM To: Pharo-project@lists.gforge.inria.fr Subject: Re: [Pharo-project] ODBC: table names and column names/types?
On Mon, Aug 31, 2009 at 10:00 PM, Schwab,Wilhelm K <bschwab@anest.ufl.edu> >wrote:
I
looked through it in MC, but did not see anything obvious. Even then, I doubt it is a workable choice for me because regardles of what X and - mean in their doumention, one of the DBMS/OS pairs I need is not supported.
Hi Bill! Which is the combination of your RDBMS / OS ?
Regards from the ESUG :)
Mariano
-----Original Message----- From: pharo-project-bounces@lists.gforge.inria.fr >> [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Esteban A. Maringolo Sent: Monday, August 31, 2009 6:38 PM To: Pharo-project@lists.gforge.inria.fr Subject: Re: [Pharo-project] ODBC: table names and column names/types?
Hello Bill,
2009/8/31 Schwab,Wilhelm K <bschwab@anest.ufl.edu>:
Hello all,
Is there anything available for Pharo that gives
schema information about a database?
Doesn't SqueakDBX do that?
Regards,
Esteban A. Maringolo
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
________________________________ Make your browsing faster, safer, and easier with the new Internet Explorer® 8. Optimized for Yahoo! Get it Now for Free! _______________________________________________
Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
__________________________________________________________________ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/