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 |
|
kgundava
Yak Posting Veteran
66 Posts |
 Posted - 2011-08-27 : 11:06:18
|
| HI All,We have attunity connect(5.3.0) installed on our windows 2008 server(32 Bit).This attnity connect(middle ware) was installed along with IBM Optim(7.1.2).As we wanted to access the IBM OPTIM archive files from the sql server we went ahead and created a data source in nav binding.For this we also created a ODBC data source. Now we went ahead and created a linked server in the SQL server 2008 R2.For some reason this works fine in our dev,UAT server but on prod we loose connection intermittently.The sql linked server throws the following error.OLE DB provider "MSDASQL" for linked server "PRCSAPARCOL" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".OLE DB provider "MSDASQL" for linked server "PRCSAPARCOL" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".OLE DB provider "MSDASQL" for linked server "PRCSAPARCOL" returned message "[C066] Communication error with the server PRCSAP_ARCOL.".Msg 7303, Level 16, State 1, Line 25Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "PRCSAPARCOL".Please let me know how to fix this issue and is there some setting with in sql server which is causing this.The connection lost happens after a expensive query.This is a very very urgent issue for us, i am already in contact with IBM folks and they are working on it .It would be helpful if any one can provide more info..............THanks.......... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-28 : 01:44:28
|
| i think it might be the timeout issue. can you increase the timeout period?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kgundava
Yak Posting Veteran
66 Posts |
Posted - 2011-08-28 : 19:40:04
|
| Hi Visakh, Time out is set to zero but still the issue happens :(Thanks........ |
|
|
|
|
|
|
linked server disconnecting intermittently