[postgis-users] spatial queries in an ODBC connection

[Obe, Regina]

Anything you can do in PgAdmin you can do with a pass-thru query in MS
Access.
 
Take a look at this article which demonstrates making a TSearch query
with a pass-thru MS Access query.
 
http://www.postgresonline.com/journal/index.php?/archives/24-Using-MS-Ac
cess-with-PostgreSQL.html
 
You would do the same thing with PostGIS spatial queries, though won't
display spatial data, but I use they same technique to call my
geocoding/proximity Postgis functions/views/ahoc spatial attribute
queries from MS Access.
 
Hope that helps,
Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Pablo
Sent: Wednesday, December 24, 2008 6:05 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] spatial queries in an ODBC connection


Hi!
First of all, sorry about my english, is not very welll...

Well... someone can tell me if I can use the postgis functions (buffer,
crosses, etc etc...) from a form in access or open office database via
ODBC?

The question is that Ihave an spatial database created with lines,
polygons, etc. And I have a lot of spatial queries. There is no problem
when I run them in pgadmin. But what I want is make an easy form in
order that other people can connect with the server via ODB, and run the
spatial queries.
When I try to make simple queries (select from tables, etc) its all OK,
but when I type compley queries in access, it tells me that the
functions are not available.

Some body knows if can I make spatial queries in a form?
I don't mind if is in access, open office, or other. I accept
suggestions.

Thanks a lot!

Pablo



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081224/feff16ec/attachment.html>