Page 1 of 1

Connection string

Posted: Sun Jun 20, 2010 6:16 pm
by markc
When you are installing Able Commerce what is the parameters you need for the connection string.
For example what parameters would I need in the connection string below:

add key="DataConnection" value="data source=local;initial catalog=AbleCommerce;user id=sa;pwd=test99"


Thanks

Mark

Re: Connection string

Posted: Mon Jun 21, 2010 4:21 am
by mazhar
data source is your database server name, initial catalog is your database while user name and pwd are your SQL server credentials.

Here is the sample for database configurations in App_Data/database.config file

Code: Select all

<connectionStrings>
	<add name="AbleCommerce" connectionString="Server=.\SQLEXPRESS;Database=acdb;Uid=mazhar;Pwd=1234;" providerName="System.Data.SqlClient" />
</connectionStrings>