?
Solved

adding Linked server for AS400

Posted on 2010-08-16
10
Medium Priority
?
421 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:qbjgqbjg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
10 Comments
 

Author Comment

by:qbjgqbjg
ID: 33449170
I did not find anything there that helps. I am trying to fill out the screen correctly.
0
 
LVL 4

Expert Comment

by:MeLindaJohnson
ID: 33450441
Did you check to see if the "allow in process" has been checked?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:qbjgqbjg
ID: 33456233
What screen is that on?
0
 
LVL 4

Expert Comment

by:MeLindaJohnson
ID: 33456270
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...
0
 

Author Comment

by:qbjgqbjg
ID: 33456330
It is already checked.
0
 

Author Comment

by:qbjgqbjg
ID: 33457132
Is there an easy way to get the correct provider string?
0
 
LVL 4

Accepted Solution

by:
MeLindaJohnson earned 2000 total points
ID: 33457354
0
 

Author Comment

by:qbjgqbjg
ID: 33466857
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
0
 

Author Closing Comment

by:qbjgqbjg
ID: 33466967
See also my notes on how the linked server was sucessfully created on our system.
Thanks for your help.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question