Re: SSH Tunnel from Access (General questions)
Yes, this is blocking problem. ODBC drivers and wodSSHTunnel live in same thread. Even if they are put to separate threads, you have a problem, since VBA can accept events only in main thread, so wodSSHTunnel couldn't be able to fire them from different one.
When ODBC tries to connect, it blocks the thread. This causes wodSSHTunnel to freeze, because it cannot process (socket related) messages, and app completely hangs.
I tried to suggest possible workarounds in previous reply. This will NOT be easy for you - I think best would be if you could spawn new process for wodSSHTunnel or for ODBC. Or, if you have async ODBC drivers.
Kreso
Complete thread:
- SSH Tunnel from Access - mrfurious, 2006-03-21, 23:33
- Re: SSH Tunnel from Access - wodSupport, 2006-03-22, 12:37
- Re: SSH Tunnel from Access - mrfurious, 2006-03-22, 14:38
- Re: SSH Tunnel from Access - wodSupport, 2006-03-22, 22:47
- Re: SSH Tunnel from Access - mrfurious, 2006-03-23, 00:31
- Re: SSH Tunnel from Access - wodSupport, 2006-03-23, 00:36
- Re: SSH Tunnel from Access - mrfurious, 2006-03-23, 05:09
- Re: SSH Tunnel from Access - wodSupport, 2006-03-23, 12:04
- Re: SSH Tunnel from Access - richforman, 2006-09-29, 00:05
- Re: SSH Tunnel from Access - richforman, 2006-09-29, 00:07
- Re: SSH Tunnel from Access - mrfurious, 2006-09-29, 15:30
- Re: SSH Tunnel from Access - richforman, 2006-09-29, 17:00
- Re: SSH Tunnel from Access - mrfurious, 2006-09-29, 17:09
- Re: SSH Tunnel from Access - wodDrazen, 2006-09-29, 23:58
- Re: SSH Tunnel from Access - Chad, 2006-10-17, 18:27
- Re: SSH Tunnel from Access - wodDrazen, 2006-09-29, 23:58
- Re: SSH Tunnel from Access - mrfurious, 2006-09-29, 17:09
- Re: SSH Tunnel from Access - richforman, 2006-09-29, 17:00
- Re: SSH Tunnel from Access - mrfurious, 2006-09-29, 15:30
- Re: SSH Tunnel from Access - richforman, 2006-09-29, 00:07
- Re: SSH Tunnel from Access - richforman, 2006-09-29, 00:05
- Re: SSH Tunnel from Access - wodSupport, 2006-03-23, 12:04
- Re: SSH Tunnel from Access - mrfurious, 2006-03-23, 05:09
- Re: SSH Tunnel from Access - wodSupport, 2006-03-23, 00:36
- Re: SSH Tunnel from Access - mrfurious, 2006-03-23, 00:31
- Re: SSH Tunnel from Access - wodSupport, 2006-03-22, 22:47
- Re: SSH Tunnel from Access - mrfurious, 2006-03-22, 14:38
- Re: SSH Tunnel from Access - wodSupport, 2006-03-22, 12:37