🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4758

Re: Reading back Field Names that use MDSYS.SDO_GEOMETRY data type

#4758
From: Graham Reeds
Date: Mon, 15 Oct 2001 10:56
30 lines
2129 bytes
> I believe that DistribTX=0 is for distributed transactions across
> multiple databases.  Adding this to our connection string eliminated
> a problem we had executing a stored procedure.
Okay.  We don't need it at the moment, but I doubt it will do any harm to
leave it in.

> Another angle:  Eliminate the spatial column from your query
> (if you don't need it) before executing the query
>
> ADOTable->Active = true;  // turn it back on
>
> I was able to get around the problem in BDE as long I left
> the spatial field out of the query.

I need the spatial column - what's the point of having a spatial database if
you can't get the spatial info?

> Check the documentation for Oracle's OLE DB provider.
> Maybe there are known problems with spatial fields??

I've installed 8.1.7.2.0, upgrading from 8.1.6.0.0 to no avail.  Do you have
a small snippet of code that works - maybe it is some other part of the code
that I've overlooked?  That would be the biggest help.

> Good Luck!!

Thanks - I need it:-)

Yurs faithfully, Graham Reeds.
grahamr@omnieng.co.uk | http://omnieng.co.uk/
Technical Details
Message-ID: <3bcac0ce_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews
References: <3bc2f3f4_1@dnews> <3BC37F6C.27A981AF@airtalk.com> <3bc410f0_2@dnews> <3bc5bd74.7044877@newsgroups.borland.com> <3bc6bad4_1@dnews> <3bc6e1c1.753117@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,96caeb4bff8ec055
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-10-15 04:00:53 PST
From: "Graham Reeds" <grahamr@omnieng.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3bc2f3f4_1@dnews> <3BC37F6C.27A981AF@airtalk.com> <3bc410f0_2@dnews> <3bc5bd74.7044877@newsgroups.borland.com> <3bc6bad4_1@dnews> <3bc6e1c1.753117@newsgroups.borland.com>
Subject: Re: Reading back Field Names that use MDSYS.SDO_GEOMETRY data type
Date: Mon, 15 Oct 2001 11:56:11 +0100
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 212.172.148.2
Message-ID: <3bcac0ce_2@dnews>
X-Trace: dnews 1003143374 212.172.148.2 (15 Oct 2001 03:56:14 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews