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 |
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
 Posted - 2010-08-02 : 21:09:58
|
| I am currently working on sql server2008 and trying to fetch data from oracle 10.2 . when i right click on my linked server and click test connection it is success. Also when i m trying to fetch data my open query then also its is working . but when i am working ir with a procedure it works half the way and then give error timeout ORA-12170 error. Same procedure is working on sql server 2005 . data is very large and it takes 30 minutes minimum is this a problem. i have oracle also in providers.and checked active inprocess. I am not able to get out of this issue.scoo |
|
|
davidth
Starting Member
5 Posts |
Posted - 2010-08-03 : 03:58:52
|
| this error is cause for excceded time out in oracle. you can enable more time to connections |
 |
|
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
Posted - 2010-08-04 : 02:22:48
|
where to enable time in sql or oracle and how.?quote:
Originally posted by davidth
this error is cause for excceded time out in oracle. you can enable more time to connections
scoo |
|
|
|
|
|
|
Linked server issue