Knowledgebase: MSSQL
How to connect to MSSQL remotely using Visual FoxPro
Posted by on 21 December 2010 04:19 PM

Upon assisting a customer with this, the following connection string worked fine on a Windows 7, Visual Fox Pro 9.0 setup -

 

DRIVER=SQL Server Native Client 10.0;SERVER=SERVER.arvixe.com;UID=myuserid;PWD=mypassword;APP=Microsoft Visual FoxPro;DATABASE=mydatabase;

Where SERVER is the name of the server you are on (based on the email that you received) and
myuserid, mypassword and mydatabase are outlined from within your control panel under the Databases section
(6 vote(s))
Helpful
Not helpful

Comments (2)
Wilson lim
18 January 2011 08:09 PM
I am going to purchase personal ASP account, i must ensure that:
when installing NOP 1.90 manually, how can i get a connectionstring and
put it into configure file before this installation, secondly do supporting the publishing NOP into your web through the MS Visual studio 2010 ?
Arvand Sabetian
31 January 2011 01:38 AM
You would simply use the following type of connection string in your nopcommerce config file -
<connectionStrings>
<add name="NopSqlConnection" connectionString="Data Source=sql2k802.discountasp.net;Initial Catalog=DBNAME;User ID=DBUSERID;Password=DBUSERPW;Integrated Security=FALSE;Persist Security Info=False;Connect Timeout=120" />
</connectionStrings>

You would specify the db name, db username and password when creating them through the control panel.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).