adodb.connection wtf

[haytatreides]

I have a webpage, that on load establishes an adodb connection. the problem is, if i close the page then reopen it, it will not connect. i am guessing that it leaves it open. i put a myConn.close in the code, and it does not seem to make a difference. i am tired of restarting my PC. please help me.

hayt

 

[Rob94]

hayt,

not sure if this will help, but place this piece of code after the line "myConn.close":

Set myConn = Nothing

i know this sounds stupid of me to state as well, but you may want to ensure that you are actually getting to the section of code where you are closing the connection object (myConn.close). Is your code executing on the client or server side?

 

[haytatreides]

Get this, for some really really weird reason, when the line of code immediately AFTER the myConn.close had an error in it, it wouldn't run myConn.close. So when i changed the line after it, suddenly it works like a charm. as much as i want to know why, i am just glad it works.

server side script btw.

thanks for all your help rob, i got the whole thing working. what a pain in my @$$.