VBscript Error 800a01a8 on Connection.Close

From: Peter Gruendler (usenet8_at_hnet.at)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 09:09:56 +0200

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: 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)
  • Jet Latency - overcoming the delay between writes and reads
    ... before changes made by one connection can be seen by another connection. ... Set connection property Jet OLEDB:Flush Transaction Timeout ...
    (borland.public.delphi.database.ado)