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

Question

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?

David Browne - Microsoft · Accepted Answer · 2019-06-17 15:29:25Z

1

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

answered Jun 17, 2019 at 15:29

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rich Uchytil Over a year ago

Well bummer, but thanks. I've got the stuff from that link, back to working on it. :)

mustaccio Over a year ago

You may want to consider using the IBM provider in the Data Server Driver Package for the appropriate server version.

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related