View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joaovtt[_2_] joaovtt[_2_] is offline
external usenet poster
 
Posts: 1
Default 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