Re: VBscript Error 800a01a8 on Connection.Close

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/24/04 

Date: Wed, 23 Jun 2004 22:02:10 -0400

Hi Peter,

Before closing connection, you have to close all the recordsets, opened
against this connection unless they are disconnected. Provider is no able to
close connection, if application opened recordset (cursor) and did not close
it. Close recordset first and then close connection 

-- 
Val Mazur
Microsoft MVP
"Peter Gruendler" <usenet8@hnet.at> wrote in message 
news:3aeox7zy7tn$.dlg@gruendler.org...
> I'm getting a weird error from the last line in code snippet[1] below:
> "Objekt erforderlich: 'Provider=Microsoft.J'".
> The connection is operable, as can be seen in the tracing output[2].
>
> I have to do the conn.close, because in the next part of the code I have
> to open the connectin again. This is neccessary, because the server will
> open connections with adModeShareDenyExclusive, no matter what I set in
> Connection.Mode before .Open.
>
> * Why can't I close the connection? *
>
> peter
>
> [1]
> [ldconn is already open]
> | Set rs = Server.CreateObject("ADODB.Recordset")
> | rs.Open sql, ldConn, 3, 3
> | if rs.recordcount > 0 then
> | ' Es gibt was zum Darstellen
> |
> | ' in Session-Variablen schreiben
> | Session("zjournalk") = rs.Fields("zitJournal")
> | Session("zVolume") = rs.Fields("zitVolume")
> | Session("zJahr") = rs.Fields("zitJahr")
> | Session("zSeiten") = rs.Fields("zitSeiten")
> | Session("zAutoren") = rs.Fields("zitAutoren")
> | Session("zTitel") = rs.Fields("zitTitel")
> | Session("zKeywords") = rs.Fields("zitKeywords")
> |
> | if tracing then response.write(ldconn & "<br><br>")
> | ldConn.Close
>
> [2]
> | SQL: #SELECT * FROM ldZitat WHERE zitKey=11#
> |
> | Provider=Microsoft.Jet.OLEDB.4.0;Password="";
> | User ID=Admin;Data Source=F:\hnet\glivec\database\lit.mdb;
> | Mode=Share Deny Read|Share Deny Write;Extended Properties="";
> | Jet OLEDB:System database="";Jet OLEDB:Registry Path="";
> | Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;
> | Jet OLEDB:Database Locking Mode=0;
> | Jet OLEDB:Global Partial Bulk Ops=2;
> | Jet OLEDB:Global Bulk Transactions=1;
> | Jet OLEDB:New Database Password="";
> | Jet OLEDB:Create System Database=False;
> | Jet OLEDB:Encrypt Database=False;
> | Jet OLEDB:Don't Copy Locale on Compact=False;
> | Jet OLEDB:Compact Without Replica Repair=False;
> | Jet OLEDB:SFP=False
> |
> | Laufzeitfehler in Microsoft VBScript- Fehler '800a01a8'
> |
> | Objekt erforderlich: 'Provider=Microsoft.J'
> |
> | /glivec/litdb/admin/zitatbearbeitenstep3.asp, line 78

Relevant Pages

  • Re: commit or rollback a transaction without first beginning a transaction
    ... I understood the opposite; that when a recordset ... the recordset before entering the transaction, ... > what happens with a Jet recordset. ... >> a single connection, so when SQLTransact is called, all statements on the ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADO connect string question
    ... > I am learning about the connect string using thekb on microsoft web as ... your connection string: ... Provider for Microsoft Jet ... Now, after all that, I recommend that you continue to use DAO to access Jet ...
    (microsoft.public.vb.general.discussion)
  • Re: OleDbException: Could not update; currently locked
    ... Are you using one connection or multiple? ... the OleDB .Net provider is still using Jets OleDB provider. ... independent Jet session. ... dbParams, Object& executeResult) at ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: test connection failed
    ... .udl contains connection string and path to database (for Microsoft Jet ... Check also that you have Jet provider installed or install Jet SP from ...
    (borland.public.delphi.database.ado)
  • Re: database trying to open localy instead of off server.
    ... the only connection I can make to the server ... and bot of these fail if I use them in the connection string. ... that will cause access/asp to look on the website for the database. ... Jet OLEDB:Database Locking Mode=1; ...
    (microsoft.public.access.gettingstarted)