[Oledb-dev] No binary output function available

[Shachar Shemesh]

Clay, Bruce wrote:

> I am getting the same message that Uwe Seher mentioned back on 11 May.
>
> I am using a combination of PostgreSql 8.0.3, postgis (version 
> provided in the PostgreSql 8.0.3 installer) and what I believe to be 
> the current PgOleDb dll.
>
> I have loaded a few databases in PostgreSql and I can see the table 
> names in ArcCatalog after I make an OLE DB connection.
>
> Two problems show up but I can not say at which level of the process 
> they occur.
>
> The first is as the title says one that says:
>
> Failed to edit the selected object(s)
>
> General Function failure
>
> ERROR: no binary output function available for type geometry
>
> Fatal error in query.
>
> The standard tables used by template1 all seem to open ok but the 
> table that has the actual data fails with the above error message
>
I'll offer you a deal. You forward the message I tried to send to the 
postgis mailing list and couldn't (I'm not subscribed, and I don't have 
the bandwidth to subscribe to yet another mailing list), and to carry 
out the discussion on my behalf there, and I'll try to solve this one, ok?

> The second problem I encountered seems to be one of case sensitivity. 
> If a table has uppercase letters such as VE_SubProv I get the 
> following error message
>
> Failed to edit the selected object(s)
>
> General Function failure
>
> ERROR: relation “public.ve_subprov” does not exist.
>
> Fatal error on query
>
What usage type? What commands were you using?

Please forward the following email to the postgis list.

> Hi all,
>
> Please include me in the CC of all replies, as I'm not subscribed to 
> the list.
>
> I am the maintainer of PgOleDb (http://pgfoundry.org/projects/oledb), 
> the OLE DB provider for PostgreSQL. This driver is beginning to 
> mature, and we are starting to get questions on the PgOleDb list about 
> PostGIS support. As I know nothing about it, I'm asking here.
>
> Personally, I don't really care one way or the other, so if anyone 
> here wants PostGIS support in PgOleDb, you will have to do at least 
> some of the work. Most important is giving a concise list of all data 
> types that PostGIS adds to PG, and how Windows program typically 
> expect to receive them (when expecting binary returns). If a 
> translation is required between the way PG usually exports it, and the 
> way OLE DB is expected to return it, small code doing the actual 
> translation would be GREATLY appreciated (PgOleDb is under the LGPL, 
> so whatever code you provide must be under a LGPL compatible license).
>
> More worrying, I have a question on the list 
> (http://lists.pgfoundry.org/pipermail/oledb-devel/2005-May/000301.html) 
> which suggest that some of the GIS types don't have binary exports 
> functions. This is a bug in the type, and PgOleDb cannot be expected 
> to solve it. Like I said above, I am not a GIS user myself, and I 
> therefor don't know anything about it. I tried to find the SQL 
> instructions for installing support for the GIS type, and couldn't 
> even locate them (I seem to need to grab lwpostgis.sql from somewhere, 
> but it doesn't seem to be in neither PostGIS nor PostgreSQL source 
> distributions).
>
> Shachar


-- 
Shachar Shemesh
Lingnu Open Source Consulting ltd.
Have you backed up today's work? http://www.lingnu.com/backup.html