var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MSSql Server2005 linked server as400
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
my linked server does not work
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.