Re: Updating SQL server
On Thu, 2001-10-18 15:47:18 +1300, Andrew Hughes <Andrew.Hughes@opus.co.nz>
wrote in message <[🔎] 01C157EC.B9114660.Andrew.Hughes@opus.co.nz>:
> Hi
>
> I am wanting to set up a MySQL database on my server which I can update
> accross the internet using another free standing database like Microsoft
> access. I believe that MySQL has a addon module called MyODBC which allows
> ODBC connectivity.
>
> My Question is however,
>
> Could Microsoft access and MySQL be set up to update each other over the
> internet and if so does this produce some major security issues?
Yes, it can be done that way. I've done this via LAN, so it will
also do it's job over the internet. However, it's totally
unsecure, as long as you don't tunnle through ssh.
> Could all the requests be forwarded through an SSH tunnel?
Yes. See the MySQL documentation on how to do it.
MfG, JBG
--
Jan-Benedict Glaw . jbglaw@lug-owl.de . +49-172-7608481
Reply to: