I am trying to evaluate if Data Studio would be useful with SQL Server. When I try and connect I get the following message:
"The driver class was not found in the specified driver JAR/Zip file. Please update the jar list in the driver definition."
It is not clear to me what needs to be done. I updated the classpath to pint to the sqljdbc.jar. What other actions should be taken?
Data Studio Administrator V2.1
MS SQL Server 2005
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
5 replies Latest Post - 2013-02-05T10:27:48Z by SystemAdmin
Pinned topic SQL Server Driver Connect Error
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-05T10:27:48Z at 2013-02-05T10:27:48Z by SystemAdmin
Re: SQL Server Driver Connect Error2009-03-02T20:56:16Z in response to BenEisensteinI will answer my own question.
If you go under:
Windows-->Preferences-->Data Management-->Connectivity-->Driver Definitions
Click on the SQL Server driver option corresponding to your driver and edit.
Click on the jar tab. Then edit the full path to the jar.
Good luck finding it!
Kevin_Foster 120000GMHC52 PostsACCEPTED ANSWER
Re: SQL Server Driver Connect Error2009-03-03T16:52:29Z in response to BenEisensteinJust a reminder that the Data Studio Administrator product does not support SQL Server. Some amount of functionality might work based on common Eclipse features, but the majority of the features won't work as the product only supports DB2 for LUW at this time.
For a related product that does officially support SQL Server, you might want to check out InfoSphere Data Architect. There's a 30-day trial of the software available from the product web page:
Re: SQL Server Driver Connect Error2009-03-09T14:30:08Z in response to Kevin_FosterWe are a multiplatform shop, and of course looking for the quixotic goal of one tool for all platforms. So we curious to see what is in Data Studion for SQL Server.
What we saw in Data Studio is quite encouraging:
Gui alter of table just like you can do in SSMS, cool !!!!!
Able to generate DDL from objects.
Actually the major problem that would keep us from recommending it to non-DBAs like developers, users and testers, is that Windows Authentication does not work. Even though there is an option for it, we get an error.
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: SQL Server Driver Connect Error2013-02-05T10:27:48Z in response to BenEisensteinHi Ben:
I'm looking at your post and I happen to be in the same spot with similar needs. Most of our DBs are either DB2 for LUW or MSSQL.
I'm having trouble connecting to our MSSQL servers. Would you be so kind as to directe me with the steps that you followed to set up this connection?
Your help would be greatly appreciated !!