Runtime functionality information

  • Thread starter Thread starter Edward Diener
  • Start date Start date
E

Edward Diener

In ODBC the SQLGetInfo function retrieves information about a driver and a
data source. In OLEDB the OLE DB Properties return such information. What is
the equivalent functionality in ADO .NET.
 
Hello Edward,

Although the ODBC API provides a means for drivers to return database
catalog info rmation in a database independent manner using SQLGetInfo,
this function is not encapsulated in the API. This means that users must
resort to database dependent methods, such as SQL Server's
INFORMATION_SCHEMA views, to get metadata.

Hope this helps you solve your problem.

Regards,
Rami Saad
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC
 
"Rami Saad" said:
Hello Edward,

Although the ODBC API provides a means for drivers to return database
catalog info rmation in a database independent manner using SQLGetInfo,
this function is not encapsulated in the API. This means that users must
resort to database dependent methods, such as SQL Server's
INFORMATION_SCHEMA views, to get metadata.

Hope this helps you solve your problem.
Click to expand...

It does not solve the problem because I do not know until run-time what
particular RDBMS will be chosen, and I can not know every database's schema
methodology to get information I may want. Unfortunately ADO .NET supports
neither Odbc's SQLGetInfo in its Odbc classes nor OleDb's database
properties in its OleDb classes. Therefore, for a great deal of provider
information, there is no generic way to get that information automatically
at run-time.
 
Back
Top