Bug 201120

Summary:

Data Source Explorer shows no data type for image/text columns in SQL Server 2000 database

Product:

[Tools] Data Tools

Reporter:

Mark Siegel <mark.siegel>

Component:

Enablement

Assignee:

Brian Fitzpatrick <bfitzpat>

Status:

NEW ---

QA Contact:

Severity:

normal

Priority:

CC:

ahti, bfitzpat, hjanssen, joaoReisBelo

Version:

1.5

Keywords:

helpwanted

Target Milestone:

future

Hardware:

OS:

Windows 2000

Whiteboard:

Attachments:

Description	Flags
.jpeg showing eclipse working with several sql2000 types	none

Description Mark Siegel

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

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

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

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

2010-03-08 13:32:53 EST

Created attachment 161328 [details]
.jpeg showing eclipse working with several sql2000 types