RE: SQL Server Pull From Systemi

You can use an ODBC connection here. That is what we use. It really is
nothing more than a standard ODBC connection. It might make your
testing easier if you use MS Access and then you can play around with
your ODBC settings. I'm out of the office right now so I don't have
easy access to our driver settings. Although it is pretty standard
stuff - no different than you would do from your desktop.

Michael Crump

Manager, Computing Services
Saint-Gobain Containers, Inc.
1509 S. Macedonia Ave.
Muncie, IN 47302
765.741.7696
765.741.7012 f

Whoever said the pen is mightier than the sword obviously never
encountered automatic weapons!
This email and its attachments may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any views
or opinions expressed are solely those of the author and do not
necessarily represent those of Saint-Gobain. If it did, it would be
folded, mutilated, watered down, politically corrected, and would show
up a week later if at all. If you are not the intended recipient of
this email and its attachments, you must take no action based upon them,
nor must you copy or show them to anyone.
Please contact the sender if you believe you have received this email in
error.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Allen
Sent: Monday, October 08, 2007 3:55 PM
To: Midrange Systems Technical Discussion
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.............