4 Antworten zu diesem Thema

[Ammar Ahmed]

Hi Admin, it's a great product you have created, I am using it and i am new here, I want to  connect database and want to see tables but till i am not able to connect with SQL server.
That is AppData/Setting.txt file:

AppVersion: 2.2.1.0

DataProvider: sqlce

DataConnectionString: Data Source=|DataDirectory|\SmartStore.Db.sdf;Persist Security Info=False
How can i connect to database with this "Setting.txt" file 
Thanks

[Artar]

Hello Ammar Ahmed,

 

you are using sql server compact. In my Sql Server 2008 Management Studio i have this option to open sql server compact files:

 

 

 

 

[Ammar Ahmed]

Hi @Admin Thanks for your prompt reply i am using Microsoft SQL server Management studio 2012 and i am trying to connect it locally on my system, from where  can i get the connection string,Username and password as there is no connection string in web.config file

[Artar]

To open a sql server compact file, you need only the filename/filepath from data source in settings txt.

 

You can also open a sdf-file in visual studio in the server explorer:

 

[Ammar Ahmed]

Thanks all done