How to get Archive-Informations of Database

[Guest]

I want to get Archive-Informations of Database,and I use connectionString from Data Link Properties Dialog.I know one Method(OleDbConnection.GetOleDbSchemaTable),but it only functions for Microsoft Jet 4.0 OLE DB Provider,if i want to connect a database with Microsoft OLE DB Provider for ODBC Drivers,then it doesn't work.There is a error,too:" OLE DB of .Net Framework doesn't support ODBC Drivers,please use ODBC of .Net Framework "How can I do,if I want to get Archive-Informations of database with ODBC or another provider(No Microsoft Jet 4.0 OLE DB Provider)
..
Thank you very much!

wg
1.1.2004

 

[Miha Markic]

Hi,

You'll have to resort to database specific sql stataments to retrieve the
information...

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I want to get Archive-Informations of Database,and I use connectionString

from Data Link Properties Dialog.I know one
Method(OleDbConnection.GetOleDbSchemaTable),but it only functions for
Microsoft Jet 4.0 OLE DB Provider,if i want to connect a database with
Microsoft OLE DB Provider for ODBC Drivers,then it doesn't work.There is a
error,too:" OLE DB of .Net Framework doesn't support ODBC Drivers,please use
ODBC of .Net Framework "How can I do,if I want to get Archive-Informations
of database with ODBC or another provider(No Microsoft Jet 4.0 OLE DB
Provider)

 

[Guest]

Could you tell me detail?

----- Miha Markic wrote: -----

Hi,

You'll have to resort to database specific sql stataments to retrieve the
information...

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I want to get Archive-Informations of Database,and I use connectionString

from Data Link Properties Dialog.I know one
Method(OleDbConnection.GetOleDbSchemaTable),but it only functions for
Microsoft Jet 4.0 OLE DB Provider,if i want to connect a database with
Microsoft OLE DB Provider for ODBC Drivers,then it doesn't work.There is a
error,too:" OLE DB of .Net Framework doesn't support ODBC Drivers,please use
ODBC of .Net Framework "How can I do,if I want to get Archive-Informations
of database with ODBC or another provider(No Microsoft Jet 4.0 OLE DB
Provider)

 

[Miha Markic]

Hi,

Which database are you using?

 

[Guest]

Access

----- Miha Markic wrote: -----

Hi,

Which database are you using?

 

[Miha Markic]

Then why are you using ODBC?
Use OleDb instead and GetOleDbSchemaTable should work just fine.

 

[Guest]

Yes,I know,but I want to use ODBC,and if I use dBase or another Database,how can I do?Thanks

----- Miha Markic wrote: ----

Then why are you using ODBC
Use OleDb instead and GetOleDbSchemaTable should work just fine