Function Based Indexes and ODBC - Help!? 
Author Message
 Function Based Indexes and ODBC - Help!?

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



Sat, 06 Mar 2004 22:36:02 GMT
 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..

Quote:

>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!  ==-----


Sun, 07 Mar 2004 01:36:08 GMT
 Function Based Indexes and ODBC - Help!?

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"

Quote:

>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..


>>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!  ==-----


Sun, 07 Mar 2004 03:02:13 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. HELP !! Function based index

2. Function based indexes and index fast full scan

3. ORA-01031 with Create Index for a Function Based Index

4. Function Based indexes in SQL Server

5. function-based index

6. Function-Based index

7. Function based index on Standard Edition

8. Function Based Indexes???

9. Function Based Index Problem

10. Function-based Index

11. function-based indexes

12. Function based index


 
Powered by phpBB® Forum Software