CODEWITHSUNDEEP
sql-serverjdbcdb2
Rich Uchytil
Rich Uchytil

Reputation: 509

Can you create a linked server from SQL Server to DB2 using JDBC?

I'm trying to create a linked server in Sql Server 2014 to a vendors DB2 database which is on a remote system. I have found a lot of good instructions for doing this but have been not having luck getting that to work. The vendor doesn't know how to do this and has their people use Squirrel SQL with a JDBC connection. Since we need this setup pretty quick I install Squirrel and was able to get that connected and working. I would still prefer to use SSMS on our end for many reasons.

While I'm still trying to figure out the DB2 linked server, I was wondering if I can create a linked server using a JDBC connection since we have that working?

Upvotes: 0

Views: 614

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89361

can create a linked server using a JDBC connection since we have that working?

No. Linked Server requires an OleDb driver. JDBC will not work. You'll need to download the OleDb provider from the SQL Server feature pack. The latest one should work. eg: Microsoft® SQL Server® 2017 Feature Pack

Upvotes: 1

Related Questions