Connection with SQL Server - "time exceed"

[joaovtt]

Hi All,

I created a macro in my workbook that send some informatios to a
database in SQL Server and execute some operations in it. When I
execute a DELETE, after some time I receive an error message ("time
execeed"), and the macro stops.

I already changed the parameters to the OLEDB connection:
- Connect Timeout = 3000
- Connection Lifetime = 600

But I continue receiving the same error message.

Anybody can help me?

Best regards,
JV.

 

[DM Unseen]

Create a stored procedure when possible and execute that (depends on
what you are doing) This will rule performance and maintenance wise

DM Unseen