Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
TSQL to query a linked AS400 server?
Maybe there are problems with authentification. You have to be logged in sql-server with SQL-authentification and NOT with windows-authentification. Otherwise the linked server will not be authentified correctly.- alandt
- Post #19
- Forum: RPG (Report Program Generator)
-
TSQL to query a linked AS400 server?
Hello, I had the same problems and found a solution using sql2000 and odbc-connection. Use the stored procedure exec master.dbo.sp_table_ex servername You get all tables of the linked server with: TABLE_CAT = catalog TABLE_SHEM = shema (interesting, its the db2-library name) TABLE_NAME =...- alandt
- Post #17
- Forum: RPG (Report Program Generator)
