Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function Based Indexes and ODBC - Help!? - correction to typo

Re: Function Based Indexes and ODBC - Help!? - correction to typo

From: TurkBear <noone_at_nowhere.com>
Date: Tue, 18 Sep 2001 14:02:13 -0500
Message-ID: <md6fqtcdfkflcvvcmeps3r513t5vfm3dq7@4ax.com>

for 'indexes and 8i and later' substitute 'indexes are only supported in 8i and later'

"Brain may work without finger's knowledge - and vice versa"

TurkBear <noone_at_nowhere.com> wrote:

>Check which ODBC driver you use ( you failed to specify)
>Since Function-based indexes and 8i and later, older ODBC drivers may not 'know' about them..
>Use Oracle's 8.1.x ODBC - the Microsoft ones may not work..
>
>eric_at_salwan.com (Eric) wrote:
>
>>Hi.
>>I have created several function-based indexes in Oracle 8i. When I
>>try to link to the tables with these indexes from Microsoft Access 97
>>via ODBC I receive an error, "Invalid field definition 'SYS_NC00045$'
>>in definition of index or relationship". My only workaround is to
>>drop the indexes, link the table and re-create the index. I have not
>>been able to find any info at Oracle or Microsoft website. Does
>>anyone have any insight or know of an ODBC driver that supports
>>function based indexes?
>>
>>Thanks,
>>
>>Eric
>
>
>
>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
>-----== Over 80,000 Newsgroups - 19 Different Servers! ==-----

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Sep 18 2001 - 14:02:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US