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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 msdora reported an error

Author  Topic 

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-11-23 : 07:11:23
Dear All

I have connected the oracle srever thru Sp_addlinkedsrvlogin

It's sucessfuly added. Now i have access any views or proc
it return the following error.

Error 3379 oledb provider "MSDORA" reported an error
what it says. can anyone able to help me..?

thanks
krishna

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-23 : 07:33:46
What did you try to do before the error appeared?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-23 : 07:33:48
What is the error text it is throwing?

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-11-23 : 07:38:28
i did Sp_helptext proc only
It returns the same error in enterprice manager also
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-23 : 08:19:30
sp_helptext creates a CURSOR.
I think is why you get an error.

Try anything else that does not include a cursor.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -