Connection string

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
markc
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 24
Joined: Thu Jun 10, 2010 6:28 pm

Connection string

Post by markc » Sun Jun 20, 2010 6:16 pm

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

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Connection string

Post by mazhar » Mon Jun 21, 2010 4:21 am

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>

Post Reply