This is the test i did for the connection.
' Connecting to the database
WriteToFile logfilepath, date & " " & time & "isobject(conn) = " & isobject(session("connection")) & vbcrlf , True
if not isobject(session("connection")) then
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Form_Store_PSQL"
session("connection") = conn
WriteToFile logfilepath, date & " " & time & "IF " & conn & vbcrlf , True
else
set conn = session("connection")
WriteToFile logfilepath, date & " " & time & "ELSE " & conn & vbcrlf , True
end if
Thank you.
Shavonne Wijesinghe
