ASP and Database Connection Question 1

[Manxman55]

OK Guys,

I got the database open with the following code (which all works perfectly)....

// Build the sql statement
m_strSQL = "select * from <datatable> where Remote_IP Like '%" & Request.ServerVariables("REMOTE_ADDR") & "%';"
// Create the MySQL Connection.
set MySQLConn = server.createobject("adodb.connection")
// Open the Database
MySQLConn.open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=<IP Address>;DATABASE=(Database Name>;USER=<User Name>;PASSWORD=<Password>;OPTION=3;"
// Open recordset
Set objRS = MySQLConn.Execute(m_strSQL)
//
If objRS.EOF Then Response.Redirect("ID_Survey.asp")
//
%>

Silly question is, having directed the browser to another page, (or stayed on this one depending on the "objRS.EOF" result) how do I close the Database and Connection?

 

[TonyGroves]

I don't use ASP myself, but a quick search turned up the following page which shows how to close a connection:

http://www.aspwebpro.com/tutorials/asp/dbconnectionclose.asp

 

[DotNetGnat]

here...something like this:

If objRS.EOF AND objRs.EOF Then 
'Now close all your objects
set rs=Nothing
rs.close
set con=Nothing
con.close
Response.Redirect("ID_Survey.asp")
else
'display your records
Do until objRS.EOF 
'display fields
objRS.Movenext
Loop
'Now close all your objects
set rs=Nothing
rs.close
set con=Nothing
con.close
end if

-DNG

 

[DotNetGnat]

oops change variables rs and con to reflect your own recordset object and connection object.

-DNG