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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot display ODBC login prompt - want to connect without DSN 31
Retrieving Schema info for connection 1
How to connect a remove SQLServer 2005 with instance name 2
Accessing ODBC DSNs 1
Getting FK->PK relationships 2
drop column via ODBC with "active relation" 3
Odbc fails with parameters 3
ADO.NET forces unload ODBC Driver 1

Back
Top