Syed's picture
Nov 07, 2013
12667 views
Reputation: 23
+1
-29 likes
-1

How to Install Samba Database?

Hi

I am new to SambaPOS and trying to install it on local machine, I have been looking at ways to setup database on local machine and my question is where to find physical database file SambaPOS3.MDF (e.g.Data Source=.\SQLEXPRESS;Initial Catalog=SambaPOS3;).

I have found an article on SambaPOS that how to install SQL server but it does not say where to download database from. http://sambapos.org/wiki/doku.php/en/installing_sql_express_2012_for_sam...

I already have an installed Local SQL version (Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) ) and hoping to deploy SambaPOS3.MDF database on same server but I dont find database file anywhere in source. Also any Developer Guide on how to setup SambaPOS/Database will be helpfull.

 

Thanks in Advance for your help

3 answers

evail's picture
evail
Nov 07, 2013
Reputation: 78
+1
-14 likes
-1

in SambaPos>Manage>Settings>Local Settings

in Data Connection String type in the following without "

"Data source=localhost\SQLEXPRESS"

this should create sql database for SambaPos.

Hi Evail

Thanks for your quick response.

The issue I have is SambaPOS fails before starting so I don’t get to see interfaceJ (SambaPos>Manage>Settings>Local Settings) I am trying to install V3 and have downloaded latest version from git last night and I have changed the connection setting in Samba.Modules.AccountModule\Properties\Settings.settings to point to my local server. I also installed new version of SQL express 2012 following SAMBAPOS instruction but no luck so far.

I can build the code without any error but when I try to run code in release or debug mode I get table not found error please see attachment.

 

Thanks

Hi Evail

Thanks for your quick response.

The issue I have is SambaPOS fails before starting so I don’t get to see interfaceJ (SambaPos>Manage>Settings>Local Settings) I am trying to install V3 and have downloaded latest version from git last night and I have changed the connection setting in Samba.Modules.AccountModule\Properties\Settings.settings to point to my local server. I also installed new version of SQL express 2012 following SAMBAPOS instruction but no luck so far.

I can build the code without any error but when I try to run code in release or debug mode I get table not found error please see attachment.

 

Thanks

lemmings's picture
best answer
lemmings
Nov 07, 2013
Reputation: 15
+1
-5 likes
-1

You dont need to touch the code.

Download the latest version from this site.

Install. If you have set up the SQL server correctly it will run. If your connection string is incorrect you will have the chance to edit it when SambaPos fails to start.

 

Hi Lemmings

 

Thanks for your help

 

The reason of touching code, I am trying to run SambaPOS so I can contribute as a developer also I want to see how whole software works in background by debugging the solution and hopefully in future I will contribute to development of SambaPOS as a developer, I am not a restaurant owner so just running the solution is no good to me.

 

In terms of latest version, I am now trying to build and run V3 with Visual Studio 2012 and SQL Express 2012. I can build the solution without any errors only issue is that No Database on SQL server and I am trying to work out where to find SQL Database and how to deploy it to SQL server so that it works with SambaPOS application

 

 

 

Thanks

 

Syed

 

Normal
0

false
false
false

EN-GB
X-NONE
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0cm;
line-height:115%;
mso-pagination:widow-orphan;
font-size:10.0pt;
mso-bidi-font-size:11.0pt;
font-family:"Arial","sans-serif";
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}

 

Syed's picture
Syed
Nov 07, 2013
Reputation: 23
+1
+20 likes
-1

Hi All

Thanks for you help, SambaPOS uses  Compact sql which lives in dir user\Documents\SambaPOS3.

 

The reason I had problem was V3 database i had in above folder was corrupt , After I donwloaded V3 again everything works as expected.

 

Thanks

Syed

 

 

We have already answers to
848 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634