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.
| Author |
Topic |
|
Piller187
Starting Member
1 Post |
 Posted - 2006-05-05 : 10:48:53
|
| All our data is on Oracle. We also have SQL Server 2000. A contractor created a reporting application. The issue is he created it in SQL Server 2000, and just imports all the data we need to run these reports each time from Oracle to SQL Server. He uses a linked server to our Oracle box and just selects from that and puts them into duplicated tables on our SQL Server box. This works about 1/2 the time and the other half of the time we get this error message:Description:[OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]:We then have to restart the SQL Server service to get it to work again. This is almost a dailyl occurence.I was wondering if anyone out there has ever ran into this and if they have some suggestions. Thanks. |
|
|
|
|
|
Linked Server to Oracle issues