An associate has been using the humble but functional medium of an Access
database to link in tables from SQL Server 6.5 and an AS/400 and query the
combined data together from client applications. He must now eliminate the
I am familiar with the ease of setting up a "linked server" with SQL 7, or
of doing ad hoc distributed queries.
What equivalents are available with SQL 6.5? What would be the best way to
bring in data from an AS/400 -- say, into temporary tables -- so that client
applications could treat it all as a single database?
CC by email appreciated if convenient. Thank you very much!