ADO connection object

[zfang]

Hi There:

How to check whether an ADO connection object calls the open method successfully? Say,

set conn = Server.CreateObject("ADODB.Connection&quot
coon.open = "a connection string"

Is there a way to check the db connection works?

Thanks,

George

 

[PatrickIRL]

The state of the connection object will tell you.

After conn.open = "a connection string", check like this

if conn.state = 1 then
(you have a valid open connection)
else
error message
end if

Regards,

Patrick

 

[zfang]

Patrick:

Thanks a lot. It works great.

George