Re: Microsoft OLE DB Provider for SQL Server (0x80004005)

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 14:24:58 -0400

AMills wrote:
> Bob:
>
> Here is my ASP code that is used:
>
> strSQL = "EXEC dbo.pci_Student_Certs_Monthly_Data_Load @MonthDate='" &
> strDate & "'"
> objConn.Execute(strSQL)
>
> Also: the changes that Microsoft suggested was to add this line to my
> connection string:
> OLE DB Services = -2;
>
OK, I found the article that gave the advice you followed:
http://support.microsoft.com?kbid=229564

 My question is: is this article relevant? Are you using Application Roles
on your SQL Server?

I think a better solution would be to use TCP/IP to connect to your server,
rather than Named Pipes. To force that to happen, use this in your
connection string (and get rid of that setting to disable pooling - you do
not want to do that unless it is a last resort):

Network Library=DBMSSOCN;

Bob Barrows 

-- 
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Relevant Pages