Hi everyone,
i created a linked server to as400 with mssql2005 using odbc driver.

Quering the as400 using openquery function i have quick answer (1").

Making the same query using 4 part name costructor i have slow answer (1'30")

Moreover when i build a view in sql2005 vs as400 tables i have slow response, and is not possible to build an index on a view because of the table is on linked server.

There's somebody who has a suggestion or i have to use 4 part name costructor?
Do you think that a stored procedure is better?

thank's in advance for your answer
Angelo

Why not use OpenQuery ?

hey I created a linked server to the as400 and i am getting an error.

AN EXCEPTION occurred while executing a transact-sql statement or batch.

cannot initialize the data source object of OLE DB provider "IBMDA400" for linked server.

would you have a thought as to why this is happening?

i am able to create the linked server using Microsoft OLE DB provider for indexing service, but i am not able access the tables.