English Boards > Support

Multiple terminals, own reports

<< < (2/2)

lemmings:
Just ran a second setup of SQL Server on my test machine and called it SambaPos2 - but it consumes extra RAM  - so I hope your hardware is up to it ?

I was able to access it via a second version of SambaPOS v2.99 running on my laptop (after changing the connection string) and it does work.

I have not fully tested but SambaPos starts up on both machines and they access there separate databases, so in theory you should be able to accomplish what you are trying to do ?

Good Luck

JohnS:

--- Quote from: lemmings on October 08, 2013, 05:37:34 am ---You can add another database to an SQL instance but I dont think that will work as Im sure the database name is hardcoded so it will not be possible to refer to both databases from SambaPos.

--- End quote ---
Using a separate SQL Instance will work. Yes the DB name is hardcoded.
Use on one terminal
data source=MyPC\INSTANCE1; User Id=sa; Password=password1234
and on the other
data source=MyPC\INSTANCE2; User Id=sa; Password=password1234


--- Quote from: lemmings on October 08, 2013, 05:37:34 am ---I will give it a try with my test set up but I think you will probably end up installing SQL Express on both terminals - thats of course if they are both have Windows OS ?

--- End quote ---
Having SQL Express only on one computer means that computer will need to be on for the other terminal to work. I would have SQL Express on each with their own database so they can work independant.

Marco:
Thanks.

I have a dedicated server, so two db instances each with a Sambapos2 database would be possible.

Thanks a lot for the information.

I'll give it a go.

Cheers
Marco

Navigation

[0] Message Index

[*] Previous page