Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Getting Tables From Database Using ODBC
Fri, Sep 26 2008 5:33 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi,

How can I get a list of all tables in a database using the ODBC driver
and DBISAM version 4?

I need to get a list of tables to populate a listbox so the end user can
select a table to repair.

Chris
Fri, Sep 26 2008 8:59 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Chris,

<< How can I get a list of all tables in a database using the ODBC driver
and DBISAM version 4? >>

You have to use direct ODBC calls if the front-end that you're using doesn't
allow for the listing of tables, etc.  What are you using for the front-end
?

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Sep 26 2008 9:11 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

I am just connecting using VS2008 using OdbcCommand and OdbcDataAdapter.

I thought I might be able to do something like connect to the supervisor
port (or a special database) and run something like:

SELECT * FROM 'Files'

Chris

Tim Young [Elevate Software] wrote:
> Chris,
>
> << How can I get a list of all tables in a database using the ODBC driver
> and DBISAM version 4? >>
>
> You have to use direct ODBC calls if the front-end that you're using doesn't
> allow for the listing of tables, etc.  What are you using for the front-end
> ?
>
Fri, Sep 26 2008 9:33 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

It okay Tim I have found it.

DataTable TableList =
MyConnection.GetSchema(OdbcMetaDataCollectionNames.Tables);


I knew I had seen it somewhere but couldn't remember where Smiley

Chris
Fri, Sep 26 2008 11:38 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Chris,

<< It okay Tim I have found it. >>

Yep, that's spot-on.  EDB allows for both, but with DBISAM you have to use
the GetSchema method only.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jan 6 2009 12:33 PMPermanent Link

Oliver Snow
Hello Tim,

I found your responses in the Elevate Software blog regarding questions about ODBC and
Elevates DBISAM product.

I am working with a client who has a product (SamStock) which apparently uses DBISAM.

I would like to know how to go about obtaining the ODBC driver to be able to import data
directly into Excel for analysis.

Would appreciate if you could get back to me

Cheers
Wed, Jan 7 2009 8:50 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Oliver,

<< I would like to know how to go about obtaining the ODBC driver to be able
to import data directly into Excel for analysis. >>

You can download a trial version of the DBISAM ODBC driver here:

http://www.elevatesoft.com/download?action=login

--
Tim Young
Elevate Software
www.elevatesoft.com

Image