Accessor is not a parameter accessor.

[Jas Sandhu]

Hi

Can anybody help me out of this problem

I m trying to fetch a field from oracle table using this Sql Command...The
same works fine when connection is opened using ODBC drivers for Oracle Or
When using Microsoft OLEDB provider for Oracle but fails when opened using
Oracle OLE DB Provider By Oracle and returns error

"Accessor is not a parameter accessor."

The Sql is

"Select To_Date(To_Char(SupplyDate,'DD-MON-YYYY')) From Customer"

I have to select to the datefield in the given format and have to convert
the Field to date again for already implemented application validations.Does
anybody have any idea.
Cheers
Jas Sandhu
DRYDEN TECHNOLOGIES

[Jas Sandhu]

[Roy Fine]

Jas,

The two conversion function calls in the select statement have the effect of
removing the fractional part of the date field (remembering that Oracle
stores dates in an 8 byte double field, with the factional part signifying
the portion of the day correspondingto hours, minutes, seconds, etc. past
midnight).

You can accomplish the very same thing with the following single function
call:

"Select TRUNC(SupplyDate,'DD') From Customer"

I have the same three OLEDB drivers here (MSDAORA, tthe ODBC, and
OraOleDB.Oracle) and I will test these against the Select statement above
when I get a free moment.

regards
Roy Fine

"Jas Sandhu" <Jas.S...@Drydentech.com> wrote in message
news:#Q7UOoTECHA.1696@tkmsftngp05...

[Yuancai (Charlie) Ye]

Hi,
Post your code here, and someone may help you out.

--
Yuancai (Charlie) Ye
Use of free SocketPro package for creating super client and server
application,
and 30 OLEDB examples at http://www.udaparts.com

"Jas Sandhu" <Jas.S...@Drydentech.com> wrote in message

news:uwYegoTECHA.1128@tkmsftngp02...