We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How to use Microsoft OLEDB Provider for DB2

Medium Priority
428 Views
Last Modified: 2012-05-07
Hi,

We are using Microsoft OLEDB provider for DB2 2.0 for connecting to a DB2 server from SQL Server. When I try to configure a data source using Data Access tool (installed when Microsoft OLEDB Provider for DB2 2.0 is installed), it is asking for a datasource platform. The options here include DB2/MVS, DB2/400,  DB2/NT and DB2/6000. Which one we need to use to just connect to a DB2 server? Can somebody tell me how to use Microsoft OLEDB provider for DB2 by giving an example how to create a datasource?
Comment
Watch Question

SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.