I'm trying to create an AS400 linked server on SQL2005. I have Microsoft's DB2OLEDB provider installed.
I know how to create a linked server in SQL 2005, i just need to know what to fill in for the parameters when creating the AS400 linked server.
Product Name: ? (no idea)
Data Source: ? (the AS400 server name?)
Provider String: ? (this one I have no clue....)
Catalog: ? (the database name?)
There's an old question on EE, but the link in the solution is dead. Has anyone done this and can help? Thanks.
Any help on the login portion would be very valuable as well
I'm marking this urgent as my client needs me to move 5 tables yesterday :)