Question Re: host variable to insert blob in Technology Q&A

host variable to insert blob

Former Member — Fri, 29 Jul 2011 01:33:18 GMT

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

Re: host variable to insert blob

Former Member — Fri, 29 Jul 2011 02:33:10 GMT

What sql anywhere version with which ebf are you using ?

Re: host variable to insert blob

ian_mchardy — Fri, 29 Jul 2011 08:49:43 GMT

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.

Re: host variable to insert blob

Former Member — Wed, 03 Aug 2011 00:11:40 GMT

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.