-
Creating a Linked Server to AS400.
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
-
Creating a Linked Server to AS400. (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|