"Error Reading Data from Connection"

View: New views
6 Messages — Rating Filter:   Alert me  

"Error Reading Data from Connection"

by R. B. Singh :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hello,

 

I am facing problem with inserting data into BLOB Subtype 1 field. When the text size going to some extent.

What could be the problem.

 

I am using a simple insert query for inserting the Text Data.

 

 

Regards,

Rakesh Singh.

http://www.4colordesign.com

 


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: "Error Reading Data from Connection"

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some example what you're doing would be helpful.

--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: "Error Reading Data from Connection"

by R. B. Singh :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,
Let me give some details of what I am doing. I have 75 page TIFF file. On
which i am doing OCR and extracting the Text from all the 75 pages. Which
consist of a single string data.

And that string data I am passing to the insert Query.

OCRDATA= "OCRResult";
Query= "INSERT INTO OCRCONTENT(FileCode, OCR_DATA)VALUES(12202,+ "'" +
OCRDATA + "')";

Regards.
Rakesh Singh.
http://www.4colordesign.com


-----Original Message-----
From: Jiri Cincura [mailto:diskuze@...]
Sent: Thursday, July 24, 2008 1:22 PM
To: kixzodb@...; For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] "Error Reading Data from Connection"

Some example what you're doing would be helpful.

--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: "Error Reading Data from Connection"

by Carlos Guzmán Álvarez ™ :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello:

And that string data I am passing to the insert Query.

OCRDATA= "OCRResult";
Query= "INSERT INTO OCRCONTENT(FileCode, OCR_DATA)VALUES(12202,+ "'" +
OCRDATA + "')";

Can you try using parametrized queries ??
 



--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.wordpress.com

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: "Error Reading Data from Connection"

by Joaquim Pais :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,
 
if OCR_DATA is a binary do you have using parametrized queries.
example
fbcomamnd cmd = new fbcommand();
cmd.connection = <yourconnection>;
cmd.commandtext= INSERT INTO OCRCONTENT(FileCode, OCR_DATA)VALUES(12202,@OCR_DATA);
cmd.parameters.clear();
cmd.parameters.add("@OCR_DATA",<valuebinary>)
cmd.executenonquery();
 
 
This example is in c# and pseudo-code..
 
Regardes
Joaquim Pais
 

 
On Thu, Jul 24, 2008 at 10:19 AM, Carlos <carlosga05@...> wrote:
Hello:

And that string data I am passing to the insert Query.

OCRDATA= "OCRResult";
Query= "INSERT INTO OCRCONTENT(FileCode, OCR_DATA)VALUES(12202,+ "'" +
OCRDATA + "')";

Can you try using parametrized queries ??
 



--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.wordpress.com

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider




--
Sem mais com os cumprimentos
____________________________
Joaquim Pais


Ao reenviares mensagens apaga os endereços de correio electrónico
nelas incluídos
Usa "Bcc" ou "Cco" em vez de Para.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: "Error Reading Data from Connection"

by HugoHiasl :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
Hmm..I don't dare to ask.
 
Did you escape single quotes in your ocrresult?
 
You need to double every single quote since it will end your string if you don't
 
"This is my 'sample' OCR string"
 
needs to be converted to
 
"This is my ''sample'' OCR string"  (Take care. There are 2 single quotes on every side of ''sample'' not one double-quote) :-)


From: firebird-net-provider-bounces@... [mailto:firebird-net-provider-bounces@...] On Behalf Of Kixzo Database Team
Sent: Donnerstag, 24. Juli 2008 08:56
To: firebird-net-provider@...
Subject: [Firebird-net-provider] "Error Reading Data from Connection"

Hello,

 

I am facing problem with inserting data into BLOB Subtype 1 field. When the text size going to some extent.

What could be the problem.

 

I am using a simple insert query for inserting the Text Data.

 

 

Regards,

Rakesh Singh.

http://www.4colordesign.com

 


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider