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
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:16ZThis is the accepted answer. This is the accepted answer.I 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 Posts
Re: SQL Server Driver Connect Error2009-03-03T16:52:29ZThis is the accepted answer. This is the accepted answer.Just 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:08ZThis is the accepted answer. This is the accepted answer.
- Kevin_Foster 120000GMHC
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 Posts
Re: SQL Server Driver Connect Error2013-02-05T10:27:48ZThis is the accepted answer. This is the accepted answer.
- BenEisenstein 270001FK1W
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 !!