vrijdag 25 april 2008

Linked Server failure for IBM OLE DB Providers on SQLServer2005 X64 Cluster

I've Created Linked servers to IBM AS400 machines using the IBMDA400 and IBMSQL400 OleDb providers. If I failover, or take off-line and bring back on-line the SQL Resource Group, I get this Error:

Msg 7340, Level 16, State 4, Line 1
Cannot create a column accessor for OLE DB provider "IBMDA400" for linked server "ATCOAIRC".


- Browse in the Management Studio to the linked Server, request the properties, and close this window again everytime SQLServer Service starts ;-)

Or, if you don't want to do this manually - Duhhh...

- USE master;

EXEC sp_configure 'show advanced option', '1';

EXEC sp_configure 'scan for startup procs', '1';

CREATE PROC usp_enum_oledb_providers

exec sp_enum_oledb_providers


exec sp_procoption N'usp_enum_oledb_providers', 'startup', 'on'

Note: I didn't have this problem with SQLServer or Oracle Linked Servers.

Geen opmerkingen: