SambaPOS Database Configuration


#141

Ok, Thanks but could it also be the cause of having the instance in windows authentication?

Thanks


#142

No windows authentication works just fine. But its expected it will not work with other computers on the network unless you specifically tell it too.

I use windows authentication simply because I dont want or need to setup separate logins and passwords… just using windows logins is easier. Some people prefer mixed mode so they can define their own users etc.


#143

Thanks Ken,

I have been able to connect from client PC by creating login for client PC. Now am confronted with these issues;

  1. Order placed from client PC not printing to kitchen and Bar although printers are shared with full control permissions
  2. Pictures uploaded into categories not showing on client PC although pictures folder are placed in public folder and also shared with full control permission

Would these be solved if i switch from “Work Network” to “Public Network” ?

Thanks to all for your prompt support


#144

The way to test both of these issues is to simply “use” your network.

For example, from the Client, navigate to Network, then ServerPC, then to the shared Images folder, then click on a picture to open/display it. If you are not successful using this method, you have a permissions issue that you need to correct, and changing the Network Type might help.


#145

Thanks Kay,

I have opened the pictures and issued test prints as well. They worked but not from Samba

Trying change of network type

Many Thanks


#146

You may need to map the network drive on the client PC. A better approach is simply copy pics to client PC.


#147

Thanks Ken,

I picked the pictures and the printers from network/server-pc/picture or printer and all worked

Thanks Again for the help


#148

On the Client, you may need to change the path to the Printers within SambaPOS.

For example, in Printers, you need to type:

\\ServerName\PrinterShareName

And for all images, you should map a drive on the Client that is the same letter as it is on the Server. So if your images are on the Server in the path:

D:\SambaPOS\Images\

Then you share the D: drive on the Server as D.
Then on the Client, map a drive called D: to the share-path:

\\ServerName\D

Then in the Menu Product Properties, the images should work the same as on the Server, for example:

D:\SambaPOS\Images\imagename.jpg

#149

Would request you to confirm if Sql Server Browser service, is up and running, i discovered mine was disabled.

Also ensure your database is logged in i would recommend using the sa account it’s easier and makes you have an easy task.


#150

Hellow Mr Emre, how can i get database for sambapos? I must create new database or what?

Thanks Mr Emre


#151

@fendy, you can refer to below link on how to configure Database setup.
http://forum.sambapos.com/t/sql-express-2014-installation-sambapos4-database-setup/3363?u=morshed1


#152

Also when you install you have the option to add sample data, this will setup a database with some products and categories for you to have a play with and start customising and building your database/pos system

There are no ‘built in’ databases for different business types its all about you building your own system with belo from the community. That said there are some ‘pre built’ databases that people on the forum have bullt themselves and shared to help others with their systems. Have a search of the forum for pre built databases and you will find some you can download and use to start you off and help you learn and understand how samba works

Hope that helps


#153

I moved a post to a new topic: Waiter Option


#154

Dear Morshed1, my device specification is:

  • Asus A46c
  • Windows 7 Ultimate 64 bit
    when i read the guide, it said that the spec is 32 bit. is this a problem for me? because i get an error

Im using sql server 2012 developer edition


#155

HI,

You should be using 64bit version of SQL.
The installation process is same for 32bit and 64bit SQL.


#156

@morshed1 , @kendash , @emre can you please tell me that how can i re design the tables in samba???


#157

You can’t. But for curiosity sake what were you wanting to do?


#158

If i setup this, does it mean we can use the same sambapos between tablet windows and pc? I mean when we key in order(restaurant) from tablet, does it send it to sambapos on pc?

And is there anyway to use the same sambapos between user account on windows? meaning if i key in order(restaurant) from user account A, then the sambapos on user account B also changing(order we took from user account A)?


#162

Those are the same what do you want us to see?


#163

second photo