Link to home
Start Free TrialLog in
Avatar of qbjgqbjg
qbjgqbjgFlag for United States of America

asked on

adding Linked server for AS400

I am trying to add a linked server for our AS400 to use with SQL 2005. So far I have not been sucessful. I am attaching what I entered and the error I received. Any help will be greatly appreciated. as400-Linked-Server-error.docx
Avatar of Norman Maina
Norman Maina
Flag of Kenya image

Avatar of qbjgqbjg

ASKER

I did not find anything there that helps. I am trying to fill out the screen correctly.
Did you check to see if the "allow in process" has been checked?
What screen is that on?
I use SQL 2008 so it may be the same

Using Management Studio,
expand linked servers,
expand providers
right click on your provider,
check Allow inprocess

Hope this helps...
It is already checked.
Is there an easy way to get the correct provider string?
ASKER CERTIFIED SOLUTION
Avatar of MeLindaJohnson
MeLindaJohnson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I was finally sucessful. I am attaching a document with what I did. Thanks for all of your help. It was trial and error until I got it working (along with help from google).
Setting-up-Linked-server-to-AS40.docx
See also my notes on how the linked server was sucessfully created on our system.
Thanks for your help.