470,614 Members | 1,458 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

linking to MS Access using ODBC and geometric types?

Sorry for the seemingly novice posting, but I could find a solution for this
on the web so far...

I've been developing a database using postgresql (and loving it) and have
started running into problems with attempting to update records using the
ODBC connection. The tables that contain geometric fields are causing the
problems. Whenever I try to update a record that contains a geometric field
(any field) I get the following error message:

ODBC -- update on a linked table 'public_locations' failed.
ERROR: invalid input syntax for type point: "(100),(100)" (#7)

When I attempt to update the record without the quotes, as if typing 100,100
in the point field, I get the error:

"record has been changed... blah, blah, blah..."

Is there some trick to being able to use the geometric data types if you're
going to interface with Access using the ODBC driver?

Jeff.

---
Jeff D. Hamann
Forest Informatics, Inc.
PO Box 1421
Corvallis, Oregon USA 97339-1421
541-754-1428
je*********@forestinformatics.com
www.forestinformatics.com
Aug 3 '05 #1
0 1731

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jon Ole Hedne | last post: by
3 posts views Thread by John South | last post: by
2 posts views Thread by Jeff Pritchard | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.