How to check if there is an error?...

[June Moore]

Hi,
I have the following ASP...
set dbconn = server.createobject("ADODB.connection")
dbconn.open "dsn=news;uid=hello"

After the dbconn.open, how do I check if the dbconn.open has an error?
e.g. if dbconn has error
do something...

Thanks,
June.....

 

[Vinod]

Hi,
I have the following ASP...
set dbconn = server.createobject("ADODB.connection")
dbconn.open "dsn=news;uid=hello"

After the dbconn.open, how do I check if the dbconn.open has an error?
e.g. if dbconn has error
do something...

Thanks,
June.....

Using the onerror statement , if you want or by using it

dim objErr
set objErr=Server.GetLastError()
response.write("ASPDescription=" & objErr.ASPDescription)
response.write("<br />")

 

[Ganesh]

Hi,
You can do one of these...

1. You can use the Errors collection of the connection object
2. You can check with the connection.state property whether it is open.
3. Have On Error Goto statement to trace any errors.

Ganesh

 

[Kyle Peterson]

http://powerasp.com/content/new/on-error-resume-next.asp