Hi
We have an application on one server (server A), which in its global.asa file specifies a connection to another sql server using
I use abit of custom code as follows
if the server istanbul , conn_z, is down the code crashes in server A - can i error handle this at all for a disconnected Istanbul server ?
many thanks
jacq
We have an application on one server (server A), which in its global.asa file specifies a connection to another sql server using
Code:
Application("Conn_Z") = "driver={SQL Server};server=Istanbul;database=Envsystem;uid=???;pwd=???"
I use abit of custom code as follows
Code:
ExecQuery_X "CONN_Z","CCC0026::INSERT INTO tblPubCon_ISB (CallID, CompType,location) values(?,?,?)", Array(adnumeric,
5,lngEnquiry,adnumeric,5,request("selPub"),adnumeric,5,request("selLocation"))
if the server istanbul , conn_z, is down the code crashes in server A - can i error handle this at all for a disconnected Istanbul server ?
many thanks
jacq