I succeed to create a linked server to AS400 with you help:
Now i still have a few problems:
1- I see different tables than when linking with MS Access!
2- When creating a view like that:
select * from hc3_linked.s44g5402.shhom0
i got all the column titles, but no records and an error message:
"[microsoft][odbc sql server driver][sql server] ole db provider 'msdasql' reported an error. The provider did not give any information about the error."
3- in the properties > General tab of the linked server, I only entered the DSN name (HC3) as Data source.
Should i fill Product Name or the 3 other fields?
FYI, i can link through MS Access like this:
Thanks in advance.