Re: [BUGS] Query returned unhandled type 16411

#1

Roger Merritt wrote:

Quote:

Hi,

I have tried several installs of postgresql-8.1.3-1 and postgresql-8.1.4-1,
with psqlodbc-08_02_0002.zip and PgOleDb-1.0.0.20.zip.

After each uninstall I delete the entire contents of the C:\Program
Files\PostgreSQL directory.

I am using VB6 SP6b.

My 'Connection' string is:
Provider=PostgreSQL OLE DB Provider;Password=xxxxxx;User ID=postgres;Data
Source=127.0.0.1;Location=spatial;Extended Properties=""

When the following code runs against a table with a geometry column I get
the following error:

Query returned unhandled type 16411

It looks like the odbc/ole-db drivers don't know anything about the
geometry types. That's not terribly surprising, since I don't know of
any MS-standard modeling polygons circles etc. as database objects.
Presumably any custom types you design will have the same problem too.

Hmm - it's presumably non-trivial to add type handling for the Windows
drivers without a C compiler and associated tools. Your best bet is to
contact the odbc/ole-db mailing lists and see if they have any bright
ideas. An option to handle unrecognised types as text could make sense.

It might be you can work-around the problem for the moment by accessing
a view that does the cast-to-text for the geometry columns.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Query returned unhandled type 16411

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Query returned unhandled type 16411 - 07-28-2006 , 08:55 AM