I have installed the sambaPOS v4. I have just change the database path than restart the POS. But every time I get the message - “Can’t connect to database with current setting. You can check and modify the connection string shown below”.
An SDF file is a SQL CE (compact edition) database. Your connection string in the case of CE should just be the path to the file, without “Data Source=”, for example, simply this:
You should consider upgrading to SQL Express. You will need to convert your CE (sdf) database to SQL Express (mdf). SQL CE will give you problems eventually, so the upgrade is highly recommended. Then your connection string will look different, using the “Data Source=” part.