On Thu, Feb 5, 2009 at 4:37 AM, Rafael Copquin <[email protected]> wrote: > Thank you Rick. I thought of that, too, and it seems like a good idea. > However, I still want to know how to connect directly, ie, a branch computer > accessing the server via the internet, with no VNC. > > > In my local machine I use the following connection string: > > cConnString = 'Driver={SQL Native > Client};Server=RAFAELPC\SQLEXPRESS;Database=datos;Trusted_Connection=yes') ---------------------
Get rid of the trusted connection! Please set up a user in the DB with rights for Read / Write /execute SP. Q for you FP guys. Can you read the Config.FPW file from your application via a function within VFP? Or is it just read at the start up if present and never considered again? I forget, sorry. If you can then I would encrypt my connection string there, and read it as needed for the app to run. Otherwise you coudl use an INI file for the same purpose. -- Stephen Russell Sr. Production Systems Programmer First Horizon Bank Memphis TN 901.246-0159 _______________________________________________ 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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
