troubleshooting Question

How do I create an AS400 linked server?

Avatar of superthumper
superthumper asked on
DB2Microsoft SQL Server 2005
10 Comments1 Solution983 ViewsLast Modified:
I'm trying to create an AS400 linked server on SQL2005.  I have Microsoft's  DB2OLEDB provider installed.
I know how to create a linked server in SQL 2005, i just need to know what to fill in for the parameters when creating the AS400 linked server.

Product Name: ? (no idea)
Data Source: ? (the AS400 server name?)
Provider String: ? (this one I have no clue....)
Catalog: ? (the database name?)

  There's an old question on EE, but the link in the solution is dead.  Has anyone done this and can help?  Thanks.

Any help on the login portion would be very valuable as well

I'm marking this urgent as my client needs me to move 5 tables yesterday :)
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros