Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function Based Indexes and ODBC - Help!?
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! ==----- Received on Tue Sep 18 2001 - 12:36:08 CDT