Author Topic: Check Database Version  (Read 7618 times)

jenem

  • Full Member
  • ***
  • Posts: 154
Check Database Version
« on: February 08, 2012, 02:30:34 pm »
Installed 2.86.

Installation went fine.
Entered Pin but message displayed check database .
How can I check db version without access to management settings ?

Edgar

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Check Database Version
« Reply #1 on: February 08, 2012, 03:31:55 pm »
That means application database version and SQL database version does not match. You should see DB:13-13 on application window title. Generally that happens if setup application can't upgrade database model. You can try reinstall for restarting db upgrade process...

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Check Database Version
« Reply #2 on: February 08, 2012, 03:45:08 pm »
Edgar,

Do you still have compact SQL files on your system for different user logins?

Emre,

When upgrading, does the installer look at the SambaSettings.txt file for database location, or does it look for the database files in the user directories ?
SambaPOS - POS'n the World, one Terminal at a time.

jenem

  • Full Member
  • ***
  • Posts: 154
Re: Check Database Version
« Reply #3 on: February 09, 2012, 12:21:47 am »
Hi John,

Probably yes!

I installed SQLexpress and ran 2.85 and I could see that Sambapos was still using the old sambadata2.sdf and I could run the old database.

It must be after I turned off computer that the SQLExpress server started running in background and the new sambapos 2.86 installation found that installation and the original sambadata2.sdf file.

 I can still see sambadata2.sdf file in my documnets.

Edgar

jenem

  • Full Member
  • ***
  • Posts: 154
Re: Check Database Version
« Reply #4 on: February 09, 2012, 12:40:51 am »
Hi All,

Rinstalled Sambapos 2.86 and found I can now access database. Pheww!

Now to transfer system to SQLServer 2008!

Bottom of screen shows 2.86-ce

Edgar