Re: Access can show external tables in ODBC, so why can't vb.net apps do it?

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 02/08/05 

Date: Tue, 08 Feb 2005 07:42:47 +0000

Surely it's possible to run a query against the Informix system tables
to return a list of the tables or views your app's user can see? Your
DBA should be able to help with this.

On Mon, 7 Feb 2005 18:21:04 -0600, "Me.com" <j@me.com> wrote:

>I have a need for listing all the tables and their structures in an informix
>database. The only connection I can make work is ODBC. I've tried to
>connect using the OLE DB connection but it fails. However, if I open MS
>Access and do a link through the ODBC, it lists all the tables etc.
>>From threads I've read here and other Newsgroups, I'm told there is no way
>to read tables/structures with ODBC.
>This database has literally hundreds of tables and I'm searching for just a
>couple of them. Vendor is no help for data dictionary.
>
>Is there a way to use something in Access combined with vb.net to get this
>information? I know it may not be pretty, but it's a one time deal and
>we're done.
>
>Any thoughts, directions or otherwise will be appreciated.
>thanx.
> 

--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.