Search results for query: *

Thanks a lot, Dave. So what you mean is: I try to install oracle client 8 on my pc and access to server oracle 7.3. Do you have any other suggestion about change the ini file?

astra1, I have mentioned the situation at Apr 2, 2003. Do you have any other idea about it?

I know. But why SQL sometimes use "LEFT OUTER JOIN", sometimes it use "(+)"?

Hi But my customer could not accept the solution of edit query one by one. The query in oracle 7.3: select T1.`Alert_Level`, T1.`Report_ID`, T1.`Subject`, T2.`Report_Type` from (`NewMessage` T1 LEFT OUTER JOIN `ReportList` T2 on T1.`Report_ID` = T2.`Report_ID`)

Hi, I use connectivity 'Oracle'instead of 'ODBC', but the problem still occur. Any other suggestion.

My situation is: I am use oracle 7.3 as backend database and cognos 6 before. When I upgrade cognos to version 7, I found those reports with outerjoin change the syntax to 'Left Outer join'. But oracle 7.3 could not understand that words! When I use cognos 6. It use '(+)' instead of 'Left...

Question about Outerjoin: I set outjoin in both Access db and oracle db, when I check the sql of both Query, it looks difference. In Access 2000: select T1.`Alert_Level`, T1.`Report_ID`, T1.`Subject`, T2.`Report_Type` from (`NewMessage` T1 LEFT OUTER JOIN `ReportList` T2 on T1.`Report_ID` =...