Re: [mdb-dev] Re: SQLTables

[<br...@br...>]

Much of the ODBC driver was copied from my other project, FreeTDS. 
This is a SQL Serverism and really doesn't belong.  For a better idea
of what should be happening in commands like SQLTables(),
SQLTypeInfo(), etc... look at the code for "LIST TABLES" or "DESCRIBE
TABLE" in the SQL engine.  It creates a one page temp table and
populates it, then fakes the client into reading from this instead of
the regular mdb file.  It's a bit of a kludge at the moment, but you
can see where it's going (multifile support).

One caveat, if the results are > 1 page (2k or 4k in Jet3/4
respectively) the thing will probably core dump.  I intend to fix this
problem after releasing 0.6pre1 by using true multi page temp files.

Brian

On Sun, 29 Feb 2004 14:06:16 -0800 (PST), Jeff Smith wrote:

> 
> I should have done more research before writing this.
> I had originally assumed this was something specific to
> mdbtools.  My mistake. :-)  I'm working on a fix (or at
> least a hack) for this now.
> 
>  -- Jeff S
> 
> 
> --- Jeff Smith <why...@ya...> wrote:
> > SQLTables in src/odbc/odbc.c appears to be passing "exec sp_tables"
> to
> > libmdbsql.  However, libmdbsql seems to know nothing of exec or
> sp_tables.
> > Was this usage in the ODBC driver based on obsolete usage, or
> > yet-to-be-implemented usage in libmdbsql?
> > 
> >  -- Jeff S
> 
> 
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools
> 
> 
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev