Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO, OpenSchema and Column Descriptions

Status
Not open for further replies.
Gila47ac

Gila47ac

Programmer
Oct 11, 2002
30
US
Hi,

I'm using the ADO OpenSchema method to retrieve information about the SQL Server database. I successfully get table names, column names and data types, primary keys... But I can't seem to get the Description for the columns. The recordset contains a Field object named DESCRIPTION, but that field Value contains Null even for columns that really do have text in their Description.

Suggestions?

DBMS = SQL Server 2000
Provider = SQLOLEDB.1 (if I recall correctly)
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
SORT msflexgrid column 1 with decimal number 1
Replies
4
Views
577
2009luca
2009luca
sal21
  • Locked
  • Question
loopimg link and downlosd zip file 1
Replies
3
Views
331
strongm
strongm
wires
  • Locked
  • Question
Install VB6 IDE and Access97 on W11 ARM version 1
Replies
3
Views
606
Gabor526
G
sal21
  • Locked
  • Question
API REST get zip cod efrom street name and city
Replies
1
Views
285
strongm
strongm
Ken01
  • Locked
  • Question
Areas under graphs and overlap areas between circles. 2
Replies
3
Views
848
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top