Connection to an iSeries (AS/400) DB

Hi All,
Can someone tell me if there is a way to link an MS SQL Database to a table
on an iSeries server? There's some data I would like to read from a DB2
server, but I'm not sure how to access it through a Windows 2000 system.
Can MS SQL Server link tables like MS Access?
If not, can someone suggest how I could access the data from an ASP page?
I'm having trouble writing a DSN-less connection to a DB2 server, but I have
one to an MSSQL server. If I could link to the DB2 table, I could use my
DSN-less code for the MSSQL server.
Thanks,
Brian.
Install Client Access on the SQL Server box and then you can create a
linked server to the AS400. Linked servers are a bit similar to linked
tables in that they allow you access to an external data source. You
don't access them as if they are local tables as you can with linked
tables in Access. You can find more information on linked servers in
books online.
When configuring the linked server, 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 but the above info should help get you
going.
-Sue
On Wed, 6 Oct 2004 12:42:08 -0400, "Brian Piotrowski"
<bpiotrowski@.NOSPAM.simcoeparts.com> wrote:

>Hi All,
>Can someone tell me if there is a way to link an MS SQL Database to a table
>on an iSeries server? There's some data I would like to read from a DB2
>server, but I'm not sure how to access it through a Windows 2000 system.
>Can MS SQL Server link tables like MS Access?
>If not, can someone suggest how I could access the data from an ASP page?
>I'm having trouble writing a DSN-less connection to a DB2 server, but I have
>one to an MSSQL server. If I could link to the DB2 table, I could use my
>DSN-less code for the MSSQL server.
>Thanks,
>Brian.
>