Article View: borland.public.cppbuilder.database.ado
Article #4758Re: Reading back Field Names that use MDSYS.SDO_GEOMETRY data type
From: Graham Reeds
Date: Mon, 15 Oct 2001 10:56
Date: Mon, 15 Oct 2001 10:56
30 lines
2129 bytes
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!dnewsReferences:
<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