Re: TADO table open exception

Hi,

"Alan" <alanpltse@xxxxxxxxxxxx> escribió en el mensaje
news:425ca7ef@xxxxxxxxxxxxxxxxxxxxxxxxx
> We have an application use Access as database working nicely.
> Recently we changed the database to Oracle, we got the ODBC and tested at
> design time that the data can be loaded to a dbgrid by opening the TADO
> table.

Why are you using ODBC and ADO together? You're adding an extra layer which
is not necessary. Oracle has its own OLE DB provider which AFAICR is
included with Delphi

> But I got an exception"Invalid operation pointer' at run time when open
> the ado table component.
>

How does your connection string look like?

--
Best regards :)

Guillem Vicens
Dep. informática Green Service SA
guillemvicens@xxxxxxxxxxxxxxxxxx
www.clubgreenoasis.com


.

Relevant Pages

  • ADO.NET and ODBC { CALL ..... } Syntax
    ... Coonecting to Oracle 8i DB running on Unix ... ADO is used as connecting mechanism ... OleDB connection with provider as MSDAORA. ... Especially the using ODBC Call syntax to fetch the data either via Stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OO4O 2.1 vs MDAC
    ... We're planning to move VB3 using OO4O 2.1 ... Now I must distinguish and list out some of the features that ADO / ... (OLE DB or ODBC) ... Also you don't mention the Oracle version there are differences between ...
    (microsoft.public.data.ado)
  • Re: Data modelling tool - Seeking for recommendations
    ... I tried using ODBC, ADO, and several drivers to import into the ORACLE8 target. ... Your best bet on reverse engineering Oracle would be to extract ... SQL script into file and then reverse engineer the script. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Ado Oracle Performance
    ... > seconds while the same query thru sql explorer using the same ODBC ... > connection completes in 1-2 seconds. ... > Is ADO that slow or are there properties/ cache that i need to set. ... Instead of using ODBC use the Oracle ...
    (borland.public.delphi.database.ado)
  • TADO table open exception
    ... Recently we changed the database to Oracle, we got the ODBC and tested at ... design time that the data can be loaded to a dbgrid by opening the TADO ... ado table component. ...
    (borland.public.delphi.database.ado)