Home > IT Answers > SQL Server > Accessing SQL Server data
As400guyone
0 pts.
 Accessing SQL Server data
SQL Server
I need to access data on an SQL server from our AS/400. I need something quick and cheap. Help!

Software/Hardware used:
ASKED: January 18, 2005  5:50 PM
UPDATED: January 19, 2005  7:51 AM
RELATED QUESTIONS
Answer Wiki:
Download a JDBC from sourceforge, and complie the code. Project Name: jTDS
Last Wiki Answer Submitted:  January 19, 2005  3:05 am  by  Demarks   0 pts.
All Answer Wiki Contributors:  Demarks   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Install the iseries client on the server and create a linked server to the AS/400. You can use the store procedure sp_addlinkedserver to create your linked server

sp_addlinkedserver
@server = ‘linked server name’,
@srvproduct = ‘linked server name’,
@provider = ‘IBMDA400′,
@datasrc = ‘IP address of your AS/400′,
@provstr = ‘catalog library list=library names’,
@catalog = ‘database name’

To access your data:
SELECT * FROM linked server name.database name.owner name.object name

swede27410
 0 pts.