Access AS/400 from SQLServer v7

[LokiDba]

Is it possible (and how would you do it) to access data on AS/400 through SQLServer ie using MSDTC etc.

Thanks in advance

LokiDBA

 

[cdukes]

There are ODBC drivers available for AS/400's therefore you can install an ODBC driver on your SQL Server and set it up to talk to your AS/400. You should then be able to use the ODBC datasource to copy data from and to the AS/400.

Swoodring appears to be working with SqlServer and an AS/400.

Hope this helps,

Chris Dukes

 

[TomSark]

Yes, I do this frequently. I use the Client Access Express ODBC driver to get data from the 400 in DTS.

You can also use OLE DB Providers to access the 400 as well, but I recommend that you have SNA or Host Integration Server if you use OLE DB.

Also, you can set up linked servers as well, but these are incredibly slow when compared to the ODBC drivers to get to the data via DTS. So... install Client Access Express on the SQL Server, then reference the Client Access Express driver as a connection in your package. Then you will be able to manipulate data from the 400 in DTS... Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[LokiDba]

Thanks very much for the help

LokiDBA

 

[Guest_imported]

Tom,
I am also using the client access ODBC driver(32-bit) to get data from AS/400 to the SQL Server. I have created a package to do this and have scheduled it. The job owner is a domain account and the same account is used to start the SQL Server and SQLAgent services. It is memeberof the sysadmin role.
I am able to execute the package interactively but I get error if I try this from the job.

Any help will be greatly appreciated.

Regards
Mohit

 

[SpeedOLight]

Mohit,

One thing to consider...the ODBC driver and the DSN need to exist on the server where SQL Server is installed.

Regards...Marc
Independent Software Consultant