[Pharo-project] ODBC: table names and column names/types?

[Benoit St-Jean]

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 at gmail.com>
To: Pharo-project at 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 at 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 at anest.ufl.edu>
>To: "Pharo-project at lists.gforge.inria.fr" <Pharo-project at 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 at lists.gforge.inria.fr >[mailto:pharo-project-bounces at lists.gforge.inria.fr] On Behalf Of Mariano 
>Martinez Peck
>Sent: Tuesday, September 01, 2009 3:18 AM
>To: Pharo-project at 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 at 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 at lists.gforge.inria.fr >>  [mailto:pharo-project-bounces at lists.gforge.inria.fr] 
>>  On Behalf Of Esteban A. Maringolo
>>Sent: Monday, August 31, 2009 6:38 
>>  PM
>>To: Pharo-project at lists.gforge.inria.fr
>>Subject: 
>>  Re: [Pharo-project] ODBC: table names and column names/types?
>>
>>Hello 
>>  Bill,
>>
>>2009/8/31 Schwab,Wilhelm K <bschwab at 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 at lists.gforge.inria.fr
>>http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>>
>>_______________________________________________
>>Pharo-project 
>>  mailing list
>>Pharo-project at 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 at 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gforge.inria.fr/pipermail/pharo-project/attachments/20090901/5acf335a/attachment.htm>