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

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

Date: Tue, 8 Feb 2005 13:31:49 -0600

I would think so too. However, the only DBA for the Informix system is the
vendor for the software we're using and the vendor does not want to help us
extract our own data. I personally do not feel comfortable messing around
with this DBMS if I can avoid it. Since Access is able to see and list the
tables/structures with ODBC in this one database, I was hoping for a
solution using it.

daver

"John Nurick" <j.mapSoN.nurick@dial.pipex.com> wrote in message
news:n6rg01lv9n8tdvilpcv09vko35ncongdab@4ax.com...
> 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.

Relevant Pages

  • Re: need final word on sysdba
    ... Otherwise only local sysdba connects are allowed. ... I suggest that you do not give the vendor the sys or system ID's. ... Rather grant DBA to an ID created for the vendor. ... slew of database object DDL privileges, that is, system privileges like ...
    (comp.databases.oracle.misc)
  • Re: Is Vendor or Customer Responsible for Tuning INITRANS / PCTFREE / PCTUSED ?
    ... Is it the DBA of the customer or the vendor? ... ideally this should be a vendor responsibility ... agnostic apps) don't have sufficient Oracle knowledge on board. ...
    (comp.databases.oracle.server)