| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collectiong data from SQL server / Repeat!
Hi I am using an macro to collect data from an SQL server, the problem I
have is if the server is locked "usally by someone connecting using access" Iget an error massage saying that the SQL server is locked please try again. is there a way of capturing this error and getting the macro to run the last step? Cheers Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Collectiong data from SQL server / Repeat!
Usually, a SQL connection has a timeout associated with it. Can you
set the timout to a large number? Or, if you are sure you will eventually connect, specify 'forever' as the timeout interval? -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi I am using an macro to collect data from an SQL server, the problem I have is if the server is locked "usally by someone connecting using access" Iget an error massage saying that the SQL server is locked please try again. is there a way of capturing this error and getting the macro to run the last step? Cheers Mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Collectiong data from SQL server / Repeat!
Hmmm
I don't state a timeout "time" so I am unsure, what tends to happen it it's not a timeout but more of a bugger off this is locked / blocked try later. I know that the guys who use access to connect cos they can't / don't know hoe to use pass through queries are at fault but I have no way of stopping them as it's there server :o( Mark "Tushar Mehta" wrote in message om... Usually, a SQL connection has a timeout associated with it. Can you set the timout to a large number? Or, if you are sure you will eventually connect, specify 'forever' as the timeout interval? -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi I am using an macro to collect data from an SQL server, the problem I have is if the server is locked "usally by someone connecting using access" Iget an error massage saying that the SQL server is locked please try again. is there a way of capturing this error and getting the macro to run the last step? Cheers Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to import data from SQL Server | Excel Discussion (Misc queries) | |||
| SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
| Best way to get data out of SQL Server | Excel Programming | |||
Hybrid Mode
