Re: SQL Server Pull From Systemi

Thanks all, I'll pass these on to him, but he figured it out (or I should
say we...he still can't related librarys to schemas, table to files, LF's to
views, records to rows, fields to columns) but we got a test replicate
done. Now to rebuild all the missing pieces as soon as we figure out what
the logic should be... (don't ask, I am going to try and move this to access
the i5 directly and not this replicated, hope the SQl server doesn't reboot,
hope the kron jobs don;t hang stuff

On 10/8/07, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Mark, perhaps you and your SQL guy can spend that hour watching this
webcast:

http://www.systemiportal.com/events/view_entry.php?id=262&cat_id=4

It should help you connect the dots between SQL Server and i5/OS.

Elvis

Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
October 16
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i,
eServer
iSeries and the server affectionately known as the AS/400

-----Original Message-----
Subject: SQL Server Pull From Systemi

One of the "pieces" we lost in last weeks SQL Server crash was a number of
stored procedures that in essence were set as kron jobs that did the
following:

Delete all records from FILEA on SQL Server
Import all records from FILEA on Systemi to FILEA on SQL Server

Our SQL guy is having problems getting the SQL server to even see the
Systemi or any files to begin doing the critical ones manually.

I know he needs to set up some kind of OLEDB or ODBC connection, but
other
than that I am clueless and he's been pounding the keyboard all day just
tryign different things, googling etc without much success. Can someone
point me in the right direction to point him.

I can last about an hr with him before we both get frustrated.............

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.