Thread: ...

...

From
harrison.w@zipmail.com.br
Date:
Dear,

I am with a problem to the use the driver OBDC in the server.
He closes my application when selecting a table or other resources.
In the machines client this mistake doesn't happen.
Server = Driver Version - 8.01.02.00,Postgre Version - 8.0.3,
OS - Win 2K Advanced Server P4 1GB ram
Client = Driver Version - 8.01.02.00,OS - Win 9x,PII 128MB ram
I'm enclosing the log.
thanks,





Error wirh text type field

From
"Sistemas C.M.P."
Date:
I'am using VisualBasic 6.0 + ODBC and I try to update text type field with the data of a RichTextBox.
The aplication show me this message (not usually).
 
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
What can i do?
PD: I'm Sorry of my poor English. I'm From Argentina.
 
                                                Thanks

Re: Error wirh text type field

From
"Campbell, Greg"
Date:
Your English is fine.

I did a Google search on "Multiple-step OLE DB operation generated errors" (with the quotes), and found
many interesting hits.

I believe the problem may be with the length of the data in the RichTextBox being either 0 or too long.
There may be some settings in the ODBC driver to help (Text As LongVarChar, Max LongVarChar length).

Does the length of the data  affect the error: Len(RichTextBox.Text)?
Could you reply with a small section of code (code snippet)?
You might want to try to log (ODBC Driver setting MyLog).
What version of pgodbc driver?
What version of PostgreSQL?



Sistemas C.M.P. wrote:
> I'am using VisualBasic 6.0 + ODBC and I try to update text type field with the data of a RichTextBox.
> The aplication show me this message (not usually).
>
> Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
>
> What can i do?
> PD: I'm Sorry of my poor English. I'm From Argentina.
>
>                                                 Thanks

Attachment