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
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
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;}
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