How to get Archive-Informations of Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

wg said:
I want to get Archive-Informations of Database,and I use connectionString
Click to expand...
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)
 
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

wg said:
I want to get Archive-Informations of Database,and I use connectionString
Click to expand...
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)
 
Then why are you using ODBC?
Use OleDb instead and GetOleDbSchemaTable should work just fine.
 
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
 
Back
Top