Community
Participate
Working Groups
Software Details. Data Tools Plataform Enablement for Microssoft Identifier: org.eclipse.datatools.enablement.msft.feature Version: 1.5.1.200709261 I´m having problems using the version 1.5.1 of the DTP. When I connect to Microsoft SQL Server 2005, using the newer JDB Driver from microssoft, I cant see my Stored Procedures in "Data Explorer". In the previous Version, 1.5.0, when I use the same Driver from MSSQLServer 2005 I can see some stored procedures, not all, but some... Now, with this recent version of DTP I can see nothing. This is a poblem in Microsoft Driver? the plataform changed and not suport the MS Stored Procedures?
Interesting. Are you trying to connect to SQL Server 2000 or 2005? Which versions of JDBC drivers are you using, etc... Just trying to get more info so I can take a look at this after I get back from EclipseCon next week. Have you tried 1.5.2, which was just released not too long ago? --Fitz
Hi Fitz... I have updated my DTP to version 1.5.2 and now I'm using it. Data Tools Plataform 1.5.2 Data Tools Plataform Enablement for Microssoft 1.5.2 I am using the SQL Server 2005 and the lastest JDBC Driver from Microssoft. Thanks for the attention... And I am awaiting for a solution.. thanks a lot!
What does your URL look like when you connect?
Created attachment 93458 [details] Screenshot from my Eclipse Data Source Explorer
(In reply to comment #3) > What does your URL look like when you connect? > Well... its something like that jdbc:sqlserver://10.10.1.90:1433 I have tried to use: jdbc:sqlserver://10.10.1.90:1433;databaseName=MY_DATABASE_NAME My driver class is the following: com.microsoft.sqlserver.jdbc.SQLServerDriver and the jar file's name is: sqljdbc.jar When I am connected with the DB the following String appears in the Data Source Explorer ( Microsft SQL Server v. 9.0.1406 ) * take a look in the attachment to see what about I'm talking
Dumb question. (I just downloaded the latest SQL Server 2005 driver to play with it here.) When you specify the URL with "MY_DATABASE_NAME" did you set the Database field to be "MY_DATABASE_NAME" also? I've seen some issues where if those two don't match up, that you can't see certain things.
Created attachment 93472 [details] Configuration Screen 1
Created attachment 93473 [details] Configuration Screen 2
(In reply to comment #6) > Dumb question. (I just downloaded the latest SQL Server 2005 driver to play > with it here.) When you specify the URL with "MY_DATABASE_NAME" did you set the > Database field to be "MY_DATABASE_NAME" also? I've seen some issues where if > those two don't match up, that you can't see certain things. > Well, I posted 2 new screens from my eclipse. In this screens you can see my configurations, like "connection string" and more. When I write my connection string, the another field is not filled automatic (it could be a nice improvement hehehe), but I have typed it manually to test, and still not working.
Created attachment 93476 [details] My 1.5.2 SQL Server 2005 Config (That works) Very odd. I'm attaching a picture of my own 1.5.2 configuration for MS SQL 2005 using the latest MS driver and it works fine. The only things I can think of is that the user name doesn't have permissions for that database, or that there's a bug somewhere on Mac that we haven't found yet. I don't have a Mac available for testing to verify the issue. Do you get anything in the log or console? --Fitz
(In reply to comment #10) > Created an attachment (id=93476) [details] > My 1.5.2 SQL Server 2005 Config (That works) > > Very odd. I'm attaching a picture of my own 1.5.2 configuration for MS SQL 2005 > using the latest MS driver and it works fine. > > The only things I can think of is that the user name doesn't have permissions > for that database, or that there's a bug somewhere on Mac that we haven't found > yet. I don't have a Mac available for testing to verify the issue. > > Do you get anything in the log or console? > > --Fitz > Well... I have found something strage here... Take a look: 25/Mar/2008 16:18:30 com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit> WARNING: Failed to load the sqljdbc_auth.dll Maybe its the problem? Do you know what is this message?? (well.. I know that it means the JDBC Driver does not found the .dll file, but... where is this dll? it come with the driver? I havent seen that .dll file)
Ugh. Well, that would do it. I have seen that before. If you run the windows installer for the driver, it gets installed. It looks like you may have issues with using a Windows JDBC driver. I've heard rumors of other SQL Server drivers, but can't say that I've played with any beyond DataDirect, and that was a long time ago. And DTP may have issues with other drivers.
(In reply to comment #12) > Ugh. Well, that would do it. I have seen that before. If you run the windows > installer for the driver, it gets installed. It looks like you may have issues > with using a Windows JDBC driver. > > I've heard rumors of other SQL Server drivers, but can't say that I've played > with any beyond DataDirect, and that was a long time ago. And DTP may have > issues with other drivers. > Well... I will try to test in a window plataform... and report to you what happened. Other thing: Im using Adobe Flex Builder, but it running in the lastest eclipse build... so.. I does not think it could make some difference... Now I will try to download the installer to the windows plataform.
It's hard to tell. I can't say I have much Mac experience, sorry. But please keep me posted and we'll see what we can do for you.
(In reply to comment #14) > It's hard to tell. I can't say I have much Mac experience, sorry. But please > keep me posted and we'll see what we can do for you. > Well... I found a open source driver... http://jtds.sourceforge.net/ that could get connected with SQLServer. They show-me the procedures... but.. I cant see the parameters neither the content... it become useless for me... anyway.. i will try to find some commercial drivers that could help-me.... Thanks for the help!
Looks like a duplicate of bug 217321.
The parameter/content may be a limitation of support in DTP for MS SQL Server. We have limited resources for the enablement plug-ins to get things working with all the various issues. I will try and take a look at the jtds driver to see if I can determine a way to get it to populate the parameters & content, but can't make any promises. Help with this code is always greatly appreciated.
work's fine in DTP 1.6.1
Thanks for testing. We will have some additional SQL Server support in Galileo, but not before.
