Error: Check Database Version

Version 4 V4 Question
1

i have followed all the tutorials and create a new database and restore from one of the premade databases.
I went into my sambapos and set to look at the new database
now when I try to load I get error
check database version
Database: 69 - App: 78
I want to look at how they have done this database and perhaps get a few ideas for mine.

thanks

1 Like
2

You need to install same version of sambapos that they used when they listed the db. It means you have a newer version of samba.

Once you load the db you can install latest version and it will migrate the db to new version.

Which one are you referring too?

3

Quick service tables
I can only have the latest SambaPos installed, hopefully.
and I have just installed sql 2014

4

I have downloaded the correct version of Samba and uninstalled the latest version and install this earlier one, now I get check database version

5

We do not recommend use of Compact Edition (CE).

You should use either SQL Server LocalDB or better SQL Server Express 2014.

The LocalDB version is single-user, but has a very small footprint.
The Express version is multi-user, but is a much larger installation. It also has a lot of features over LocalDB, so we generally recommend installing Express.

6

do I nned the compact sql 4.0 or sql server local as I now have adv sql express loaded?

7

You cannot upgrade or convert a CE database into a SQL database via SambaPOS installation. You must go through a conversion process first (CE > SQL), then run the install to upgrade from SQL > SQL.

NOTE: the “upgrade” that SambaPOS performs on your DB is not a version upgrade of the Database Engine. It is an “upgrade” of the SambaPOS database schema (i.e. tables/columns, performance indexes, etc).

8

That database was an older version of mine that I submitted.

You will need SambaPOS version 4.1.55
This is a SQL Express 2014 Database
Admin password =1234
Employee password =4321

BTW any questions about it I could answer since this is my database :stuck_out_tongue:

9

So you can restore that DB using SSMS, then install the latest version of SambaPOS and it will upgrade the SQL DB.

1 Like