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 Development (2000)
 Could not fetch a row from OLE DB provider 'SQLOLE

Author  Topic 

DrewBurlingame
Starting Member

49 Posts

Posted - 2002-06-18 : 15:51:56
I have two sql 2000 servers, running same @@Version.

They both pull data from the same linked server.

I created a function on one server that returns a result set. I copied this function to the other server, and I get the error "Could not fetch a row from OLE DB provider 'SQLOLEDB'."

Any ideas?

Thanks,
Drew

DrewBurlingame
Starting Member

49 Posts

Posted - 2002-06-18 : 15:53:08
I don't know if it matters, but I've successfully copied over several other functions that return a result set from the same linked server.

Go to Top of Page

DrewBurlingame
Starting Member

49 Posts

Posted - 2002-06-19 : 15:00:54
we reinstalled mdac 2.7, and all is fine now.

Go to Top of Page
   

- Advertisement -