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

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
pali
Posts: 9
Joined: Tue Apr 11, 2006 3:44 pm
Location: Norway

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

Post by pali » Wed Jul 26, 2006 8:12 am

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
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Location: Aalst, Belgium
Contact:

Post by Janschenkel » Mon Jul 31, 2006 12:46 am

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.
Quartam Reports & PDF Library for LiveCode
www.quartam.com

Post Reply

Return to “Databases”