View Single Post

   
  #2 (permalink)  
Old 04-16-2008, 02:51 AM
Ludek Finstrle
 
Posts: n/a
Default Re: psqlODBC generating incorrect SQL?

> Can anyone think of a reason that the windows psqlODBC driver would
> generate SQL that doesn't quote strings correctly? I am seeing lines
> in psqlodbc_xxxx.log that begin like:


It seems to me that psqlODBC means it is another type.

> UPDATE "public"."application" SET "decision"=? WHERE ...


It uses binding parameters. Nothing new. I don't know what leads to
the problem.

> by filling in parameters, so it seems to me that it is the driver that
> is at fault, since it must have filled in the parameters.


Maybe driver or something another doesn't work correctly.
What's the decision column type?

> I'm very confused about how this could be happening. It doesn't
> happen on my computer, only on one of my users' computers, running the
> latest version of psqlODBC in Windows XP. Any suggestions would be
> greatly appreciated!


It could be interesting to see mylog outputs (from your computer - the
correct one and from user's comupter - the faulty one).
Maybe you don't have same connection options.
Are you both using same psqlODBC driver (version ant type - ANSI vs.
Unicode)?
And what about backends, ...?

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote