"Error 7302 Could not create an instance of OLE DB provider IBMDASQL" When Creating a Linked Server in SQL Server

Resolving The Problem

This document describes a resolution to an "Error 7302 Could not create an instance of OLE DB provider IBMDASQL" being received when attempting to create a linked server in SQL Server.

Resolution

When using Microsoft SQL Server and distributed queries with the IBM OLE DB Providers supplied with iSeries Access for Windows, the Allow InProcess option must be enabled. This option is required because SQL Server passes the proper authentication across the remote procedure call only when the OLE DB Provider is configured for Allow InProcess (Microsoft Corporation 2007).

Allow InProcess

SQL Server allows the OLE DB provider to be instantiated as an in-process server. The default behavior is to instantiate the OLE DB provider outside the SQL Server process. Instantiating the provider outside the SQL Server process protects the SQL Server process from errors in the OLE DB provider. SQL Server requires an in-process server for handling specific types of data including long columns, text, and image data. The OLE DB Provider for DB2 does not currently support the DB2 Large Object (LOB) types.

This option may be enabled or disabled for the OLE DB Provider for DB2; however, this option is normally unnecessary when using SQL Server 2000." (Microsoft Corporation 2007)

Setting the Allow InProcess Provider Option

SQL Server 2000

When creating a new linked server (under Microsoft SQL Servers -> SQL Server Group -> [SQL Server Database] -> Security -> Linked Servers -> Right-click on Linked Servers, and select New Linked Server), select the Provider Options button below the OLE DB provider name. Check the Allow InProcess option to enable the property.

SQL Server 2005

The Allow InProcess option must be set on the specific provider before the linked server is created. You can add the linked server provider option under [SQL Server Database] -> Server Objects -> Linked Servers -> Providers -> Right-click on a provider, and select Properties. Finally, check the Allow InProcess option to enable the property.

References

"Distributed Query Support Using the OLE DB Provider for DB2." 2007. Microsoft Corporation. 24 April 2007.

//msdn2.microsoft.com/en-us/library/ms943674.aspx>