how to get information of unique constriantant form ODBC

  • Thread starter Thread starter jtz
  • Start date Start date
J

jtz

With ADO I can get such information from access or sqlserver,but it doesn't
work on ODBC,what is right way for ODBC?
 
The ODBC interface is very generic. It's designed to give you (very) basic
query and rowset retrieval capability and not much else. This is because
each DBMS has a unique way to expose its schema (catalog). You will need to
determine if the DBMS has specific commands that can be sent as a query to
extract this information. Unless you use a native provider, ADO.NET can't
help.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Back
Top