$url = "https://website.com/getdata.php?database=dbasename&user=username&password=password&rowid=number"
$data = InetRead($url,1)
The above works well with a PHP script on the server that GETs the parameters and does a mysql query and returns the appropriate data. I'm just not sure how secure it is. I've scanned the forum and documentation for another way to acheive this, but have missed it. If it does exist, and I'm sure it does, it's bound to be less than this straightforward.
I've used WireShark to snoop the packets and found them to be encrypted. I also used ProcessExplorer to try and find anything going over the command line to ie or any other program and did not find anything.
This is a pretty easy way to get some data out of a remote database if it can be done securely. It has the benefits of not requiring any special libraries or drivers. Any info anyone can provide regarding the pros and cons of this approach would be much appreciated.