Re: SSH Tunnel from Access - WeOnlyDo Discussion board

Re: SSH Tunnel from Access (General questions)

by wodSupport, Wednesday, March 22, 2006, 22:47 (6820 days ago) @ mrfurious

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: