Thread

1. another possible ODBC error (inserting memo fields in varchar)

   Calvin Dodge <cgd@linkoweb.com> — 2001-04-16T20:37:41Z

   I've run across a consistent problem with M$oft Access, psqlodbc.dll,
   and Postgres.
   
   If I try to do an insert query from an Access table to a Postgres table,
   Access 97 crashes IF that insert includes any memo fields (appending to
   a varchar field, in my case). Access 2000 doesn't crash, but it doesn't
   append anything, either.
   
   For the record, I'm using PostgreSQL 7.1 on Red Hat 7.0 (using the RPMs
   from Sourceforge's PostgreSQL mirror), and the latest version of
   psqlodbc (004).  But the same problem occurred with PostgreSQL 7.0, and
   with earlier version of psqlodbc.
   
   I CAN work around this by inserting everything EXCEPT for the memo
   fields, then updating the destination fields using code (ODBC workspace
   and ODBC connection's Execute method), but it does concern me a bit.
   
   Am I doing something wrong here? I wonder because I haven't seen this
   problem mentioned in my Google and Postgresql.org searches. Or is this
   so well-known that everyone already knows the workaround, so it's not
   considered newsworthy? Is this a general issue with Access and ODBC,
   rather than specifically with psqlodbc?  Inquiring minds like mine want
   to know.
   
   Thanks for listening,
   
   Calvin Dodge
   caldodge@fpcc.net (writing from work)
   
   

2. p.s. (Re: another possible ODBC error)

   Calvin Dodge <cgd@linkoweb.com> — 2001-04-16T20:39:12Z

   It also doesn't matter whether I have MDAC version 2.5 OR 2.6 installed.
   
   Calvin