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 |
|
kowani1
Starting Member
42 Posts |
 Posted - 2007-08-20 : 05:01:39
|
| Hi All,All my Linked Servers using both the Oracle Provider for OLE Db and Microsoft OLE DB Provider for Oracle both stop working and returned error 7399.I have an Oracle 9i DB which I am trying to connect to. Am running SQL Server SP4 and have Oracle 9i client installed with Oracle Client 92040 Patch.Please help as I URGENTLY need to resolved this for our Oracle nightly jobs in SQL.Thanks.Jungle DBA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 23:20:38
|
| Does sql service account have permission in Oracle? |
 |
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-08-21 : 01:26:10
|
| I was able to resolve this issue by appying a Oracle OLEDB patch I sent to me by Metalink. All my linked servers are working now. |
|
|
|
|
|
|
Link Server Error 7399: OLE Db provider 'oraOLEDB'