Microsoft SQL Server : MSSql Server2005 linked server as400

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by angelo68mn 0n 05 November 2008

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.

Learn more about Microsoft SQL Server databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting