host variable to insert blob

[Former Member]

i am inserting a blob data using host variable(:longdata) sometimes it gives error (SQLSTATE 08003 Not connected to SQL database), please help me.

[Former Member]

What sql anywhere version with which ebf are you using ?

[Former Member]

I am working on Sybase SQL anywhere 8-11, its imaging because sometime same query (same data also) executed while sometime not on the other hand if i am trying it with interactive SQL its executed successfully. So it is very difficult to understand for what is the problem?

Thanks for replies.

[ian_mchardy]

You would normally get this error if you tried to execute something without first connecting, or after disconnecting. See here in DCX.

Typically, if the connection would dropped by the server or due to a network or other error, you would get the error "Communitions error" (see here), or possibly "Connection was terminated" (see here).

If it isn't obvious why you are getting an error, perhaps enabling -z -zr sql (communication diagnostics and request level logging server options) on the server and LogFile=file on the client will help.