Re: Real time access to iSeries

Mbrewer.

You should be able to create a linked server to an iSeries. In fact, the
Books Online has an example of defining the link in the sp_addlinkedserver
topic.
http://technet.microsoft.com/en-us/library/ms190479.aspx

Once you have a linked server, then you can create a schedule job to do the
updates from the iSeries database into SQL Server.

For more hits, do a Technet search: "sql server" DB2 "linked server"

Also, on Technet I searched: "sql server" iseries "linked server"
http://www.experts-exchange.com/Database/DB2/Q_22592124.html

There is also a BizTalk connector, but you probably are not using that
solution: http://technet.microsoft.com/en-us/library/aa770734.aspx

RLF

"Mbrewer22" <Mbrewer22@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D26B76E1-A79C-4AE4-A4C9-F123C8B683F3@xxxxxxxxxxxxxxxx
I have a database maintained on an iSeries. I have an application that uses
MS SQL. I need to pull data down from the iSeries to my MS SQL server in
real
time or just once a week, doesn't matter. Is this easily doable and are
there
any "gotcha's" to be aware of?

Thanks!


.

Relevant Pages

  • Linked Server - DB2 - iseries
    ... I am trying to set up a linked server to our iseries through Enterprise ... Provider name: IBM DB2 UDB for iseries OLE DB Provider ...
    (microsoft.public.sqlserver.connect)
  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
  • Re: Microsoft Excell Connection
    ... Use your linked server to Access then as the source by adding a SQL Server ... You should be able to add an Access Connection to a secured Access MDB ... properties enter the location of your system database. ...
    (microsoft.public.sqlserver.dts)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 linked server problem
    ... The delegated Kerberos authentication does not work stably. ... of SQL Server 2000 to fix some known bugs on the SQL Server side. ... the both two SQL Server instances (local and linked server), ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)
Loading