Click here to Skip to main content
15,885,091 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: VB Connection String with MS Access - By using MAC address instead of IP Address Pin
Christian Graus9-Apr-08 0:34
protectorChristian Graus9-Apr-08 0:34 
GeneralRe: VB Connection String with MS Access - By using MAC address instead of IP Address Pin
Steven J Jowett9-Apr-08 0:42
Steven J Jowett9-Apr-08 0:42 
GeneralRe: VB Connection String with MS Access - By using MAC address instead of IP Address Pin
aaraaayen9-Apr-08 1:09
aaraaayen9-Apr-08 1:09 
GeneralRe: VB Connection String with MS Access - By using MAC address instead of IP Address Pin
Dave Kreskowiak9-Apr-08 5:25
mveDave Kreskowiak9-Apr-08 5:25 
GeneralThread Pooling Pin
Mycroft Holmes8-Apr-08 22:56
professionalMycroft Holmes8-Apr-08 22:56 
GeneralRe: Thread Pooling Pin
Dave Kreskowiak9-Apr-08 5:27
mveDave Kreskowiak9-Apr-08 5:27 
GeneralRe: Thread Pooling Pin
Mycroft Holmes9-Apr-08 12:39
professionalMycroft Holmes9-Apr-08 12:39 
GeneralRe: Thread Pooling Pin
Dave Kreskowiak9-Apr-08 14:54
mveDave Kreskowiak9-Apr-08 14:54 
OK. In that case, I'd have a couple of threads running that take jobs out of a task queue and execute execute them on the SQL Server. The problem with the 90 minute job is that the connection will timeout before the stored proc gets around to returning. But, I wouldn't have this queue on the client side. I'd probably have a service component running on the SQL Server machine that manages the queue and executes jobs from it. Having your client side app executing the jobs is problematic if the client gets disconnected from the server or locks up unexpectedly. The problem then becomes how do you recover from such a situation??


A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008




GeneralRe: Thread Pooling Pin
Mycroft Holmes9-Apr-08 16:52
professionalMycroft Holmes9-Apr-08 16:52 
GeneralRe: Thread Pooling Pin
Mark Churchill9-Apr-08 21:28
Mark Churchill9-Apr-08 21:28 
GeneralRe: Thread Pooling Pin
Mycroft Holmes9-Apr-08 22:47
professionalMycroft Holmes9-Apr-08 22:47 
GeneralFind my dll's Pin
helelark1238-Apr-08 22:06
helelark1238-Apr-08 22:06 
QuestionProcess Naming Pin
Maffyx8-Apr-08 18:28
Maffyx8-Apr-08 18:28 
GeneralRe: Process Naming Pin
Dave Kreskowiak9-Apr-08 2:34
mveDave Kreskowiak9-Apr-08 2:34 
GeneralRe: Process Naming Pin
Maffyx9-Apr-08 4:47
Maffyx9-Apr-08 4:47 
GeneralRe: Process Naming Pin
Dave Kreskowiak9-Apr-08 5:03
mveDave Kreskowiak9-Apr-08 5:03 
GeneralRe: Process Naming Pin
Maffyx9-Apr-08 5:05
Maffyx9-Apr-08 5:05 
GeneralRe: Process Naming Pin
Dave Kreskowiak9-Apr-08 12:13
mveDave Kreskowiak9-Apr-08 12:13 
GeneralRe: Process Naming Pin
Maffyx9-Apr-08 13:36
Maffyx9-Apr-08 13:36 
GeneralRe: Process Naming Pin
Dave Kreskowiak9-Apr-08 14:47
mveDave Kreskowiak9-Apr-08 14:47 
GeneralRe: Process Naming Pin
Maffyx9-Apr-08 14:52
Maffyx9-Apr-08 14:52 
GeneralRe: Process Naming Pin
Dave Kreskowiak10-Apr-08 1:40
mveDave Kreskowiak10-Apr-08 1:40 
GeneralRe: Process Naming Pin
Maffyx10-Apr-08 5:49
Maffyx10-Apr-08 5:49 
GeneralRe: Process Naming Pin
Dave Kreskowiak10-Apr-08 12:32
mveDave Kreskowiak10-Apr-08 12:32 
GeneralRe: Process Naming Pin
Maffyx10-Apr-08 12:51
Maffyx10-Apr-08 12:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.