Click here to Skip to main content
15,922,145 members
Home / Discussions / Web Development
   

Web Development

 
GeneralLoading and XML document from an site secured with SSL Pin
Chris Whiting26-Nov-01 20:19
Chris Whiting26-Nov-01 20:19 
Generalpaging Pin
meirav23-Nov-01 9:21
meirav23-Nov-01 9:21 
GeneralRe: paging Pin
Jon Sagara23-Nov-01 9:43
Jon Sagara23-Nov-01 9:43 
GeneralRe: paging Pin
meirav23-Nov-01 18:29
meirav23-Nov-01 18:29 
GeneralRe: paging Pin
Jon Sagara23-Nov-01 20:04
Jon Sagara23-Nov-01 20:04 
GeneralRe: paging Pin
Jon Sagara23-Nov-01 20:13
Jon Sagara23-Nov-01 20:13 
GeneralIndependents Day Pin
Paul Watson23-Nov-01 1:35
sitebuilderPaul Watson23-Nov-01 1:35 
GeneralProblem with persistant database connection Pin
Rhoam20-Nov-01 10:44
Rhoam20-Nov-01 10:44 
Greetings Programs,

Now I realize most people have problem persisting thier database connections, I on the other hand have a problem with persistant connections.

Heres the skinny: Take a simple portion of my code such as:

Dim CN
Dim RS
Set CN = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
CN.Open = "Provider=SQLOLEDB; Data Source=BLAH; UID=BLAH; PWD=BLAH;"
Set RS = CN.Execute("SELECT * FROM ##tmpTable")
Response.Write BLAH
RS.Close
CN.Close

The problem is that even though the recordset and connection are close, the database still shows a connection. Does anyone know why this connection persists? How can I make sure this sucker dies on command?

Thanks,

Rhoam



Cool | :cool:
GeneralRe: Problem with persistant database connection Pin
22-Nov-01 3:40
suss22-Nov-01 3:40 
GeneralRe: Problem with persistant database connection Pin
Carlos Antollini22-Nov-01 3:58
Carlos Antollini22-Nov-01 3:58 
General‘Upload File To Disk and save text fields from input box into a DB at the same time.. Pin
Bruno Lemos20-Nov-01 7:54
Bruno Lemos20-Nov-01 7:54 
GeneralRe: ‘Upload File To Disk and save text fields from input box into a DB at the same time.. Pin
Jason Jystad26-Nov-01 7:29
Jason Jystad26-Nov-01 7:29 
GeneralIIS Printing (Help Required!) Pin
Kevin Gutteridge20-Nov-01 6:04
Kevin Gutteridge20-Nov-01 6:04 
GeneralRe: IIS Printing (Help Required!) Pin
Kevin Gutteridge21-Nov-01 3:34
Kevin Gutteridge21-Nov-01 3:34 
GeneralRe: IIS Printing (Help Required!) Pin
Carolina27-Nov-01 4:18
Carolina27-Nov-01 4:18 
GeneralRe: IIS Printing (Help Required!) Pin
Kevin Gutteridge27-Nov-01 19:23
Kevin Gutteridge27-Nov-01 19:23 
GeneralCreating a js file to hold image addresses Pin
19-Nov-01 12:56
suss19-Nov-01 12:56 
Generalusing ASP in flash 5.0 Pin
vbcrazeee19-Nov-01 7:22
vbcrazeee19-Nov-01 7:22 
GeneralRe: using ASP in flash 5.0 Pin
Philip Patrick23-Dec-01 7:25
professionalPhilip Patrick23-Dec-01 7:25 
GeneralResponse.ContentType (XLS) Pin
19-Nov-01 1:43
suss19-Nov-01 1:43 
GeneralRe: Response.ContentType (XLS) Pin
Jason Jystad21-Nov-01 10:32
Jason Jystad21-Nov-01 10:32 
GeneralRe: Response.ContentType (XLS) Pin
22-Nov-01 3:36
suss22-Nov-01 3:36 
GeneralASP.NET Server Side Controls Pin
Bob Groves18-Nov-01 11:30
Bob Groves18-Nov-01 11:30 
GeneralMoved Pin
Jon Sagara16-Nov-01 15:53
Jon Sagara16-Nov-01 15:53 
Questionhow to design send email using form by HTML Pin
14-Nov-01 18:33
suss14-Nov-01 18:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.