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.
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.