🚀 go-pugleaf

Graham,

When using Oracle spatial w/ADO you should definately be using
the proper Oracle OLE DB Provider with a connection string that 
would look similar too:

Provider=OraOLEDB.Oracle;Data Source=this.that.com;User
ID=user_id;Password=passwd;Persist Security Info=True;DistribTX=0

Look at your connection string to see what provider your using
with ADO.  http://technet.oracle.com has a specific download
for OLE DB Provider and I'm almost sure that ADO would not
understand the spatial column in your table with the correct
provider.  

Other than that, I always have the same problem your experiencing
if I try to use BDE on Oracle tables with spatial columns.

Rgds,

John
On Wed, 10 Oct 2001 10:10:17 +0100, "Graham Reeds"
<grahamr@omnieng.co.uk> wrote:

>> Did you install Oracle's ole db provider from http://technet.oracle.com
>for use
>> with ADO or are you using a different provider??
>
>I believe I am using the standard ADO functions that comes with Builder5.  I
>didn't install the Oracle Developer tools on my machine, a colleague did who
>happens to be away for a week.  I do have the 'OLE DB User's Guide, Release
>8.1.6' installed so I guess I do.  However I am using the ADO components
>from within Borland which appear to be the same as a machine without Oracle
>Developer Tools installed.
>
>This is becoming really annoying now as I have the data in the database but
>currently have no way of effeciently querying it and is generally holding me
>up.  I have tried explicitly using the ADOTable->GetFieldNames(); function
>but that doesn't work (same error message), and switched to the for(;;) loop
>to try and get better info on what is going on, but I guess it is the code
>hidden within the ADOTable->Active that is killing it.
>
>--
>
>Yours faithfully, Graham Reeds.
>grahamr@omnieng.co.uk | http://omnieng.co.uk/
>
>