Prev: is there _ANY_ way to show the row that is throwing an error in a query?
Next: SQL Server can fetch information on Install server ?
From: CAM on 25 Jul 2008 01:09
Hello,

I am a new user to SQL Server 2005. Currently I have the task in producing
a report using Crystal Report and viewing data thru ODBC to get data from
AS/400. It is a
cumbersome process, extracting the data Many times I do not need a report,
but a query or view. Is it possible to get data from
AS/400 and extract into SQL Server 2005 and even SQL Server Express 2005?
If so how? ODBC connect? Any tips will be appreciate. Thank you in
advance.

Cheers

From: Eric Isaacs on 25 Jul 2008 02:41
If you have ODBC access to the AS/400, you can likely create a linked
server from the AS/400 database to SQL Server. Here is a link to an
article that might get you started:

http://www.sqlservercentral.com/articles/Distributed+Queries/updatingas400linkedservertablesfromsqlserver/2331/

You may need to register (no cost) with sqlservercentral to view that
link.

-Eric Isaacs
From: Plamen on 25 Jul 2008 08:48
I have used with AS/400 both ODBC and OLEDB, depends on which driver
and client interface you have. Normally the AS/400 client includes the
driver. Then you can create a linked server and query the data.
However, in my
experience this can be slow with a large data set (if you directly use
it for the reports). A better approach may be to download the data to
a table in SQL Server on regular intervals (can be scheduled as job)
and then use the SQL Server table for reporting.

If for any reason you have to update data on AS/400 then journaling
has to be enabled on AS/400.

HTH,

Plamen Ratchev
http://www.SQLStudio.com
 | 
Pages: 1
Prev: is there _ANY_ way to show the row that is throwing an error in a query?
Next: SQL Server can fetch information on Install server ?