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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: AMills (AMills_at_discussions.microsoft.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 11:47:02 -0700

No: the article is not relevant, as we don't use them, but it was the only
article I could find addressing this particular error message.

We will also try the situation you suggest below.

Thanks again

"Bob Barrows [MVP]" wrote:

> 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

  • Re: Error when installing SQL server 200 on SBS 2003
    ... it seems this newsgroup is helpful to all the SBS ... Microsoft CSS Online Newsgroup Support ... Error when installing SQL server 200 on SBS 2003 ... | In fact I got the same error message when upgrading to SQL SP4 ...
    (microsoft.public.windows.server.sbs)
  • Re: Classic ASP connectionstring to SQL Server 2005
    ... received an error message: ... database from an ASP to VB6 DLL to SQL Server 2K5? ... Connections option in the Database Engine node. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • help with EM error: ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
    ... As many other people in this newsgroup I applied to our SQL Server hot fix ... structure in Enterprise Manager I am getting following error message: ...
    (microsoft.public.sqlserver.server)
  • Re: IWD4 -- SQL Management Studio server name issue
    ... > Please reply only to the newsgroup so that others can benefit. ... > please state the version of SQL Server being used and the error ... > error message text received, ... That alias name is not propagated to the Object Browser. ...
    (microsoft.public.sqlserver.tools)
  • RE: Lsass.exe - when trying to update a password.
    ... Shortly before this error message, i lost all use of network ... > Thank you for posting to the SBS Newsgroup. ... What exact password you trying to update? ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)