?How to connect to a MYSQL db through VPN directly from Rev?

[pali]

Hi,
I connect to a MYSQL database on a remote computer through a VPN. To do this I have FIRST to use Internet Connect (I am the happy owne of an Imac G5) to hook up to the remote server by VPN and THEN to log inn to the MYSQL database through my rev project. Is there a way to do this from inside a script in Revolution? I would really like to do this connection thing in one operation. Anobody who can help?

Pali

[Janschenkel]

Hi Pali,

The VPN (Virtual Private Network) connection basically makes your computer act as if it was physically on the remote network. The network administrator forces you to go through VPN because of security issues, and has closed the MySQL port from outside access.
While you can't directly access the remote MySQL database, you could always try using AppleScript from your stack to open up the VPN connection before opening the database connection.
See these hints from Ken Ray's website, on how to use 'do ... as AppleScript' to get you started: http://www.sonsothunder.com/devres/revo ... lution.htm

Hope this helped,

Jan Schenkel.