as/400 linked server

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.
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.
>
>
|||On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
recent updates.
I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
Manager i select Linked Server in Security option of the database I receive
a error like "7303 - Sql can't initialize the database provider".
Probably I made mistake in the provider string but I don't have esperience
in SQL Server.
Francesco.
|||I'm not sure what else to tell you.
As I already posted, 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. 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
There is some information on the provider string in the CA
help files. Make sure you can connect just using Client
Access as well.
-Sue
On Fri, 04 Mar 2005 21:38:43 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:

>On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
>recent updates.
>I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
>set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
>Manager i select Linked Server in Security option of the database I receive
>a error like "7303 - Sql can't initialize the database provider".
>Probably I made mistake in the provider string but I don't have esperience
>in SQL Server.
>
>Francesco.
>