By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,872 Members | 2,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,872 IT Pros & Developers. It's quick & easy.

linking to MS Access using ODBC and geometric types?

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.