M
Me.com
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. Database 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.
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. Database 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.