In my current pursue of integrating both our DBMS tecnologies (DB2 LUW and MS-SQL 2008), I was trying to connect to a MS-SQL 2008 database.
When I try the connection, I get an error box with the following message:
'Version 8 of SQL Server is not compatible with this driver'
I downloaded this sqljdbc4.jar from Microsoft's download site....and I was wondering if it is the correct version....
Any hints would be greatly appreciated...
Buenos Aires - ARGENTINA
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic Data Studio V3.2 - Error connecting to a MS-SQL 2008 Source
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-06T17:34:39Z at 2013-02-06T17:34:39Z by SystemAdmin
SystemAdmin 110000D4XK1632 Posts
Re: Data Studio V3.2 - Error connecting to a MS-SQL 2008 Source2013-02-06T17:34:39ZThis is the accepted answer. This is the accepted answer.Hi all:
Finally I found what I was doing wrong....
I was told that I was connecting to a MSSQL Server 2008....and it was actually a MSSQL Server 2000....
I got the correct drivers, and I was finally able to connect to it....or sort of...
Now I'm getting error with my userid. I don't know what's the problem since I can connect and perform admin tasks thru the native SQL Server Management Studio tool using the windows domain userid....
Well....if this rings any bell, your help would be greatly appreciated !!