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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2010-07-23 : 16:07:33
|
| Hi Group:I work with SQL 2005. Recently I had several jobs running against an Oracle Database via linked Server. I created the linked server when the Oracle Database was 9.0. Now the Oracle Database is 11g. I have upgrade the Database with the new 11g for the Client Server. I have deleted and recreated all the links. Tested all the conection and all work. Ran the scripts inside the jobs in the windows and works. HOWEVER WHEN I RUN THE JOBS THEY ALL FAILED. Anyone outhere that know the reason why and knows the solution. I have ran out of ideas and solutions. I NEED HELP.....THANK YOU. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-07-23 : 16:15:30
|
Have you checked security?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2010-07-23 : 16:19:11
|
| Thank you Peso, I haven't let me do that real quick... |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2010-07-23 : 16:36:10
|
| Executed as user: NT AUTHORITY\SYSTEM. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "GSP-DRPROD". [SQLSTATE 42000] (Error 7303) OLE DB provider "MSDASQL" for linked server "GSP-DRPROD" returned message "Specified driver could not be loaded due to system error 127 (Oracle in OraClient11g_home1).". [SQLSTATE 01000] (Error 7412). The step failed. |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2010-07-23 : 16:36:49
|
| Paso, still getting the same error....I have enclosed to you or to anyone that may have seen this before. UFFFFFffffff :( |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-23 : 17:17:32
|
| you need to modify the security for the linked server to an account that has permission |
|
|
|
jdigap
Starting Member
1 Post |
Posted - 2011-06-02 : 22:40:22
|
quote:
Originally posted by osirisa
Paso, still getting the same error....I have enclosed to you or to anyone that may have seen this before. UFFFFFffffff :(
Hi osirisa, I am getting the same error when my .asp program runs. I have installed new oracle 11g and now am getting this problem. Any solution? |
|
|
|
|
|
|
Maybe someone encounter the same problem