I am writing a program that will read a unknown database of unknown Table 

Name. Is there any possible way that i can retrieve all the table names in 

the database? Fields name is need also.

Look into using ADOX ... it will do what you need.



-- Tomm



> -----Original Message-----

> From: yinmos [mailto:yinmos@y...]

> Sent: Monday, September 24, 2001 7:03 PM

> To: ActiveX_Data_Objects

> Subject: [activex_data_objects] How to retrieve the TABLE NAME of the

> database I am reading?

>

>

> I am writing a program that will read a unknown database of unknown Table

> Name. Is there any possible way that i can retrieve all the table

> names in the database? Fields name is need also.

Here is just a snippet of code to peruse...



        // Instantiate connection interface object

        SAFE_CALL(pConnection.CreateInstance(__uuidof(Connection)));



        // Instantiate recordset interface object

        SAFE_CALL(pRstSchema.CreateInstance(__uuidof(Recordset)));



        // Clear errors collection for connection object

        SAFE_CALL(pConnection->Errors->Clear());



        // Open database schema to establish content before accessing

individual tables and rows

        TRACE0((LPSTR)bstrconnectstring);

        TRACE0("\n");



 

SAFE_CALL(pConnection->Open(bstrconnectstring,"","",adConnectUnspecified));



        // Open schema to query for table names

        pRstSchema = pConnection->OpenSchema(adSchemaTables);



        // Retreive MDAC Version Information for registry

        variant_t vtVersion = (bstr_t)pConnection->Version;



        bstr_t bstrProviderVersion = bstr_t(vtVersion);



        cProviderVersion = (LPCWSTR)bstrProviderVersion;



        table_count = 0;



        // Get names of tables...

        while(!(pRstSchema->EndOfFile))

        {

            // Get table name

            bstrTablename 

(bstr_t(pRstSchema->Fields->GetItem("TABLE_NAME")->Value));



            // Get table type

            bstrTabletype 

(bstr_t(pRstSchema->Fields->GetItem("TABLE_TYPE")->Value));



            // Only store "TABLE" fields for data extraction

            if(_stricmp(_strupr((LPSTR)bstrTabletype),"TABLE") == 0)



                Do something...



            }   // if(_stricmp(_strupr((LPSTR)bstrTabletype),"TABLE") == 0)



            // Advance to next field

            if(!(pRstSchema->EndOfFile))

                pRstSchema->MoveNext();

        };/*while(){}*/

etc...



-----Original Message-----

From: yinmos [mailto:yinmos@y...]

Sent: Monday, September 24, 2001 3:03 PM

To: ActiveX_Data_Objects

Subject: [activex_data_objects] How to retrieve the TABLE NAME of the

database I am reading?





I am writing a program that will read a unknown database of unknown Table 

Name. Is there any possible way that i can retrieve all the table names in 

the database? Fields name is need also.

Here's a recent article that goes along with Thomas Bellavia's code

snippets...



VB Q&A - Much "ADO" about field properties 

http://www.techrepublic.com/article.jhtml?id=r00820010813adm01.htm&fromtm=e0

46



Thanks,

Jeff M. Belina

MCP, MCSD, MCDBA, MCSE, MSS, i-Net+

Database Administrator, DDBA

Moderator of the MCDBA Discussion List

http://ls.swynk.com





-----Original Message-----



> From: yinmos [mailto:yinmos@y...]

> Sent: Monday, September 24, 2001 7:03 PM

> To: ActiveX_Data_Objects

> Subject: [activex_data_objects] How to retrieve the TABLE NAME of the

> database I am reading?

>

>

> I am writing a program that will read a unknown database of unknown Table

> Name. Is there any possible way that i can retrieve all the table

> names in the database? Fields name is need also.