Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 7 of 7 total |
Getting Tables From Database Using ODBC |
Fri, Sep 26 2008 5:33 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 Chris |
Fri, Sep 26 2008 11:38 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |