Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintain lowest value in an "external connection" cell | Excel Worksheet Functions | |||
Disabling the "&[Time]" or "&[T]" in Excel headers and footers | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
"WinForm Application" to act as "RTD Server" using .Net | Excel Discussion (Misc queries) |