Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Err While accesing table with 0 rows via linkedsvr

Author  Topic 

kgundava
Yak Posting Veteran

66 Posts

Posted - 2011-07-07 : 18:27:48
Hi All,
I am using SQL server 2008 to access the data in oracle data base via Linked server(Microsoft OLEDB provider for Oracle). Every thing is working fine except for a particular which has 0 records.when i do a select * from query , i get this error
OLE DB provider "MSDAORA" for linked server "DBNAME" returned message "ORA-01476: divisor is equal to zero


Please help me in fixing this.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-07-07 : 18:46:40
Duplicate post. No replies to this thread please. Direct replies to:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=162729[/url]

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -