Troubleshooting
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.
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>
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>
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CY1AAM","label":"Data Access-\u003EOLE DB"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Historical Number
448254665
Was this topic helpful?
Document Information
More support for:
IBM i
Component:
Data Access->OLE DB
Software version:
All Versions
Operating system(s):
IBM i
Document number:
636741
Modified date:
18 October 2024
UID
nas8N1014412
Manage My Notification Subscriptions