Link tables to AS400

[tman24m]

I'm trying to find out if it's possible to link external data sources to the AS400. I have successfully linked tables from the AS400 to SQL and Access but would like to go the other way now. Anyone know if this is possible and how to?

Thanks
T-Man

 

[ecobb]

I know you can set up a Linked Server to an AS400 on SQL Server, and I think you can link Access through and ODBC connection.

Here's some web sites that may help with SQL Server. You can also look up "Linked Server" in SQL Server's Books Online and there should be a "how to".

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/prsql_6gqa.asp

http://www.databasejournal.com/features/mssql/article.php/1756161

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_1gvm.asp

Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson

 

[leveyp]

Create an ODBC connection using i-series Access for Windows ODBC Setup. On the Server tab click Advanced. Set the commit mode to Commit immediate (*NONE)

 

[tman24m]

Looking to have the data reside in SQL and just a linked file on the AS400 side.