Re: SSH Tunnel from Access - WeOnlyDo Discussion board

Re: SSH Tunnel from Access (General questions)

by mrfurious, Wednesday, March 22, 2006, 14:38 (6824 days ago) @ wodSupport

I did set Allow = True inside the UserConnecting event and put a Debug.Print to print a message to the immediate window. If I have another instance of Access running that uses the tunnel, it works great. I can see the message coming to the immediate window. However, it doesn't work within the current instance. No message is posted to the immediate window and Access seems to hang.

Basically, I'm using a startup form to setup the tunnel when the database is opened. This form contains all of the code to setup the tunnel and handle the UserConnecting event. However, it seems to get blocked on something as the application just hangs when I try to open one of the ODBC linked tables that is using the tunnel.

Does that help at all? I'd be happy to send a sample if you have a MySQL connection you can access over SSH.

Thanks for the quick reply.


Complete thread: