Rafael,
This will work on SQL Server 2008 and if you make the cServer_Name
"192.168.1.1\SQLEXPRESS" then it will work for SQL Express servers.
cUser="sa"
cPassword="sa"
cServer_Name="192.168.0.1"
cDB_Name="Data" && DBC Container Name Here
cConnection_String="Driver={SQL Server};" ;
+"Pwd="+cPassword+";" ;
+"Persist Security Info=True;" ;
+"UID="+cUser +";" ;
+"Database="+cDB_Name+";" ;
+"Server="+cServer_Name+";" ;
+"Trusted_Connection=No"
Dave C
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of Rafael Copquin
Sent: 19 July 2010 15:24
To: ProFox Email List
Subject: VFP and SQL (was Large Data Tables)
>Alternatively you could consider hosting the SQL server at your own
>company or by 3rd party remotely and have each client hit that one
>server ( or partition into several if one would be overloaded ), and
>simply have the application use different databases for each client
>to insure data security.
I am still trying to learn how to connect the head office with a remote
store, WITHOUT USING A VPN. (I know this is not a sound alternative
because of the security issues, discussed already many times in this forum.
However, I wish I new how to make the connection and what to set up in
the server to enable the store to enter its daily sales info into the
SQL Server directly.
Can anybody change the following local connection string to enable a
remote connection?
[DRIVER=SQL Server Native Client
10.0;SERVER=RAFAEL\SQLEXPRESS;UID=;Trusted_Connection=Yes;APP=Microsoft
Visual FoxPro;WSID=RAFAEL;DATABASE=mytest;LANGUAGE=Español;]
Details:
The head office SQL Server is installed in a Windows 2008 server
The W2008 server is accessed internally through a LAN
The VFP app is Client/server
The store also has a Windows 2008 server. The local LAN serves a number
of Windows 7 machines, running a VFP application based on DBF's
The need is to have the store connect at certain intervals (ususally
every two hours) with the HO and dump its sales data into the HO SQL Server
How should the above connection string be rewritten. Please do not refer
me to www.connectionstrings.com. I have been there, and can't make their
examples work
Thank you all
Rafael Copquin
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
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.
