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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
I'll try it and post here feed back.
I'll ask another time if needed.