Connection with SQL Server - "time exceed"
 

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.


--
joaovtt
------------------------------------------------------------------------
joaovtt's Profile: http://www.excelforum.com/member.php...o&userid=24286
View this thread: http://www.excelforum.com/showthread...hreadid=381710

Connection with SQL Server - "time exceed"
 

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

DM Unseen