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

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: Trusted Connection
    ... HOWEVER, for one of my users, I will create an ODBC DSN ... for my test database ON THEIR COMPUTER, ... So, when I set up the ODBC DSN connection for this user, ... >> Our SQL Server was set up NOT by me, ...
    (microsoft.public.sqlserver.security)