Bug 201120 - Data Source Explorer shows no data type for image/text columns in SQL Server 2000 database
Summary: Data Source Explorer shows no data type for image/text columns in SQL Server ...
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: Enablement (show other bugs)
Version: 1.5   Edit
Hardware: PC Windows 2000
: P3 normal (vote)
Target Milestone: future   Edit
Assignee: Brian Fitzpatrick CLA
QA Contact:
URL:
Whiteboard:
Keywords: helpwanted
Depends on:
Blocks:
 
Reported: 2007-08-24 14:47 EDT by Mark Siegel CLA
Modified: 2010-03-08 13:32 EST (History)
4 users (show)

See Also:

Attachments
.jpeg showing eclipse working with several sql2000 types (131.81 KB, image/jpeg)
2010-03-08 13:32 EST, jmmrb CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Siegel CLA 2007-08-24 14:47:46 EDT 
Build ID: I20070621-1340

Steps To Reproduce:
Connect to a SQL Server 2000 database using Data Source Explorer and navigate to a table that has an image or text column.  Notice that the column has no type information.

Using the APIs as well, you can see that Column.getDataType () returns null.


More information:
Using Database Explorer in WTP in Eclipse 3.2, these columns have correct type information.
Comment 1 Brian Fitzpatrick CLA 2007-08-24 17:54:26 EDT 
This is most likely a catalog loader issue where the driver & default metadata returned from the database isn't providing that info -- so we'll have to customize the catalog loader to pick it up, which we should be able to do.
Comment 2 Brian Fitzpatrick CLA 2008-01-08 12:25:09 EST 
Hey John...

This is an enablement bug that should be looked at and be added to the "Help Wanted" section...

--Fitz
Comment 3 jmmrb CLA 2010-03-08 13:29:16 EST 
Works for me in with dtp:
Version: 1.7.0.v200908280400-XXXX
Build id: 1.7.1.v20090904-0500
It only has problems with user defined data types.
Comment 4 jmmrb CLA 2010-03-08 13:32:53 EST 
Created attachment 161328 [details]
.jpeg showing eclipse working with several sql2000 types