Avatar of Bondcote
Bondcote asked on

SQl Server 2005 Express to AS/400 DB2 Problem


We had a server crash earlier in the month.  The server hosted a customized intranet that was linked to a SQL server.  The SQL server was also linked to our AS/400 i-Series server.  I can't figure out how to re establish the connection between the SQL and AS400.  I can ping the AS400, log into through client access, and test a UDL connection... BUT SQL will not see it.  I've also tried Linked Server in SQL with out success.  

I'm sure it's either the DSN config, Linked Server values, or a SQL config...  Need some help!

I would need details because I'm a network guy than a programmer...  


Operating SystemsDB2Mainframe OS

Avatar of undefined
Last Comment

8/22/2022 - Mon
Kent Olsen

Hi Bondcote,

The box that is running SQL will need to have the DB2 client, ODBC, or JDBC driver installed.

Good Luck,

Kdo, thank you for your comment...

I've downloaded the lastest DB2 client from IBM but I have no idea how to set it up?  Would you know how too?

Kent Olsen

The setup process should be pretty straight forward.  Just follow the on-screen instructions.

Here's the IBM installation instructions.  (It doesn't say much.)  :(


This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question