Re: as/400 linked server
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/01/05
- Next message: Scott McDonald: "Communications link failure #0"
- Previous message: Kevin McDonnell [MSFT]: "RE: SSL Security error -ConnectionOpen(SECDoClientHandshake)"
- In reply to: Francesco Trigiante: "as/400 linked server"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Feb 2005 19:03:04 -0700
First you need to have the drivers, providers for the AS400
installed on the SQL Server box.
If you install Client Access on the server, it will install
and configure the drivers and providers for the AS400 on the
SQL Server box so that you can use linked servers. You
should also make sure you have the client updated with what
whatever service pack level based on updates to the AS400.
For data source, use the IP address of the AS400. For
provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access
help files. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
The logical or physical file you are accessing is what you
would reference as the table in your query against the
linked server.
-Sue
On Mon, 28 Feb 2005 21:38:36 GMT, "Francesco Trigiante"
<ftrigiante@libero.it> wrote:
>Hi everybody,
>
>I have a problem in SQL Server 2000. I need to connect as a linked server
>the AS400 database (V5R3).
>I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
>procedure and the linked server from SQL Manager but I'm not to be able to
>have success using its.
>
>The book's online of SQL Server sp3 is not very clear for me.
>
>server name : s112233a
>library : sales
>object/file : order
>member(optional) : orderFY05
>
>Could you help me, please?
>Thanks, Francesco.
>
>
>
- Next message: Scott McDonald: "Communications link failure #0"
- Previous message: Kevin McDonnell [MSFT]: "RE: SSL Security error -ConnectionOpen(SECDoClientHandshake)"
- In reply to: Francesco Trigiante: "as/400 linked server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
