And my post too (among others...)  Steve

I was getting this same error and just figured it out yesterday.  Seems my maintenance plan covered multiple databases, one of which had a SIMPLE recovery model.  Part of the...

Users could always use the BACK button to go back to your form page and click the submit button again.  Also if the processing of the form is taking a while,...

I had the same thing happen to me in regular ASP on Fri.  Worked OK in QA, error in ASP page was that the recordset (thru ADO) wasn't being opened. ...

I used to get this all the time too.  TOOLS --> OPTIONS --> ADVANCED tab in EM.  Increase the "Login Time-out"

The concept of "trusted" or multi-level security deals with discretionary access controls (DAC) which is the grant, revoke, etc-level permissions users get on data objects as well as mandatory access...

C'mon...  why would the QOD focus on a glitch in a SP?  I would hope the goal of the QOD is to help folks learn more about the intricacies of...

To tag onto ianscarlett's reply, copy the rows you DON'T want to delete into a temp table using SELECT INTO (no logging),...

I do this all the time.  However, you don't even need a Connection object, just a connection string.  I have an INCLUDE file (for ASP) that contains my connection string.

e.g.

connString...

Try something like this:

firstname = xxxxx   ' however you set your local variable, such as from Request.Form

lastname = xxxxx    ' ditto

Set cm = Server.CreateObject("ADODB.Command")

cm.ActiveConnection = "Driver....."

cm.CommandType = 4     ' adCmdStoredProc

cm.CommandText...

Question regarding Antares686's comment regarding adUseClient.  If this is an ASP app reading from SQL Server, what would adUseClient do for you?  Since ASP is all server-side, wouldn't all cursors...

Where do you want the image to load?  In a web browser?  Into another field of your DB?  Need more info.  If the former, output your stored URL as the...

I go into Ent Mgr, highlight all of the rows of column info, then paste into Excel.  Seems to work well if you're just using this info on-the-fly.  You even...

It depends on how your DMZ/firewalls are set up.  I work on an Air Force base and our web and SQL servers are in the DMZ.  Inside the base firewall,...

Setting the conn string and/or connection object (if you're using one) in an INCLUDE file is definitely a good way to go.  However, using a .INC extension is a bad...