Oledb Error Message: Idispatch Error #3121 Query Timeout Follow
I am trying to generate print preview within BarTender 10.1 SR2 EA application which is installed on a Middle-ware server. The BarTender document is connected to an SQL database which is hosted on another server (PFA DB_Conn_Setup_Options.png) through an OLEDB connection. I am running a stored procedure (PFA DB_Conn_Setup_SQL.png) which returns a recordset of 100 within 16 seconds when directly run on SQL server, but throws an OLEDB IDispatch Error #3121 (PFA Error.png) when executed through BarTender.
Is there a way I can set the connection time-out on BarTender? I have tried doing so from Database Connection Setup -> Options -> Setup -> Advanced -> Connect Timeout, but the value is not saved.
Am I missing something here?
Thank you in advance :)
Please sign in to leave a comment.