Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maintain state using cognos

Status
Not open for further replies.

TRBLUE

Programmer
Nov 11, 2007
6
US
Im trying to use snapshot in sql 2005 this works great the only thing is if someone is in Cognos impromptu looking at a report and at the exact minute the SQL builds the new snapshot which only takes 1 minute i get the error in cognos

Driver DBMSLPCN general network error which is caused because user starts report and this creates SPID process in sql ...snapshot starts and this is deleted and the user trys to connect and the connection has been lost.

I was under the impression that it would try again to connect rather than just error out.

Is there anyway to make it try afew times before giving error.

Should i use connection string ? for this using ODBC right now...got time out to 240.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top