I'm banging my head trying to establish a linked server to query. I'm using SQL Server Management Studio Express and have an ODBC connection:

OBDC System DSN setup using: iSeries Access for Windows ODBC data source

DSN name = AS400

SQL default library = M800DAT200 (using SQL naming convention)

Would appreciate some insight.

Thanks.