qbjgqbjg
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
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?
ASKER
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...
Using Management Studio,
expand linked servers,
expand providers
right click on your provider,
check Allow inprocess
Hope this helps...
ASKER
It is already checked.
ASKER
Is there an easy way to get the correct provider string?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Setting-up-Linked-server-to-AS40.docx
ASKER
See also my notes on how the linked server was sucessfully created on our system.
Thanks for your help.
Thanks for your help.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his_2004Main/htm/_sna_distributed_query_support_using_the_ole_db_provider_for_db2_oledb.asp