Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

asked 29 Jul '11, 01:33

Amit%20Chauhan's gravatar image

Amit Chauhan
accept rate: 0%

edited 15 Mar '13, 22:03

Mark%20Culp's gravatar image

Mark Culp

What sql anywhere version with which ebf are you using ?

(29 Jul '11, 02:33) ASchild

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.

(03 Aug '11, 00:11) Amit Chauhan

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.

permanent link

answered 29 Jul '11, 08:49

Ian%20McHardy's gravatar image

Ian McHardy
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 29 Jul '11, 01:33

question was seen: 2,422 times

last updated: 15 Mar '13, 22:03