Ssl Vba

[recarv]

I've got a VBA application that uses a mySQL server and I am not thrilled with sending information back and forth in the open.

I know that mySQL can be configured to use SSL, but I haven't been able to find any information about whether its possible for VBA to use SSL as well.

Can anyone help me?

[recarv]

Ok,

So I answered my first question - that is don't worry about SSL with mySQL because if your intent is simply to encrypt your data set up an SSH server on the mySQL host (easy if its a *nix box) and then get a program like plink.exe (puTTY command line version) and use SSH port forwarding to send mySQL data to the remote host.

So, my next question is this: I launch plink.exe which enables the forwarding using a Shell() call. It then quietly does its job in the background.

However, when I close out of the VBA program, how can I kill the plink.exe instance I started before?

If I don't kill the instance and the VBA program is restarted weird things happen.

Thanks in advance

[BrianB]

Presumably with Sendkeys (?) Alt +F4 or whatever it needs.

Might need API GetWindow() to activate it first or find Hwnd on opening & store.