Operation is not allowed when the object is closed....

I have an asp page that calls a VB dll. The dll is connecting to a SQL
Server database using integrated security- essentially the identical
connection string I use in my global.asa file. This account (webuser) is an
IIS account which also has a valid login in my db server (and access to the
specific db).

I receive this error ONLY if I remove the 'db_owner' role within SQL Server
as I since this is a security risk. I set the webuser account as a data
reader and data writerafter removing the db_owner role.

The dll successfully updates a bunch of records, and then writes the
'Operation is not allowed when the object is closed' error to a log file I
created. The rest of my web app, all written in classic ASP, allows me to
succesfully perform all other actions, which includes updates and inserts.
.

Relevant Pages

  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • how to configure ms sql server 2k and windows server 2k in order to sql from remote computer (with v
    ... My local database (under ms sql server 2000, ... database using a connection string with the ADODB VB object. ...
    (microsoft.public.sqlserver.connect)
Loading