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".
Solution:
- 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;
GO
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE
EXEC sp_configure 'scan for startup procs', '1';
RECONFIGURE
GO
CREATE PROC usp_enum_oledb_providers
AS
exec sp_enum_oledb_providers
GO
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:
Een reactie posten