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; | |
|
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 ?
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.
<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.