[postgis] WKB from PostGIS over ODBC

[Erik Brenn]

Hi all,

The PostgreSQL ODBC news group might be a better place for this but I wonder 
if there are anyone out there who know if it should be possible to use a 
Postgis function like this from an ODBC client:

select wkb_ndr(geom) where ...

>From the ODBC configuration settings I see that unknown types can be 
transferred as LongVarchar.
Basically I would like to do the query above using ODBC direct or something 
from Visual Basic, resulting in a byte array or something containing the wkb 
streams. I recon it will be faster to use this method than parsing/writing 
WKT strings on the client.

If this works I plan to write some AutoCad Map VBA classes that read and 
write GIS data from a PostgreSQL system.

Any comments?

regards,
Erik Brenn
Senior consultant
Blom International




_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of
VeriSign's FREE Guide "Securing Your Web Site for Business." Get it now!
http://www.verisign.com/cgi-bin/go.cgi?a=n094442340008000
http://us.click.yahoo.com/6lIgYB/IWxCAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/