SQL 2 Oracle ole conection error

[habfan]

I am trying to save/run a new view but I am getting an error message that the object does not exist. I am getting the table to appear with all of the columns. In fact I have tried to copy the SQL statement from an existing view and am getting the same error. I can access the data in an existing view from the same table.

I am using SQL server 7 patch 3 and going against Oracle 7.

here is the sql
"SELECT *
FROM [ORACLE.].FOSPRD.PROPRIETOR"
error message when I try to save or run is "[Microsoft][ODBC SQL Server Driver][SQL ServerInvalid object name 'Oracle..FOSPRD.PROPRIETOR"

 

[sguslan]

Make sure you spell the object names with CASE SENSITIVITY in mind. I had the problem before and it had to do with case sensitivity in table names....

 

[habfan]

I have fixed that issue now it seems that I have an issue with SQL server reading a table with a function based index. I cannot find any reference to this type of issue anywhere.