closing connection

Results 1 to 2 of 2

Thread: closing connection

  1. #1
    Join Date
    Dec 1969

    Default closing connection

    I am having trouble closing my connection<BR><BR>I opent the connection in an include file<BR><BR>&#060;%<BR> Dim adoCon<BR> <BR> Set adoCon = Server.CreateObject("ADODB.Connection")<BR> <BR> adoCon.mode = 3 &#039; adModeReadWrite<BR> <BR> adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("..DatabasesMTAS.mdb") & ";"<BR> <BR>and put the following code at the bottom of the page<BR><BR>adoCon.close <BR>set adoCon = Nothing<BR><BR>Error Type:<BR>Microsoft VBScript runtime (0x800A01A8)<BR>Object required: &#039;&#039;<BR><BR>i keep getting this error! any help??

  2. #2
    Join Date
    Dec 1969

    Default RE: closing connection

    are you sure that the connection is being open? Does it tell you what line the error is occuring on? Are you sure that you are not closing the connection somewhere else in the page?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts