Creating a Linked Server to AS400.

Yes, you can link to an As400 server using an odbc connection. First you must get a trusted third party odbc component. I suggest looking at the following site www.merant.com they have some of the best odbc engines. You can use the following code as a sample on how to run queries against an attached server:
This query is used against an index server that I have linked to in SQL 2000.
--- sp_addlinkedserver testIndex,'Index','MSIDXS','te stBHG'
SELECT *

FROM OPENQUERY(testIndex,

'SELECT Directory,

FileName,

DocAuthor,

Size,

Create,

Write

FROM SCOPE('' "c:hg" '')

WHERE
freetext(''meeting or xsystem and ebiz'')

')
order by docauthor,FILENAME

------------
GMK at 3/15/01 9:50:24 AM

I wanted to know whether it is possible to query a database in AS400 server from MS SQL Server 7.0 using linked server. If it is possible, could you show some pointers as to how it can/should be implemented.
Thanks in Advance.
Manojkumar
DMT Team
DaimlerChrysler Capital Services
Phone - 203-845-7326
EMail - manoj.kumar@dcxcapital.com