If a SQLCONNECT connection fails, the return value is -1. A handle of 1 is perfectly valid and that's what the first connection handle's value would be. Your test would eliminate this handle value. Change the If test to If gnConnHandle = -1 and try it.
>STORE SQLCONNECT('fsa', 'claims','password') TO gnConnHandle
>
> IF gnConnHandle <= 2
>
> = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
>
> ELSE
>
> = MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
> = SQLDISCONNECT(gnConnHandle)
>
> ENDIF
>
>This program is trying to connect to a SQL backend database to a database called FSA. I keep getting the Call failed message. Can you help?? Thanks for your assistance.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
