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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Me.com (j_at_me.com)
Date: 02/08/05 

Date: Mon, 7 Feb 2005 18:21:04 -0600

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.

Relevant Pages

  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: Ada DB bindings and APQ
    ... >>I didn't like the use of handles for database objects. ... > will ensure that the connection will not go away until at least one query ... > things which can be made with a connection. ... That is different to ODBC. ...
    (comp.lang.ada)
  • Re: Mailmerge using a secure database
    ... Database does not have a long path name. ... When I tried re-opening my mail merge documents I get an error message ... Do you need or want specifically to connect with ODBC? ... likely to run into problems where Word truncates the connection string ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Linking Access f/e to Access b/e via ODBC
    ... > Is it possible then to create an ODBC connection to use the ISAM driver ... If I understand your question correctly, the ISAM driver for Jet _is_ what ... you're getting when you create the DSN for an Access database file. ... the ODBC Data Source Administrator can create the DSN to the Access ...
    (microsoft.public.access.externaldata)
  • Re: Data Source Lost When Merge From Access to Word
    ... DDE was the default connection method and ODBC was the alternative as far as Access/Jet sources were concerned. ... In Word 2003, OLE DB is the default, but unfortunately when you have selected your database, Word does not display the Access tables that are linked to ODBC data sources. ... create one query in your Access database for each linked table you want to use, with SELECT * FROM, and use that as the data source. ...
    (microsoft.public.word.mailmerge.fields)