Connect to SqlServer without error message

[Kongsjs]

Hi

I am makeing a program that should run 24/7 on it's own.
In this program I need to connect to 2 different SqlServer databases, and all this works well.
The problem appears when one of the SqlServers are down or someting else goes wrong when I connect to the SqlServer.
I then get a MessageBox with the error message, and then the connection prompt.

The question is: How do I get rid of this messagebox and the connection prompt ?
I want to just check the SqlCode to see if something has gone wrong, and then send a SMS to my Cell phone, so I can fix the problem.

Anyone that know how this is done i PowerBuilder 7.0.3 ?

 

[Mariaszek]

First of all you should check SQLCode after connect to database.
If messagebox still appears try to use SystemError event and try to catch the error there.

Tomek

 

[Kongsjs]

The problem is that the messagebox appears on the "Connect" statement, so I never get down to the "If" I have after the connect.

Connect;
if sqlca.sqlcode <> 0 then

I guess there must be some way of turning of getting the messagebox/prompt, but I dont know how.

 

[Mariaszek]

1. What is your sqlca params definition script before "connect" command?

2. Look into PB help on "Try...Catch" syntax. Maybe it helps you to catch an error.

Tomek

 

[mbalent]

I don't think PB7 had 'Try Catch'

Matt

"Nature forges everything on the anvil of time

 

[Mariaszek]

Of course, You are right.
Sorry.

Tomek