Whil Hentzen (Pro*) wrote:
When you say 'other machines', you mean client machines accessing the
MySQL server at your customer? If so, yes, well, sorta.
m.liH=sqlstringconnect("DRIVER={MySQL ODBC 3.51
Driver};SERVER=192.168.1.12;UID=bob;PWD=superdupersecret")
You'll also have to have the MySQL server set up to allow connections
from the IP address/account, but you knew that, right?
Yep...knew that.
As far as 'automatically', it depends on where you've got your
SQLCONNECT string in the app. If the IP address in the SQLCONNECT is
data driven, which it oughta be, then you should be able to change it
just like anything else that you'd change remotely.
Yes, I use a separate sqlconnect string, taking Bob Lee's example from
years ago and housing it externally in a file that gets read with FILETOSTR.
You should be able to access the MySQL server at your customer's site
remotely, as long as they've set it up to allow you access from your
host/ip.
Yeah, I'd like remote connection, but currently that's not set up.
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
