Link to home
Start Free TrialLog in
Avatar of prismabi
prismabi

asked on

How to create in SQL SERVER a linked server to AS400 ?

Dear experts,
Is it possible  to create in SQL SERVER a linked server to AS400 ?
I succeed to create a linked server to a second SQL SERVER , but not to AS400.
Thanks in advance.
SOLUTION
Avatar of ispaleny
ispaleny
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of prismabi
prismabi

ASKER

Thanks to you all.
I'll try it and post here feed back.  
I'll  ask another time if needed.
I have an ODBC DSN that is working to the AS400 server.
I added a linked server inSQL Server, with this DSN as  Data Source.
What should I type in Catalog?
When I click Ok, the enterprise manager hang forever.
Thanks
Catalog is your database name