Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQLOLEDB Timeouts; setting from Excel
I have a rather long list of ip addresses that are clients attached to my SQL
server. I am using excel to build a connection string and verify that the address is a good connection. When the connect is good. The Select query then runs and returns the info in a fraction of a second. The problem is that the address that do not connect... take at least 30-45 seconds each before an error message is generated. Set cn = CreateObject("ADODB.Connection") cn.CommandTimeout = 1 cn.ConnectionTimeout = 1 ... other connection property info ... cn.open I believe those commands are supposed to generate an error after 1 second has passed if the connection has not been established. Well it still takes 30-45 seconds before the error is returned. With many addresses to test this can take more than 30minutes to test the addresses. What do I need to do to force the ipaddress to fail move quickly? (since the problem I have to fix, is that the PC pointed to by the ipaddress, in 99.9% of the cases does not have the correct port opened up through its firewall) I need a way to generate the spreadsheet more quickly to get to the list of PC's that need this done. -- Regards, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting default filter setting | Charts and Charting in Excel | |||
Setting Tab in Excel | Excel Discussion (Misc queries) | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
VBA Setting .Value to a date does not respect local system setting | Excel Programming | |||
Sending email via macro- setting the importance setting. | Excel Programming |