Last post Sep 28, 2008 11:14 PM by ZychoFlow
Jul 23, 2008 10:41 AM|stephane3d|LINK
I have this error when I run a stored procedure calling a MSSQL linked server :
System.Data.SqlClient.SqlException: Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "linkedServerABC"
The problem is that when I run the exact stored proc in SQL Server via the query editor it works well.
So why ASP.Net on the same server can't execute this stored proc?
MSSQL Linked server SqlException
Jul 26, 2008 12:23 AM|Jian Kang - MSFT|LINK
Please open the "SQL Server Management Studio", go to the "Server Objects"->"Linked Servers"->"Providers", right-click the "MSDASQL" and open the "Properties" window.
Check the checkbox "Allow inprocess" to enable it.
Sep 16, 2008 11:03 AM|ZychoFlow|LINK
Hi I have a similar problem.
But enabling the "Allow inprocess" didn't help me (actually it was enabled by default).
I have an ASP.NET application that's queries a table function on SQL Server; which queries a linked server.
This linked server uses an odbc connection to connect to a Lotus Notes database through a NotesSQL datasource.
Now I can query this database directly through the Management Studio I just get this error through my ASP application.
Do I have to add some sort of reference? or am I missing something else?
Sep 23, 2008 11:43 AM|ZychoFlow|LINK
Maybe I'm going about this all wrong.
Could someone point me in the right direction then?
Sep 28, 2008 11:14 PM|ZychoFlow|LINK
Just an update
For some reason in order for the linked server to be able to connect I needed to
log into my lotus notes client. I'm guessing that I had to unlock the id. Also
if any other process has the driver (nsql32.dll) loaded then other applications can't load it.
Systernals process explorer helped a lot on this.
I hope this helps anyone having the same problem.