Community
Participate
Working Groups
Created attachment 85928 [details] screenshot Build ID: M20071023-1652 Steps To Reproduce: 1. create a connection profile to SQL 2000 2. connect 3. no schema displayed in Data Source Explorer More information: I am using Eclipse Version: 3.3.1.1 J2EE version with all the latest updates (including the latest DTP, EMF, and GEF). I am not able to get the schema information in Data Source Explorer for a SQL 2000 database. Note: SQL 2000 does not define schemas, rather table reside under "dbo" (default schema).
Is this a problem in all of your catalogs or just the one referenced in the screenshot? Assigning this to DTP group for further investigation.
Please check your eclipse\features directory for: * org.eclipse.datatools.enablement.msft.feature if present, let us know the version/date stamp appended on that feature (the part after _) Also, you'll want to look in eclipse\plugins for: org.eclipse.datatools.enablement.msft.* plug-ins. Depending on your DTP version, there would be either 2 or 3 of these. Again, please let us know the version/date stamp for these plug-ins. AFAIK, MSFT SQL Server 2000 should display tables and columns at least.
Hey Neil... Quick question... The fact that there are no schemas appearing in the DSE may be symptomatic of one of two things... If the databaseName is not specified in the JDBC URL, I've seen this occur. And if that's the case, user names seem to have a default catalog associated with them and if the default isn't set to the catalog you're looking for, you won't see any schemas for that catalog.
Sorry for the delayed reply and thanks for the help. Attached are more screenshoot with with connection info and eclipse configurations. 1. all the schemas have the same issue. 2. the user has been set as dbo for all schemas. 3. the Northwind database was set as the user's default schema.
Created attachment 87957 [details] connection configuration 1
Created attachment 87958 [details] connection configuration 2
Created attachment 87959 [details] eclipse config 1
Created attachment 87960 [details] eclipse config 2
After looking more closely at your driver configuration, it appears you're not using the MSSQL driver from Microsoft, which is probably the root of the problem. Can you try it with Microsoft's driver and also provide a link to where I can get the other driver you're using?
(In reply to comment #9) Brian, I am using the JTDS drivers: http://jtds.sourceforge.net/ I do have the DataDirect drivers for MS SQL 2000. Or do you need me to test with the MS SQL Server 2005 JDBC Driver 1.2? Or both? I will make another test this coming weekend. Thanks.
I think this a dupe of bug 208776 which also concerns jTDS on SQL Server 2000. It was fixed in 1.5.2 and 1.6 (M4 ot M5 I think), so if you are still on 1.5.1 that could be the explanation.
I just tested with the latest Ganymede (1.6) codeline and jTDS and I get all the bells and whistles to show up in the DSE. Can you try it with 1.5.2 and 1.6 when you get a chance, like Jesper suggested?
Has anyone had a chance to try this with the 1.6 version of DTP (Ganymede release)?