MB Software Solutions wrote:
Ok, I've got it working great on my machine. Now it's time to deploy it. With VFP tables and SDT, it's a piece of cake. This is my first MySQL distribution (...in the past, I've hosted them on my website, so it was already setup.) This time, the client will host the database on one of their machines.
Since no one else bit, I guess I'll try. "I understand the words, but not the sentences." For other machines, is it simply a matter of
specifying the MySQL hosting computer's IP address in the host name? Any way to do this automatically (i.e., I don't want to go onsite just to do this if I can avoid it!)??
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?
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.
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.
Whil _______________________________________________ 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.
