Accidently deleted the sdf file located in documents folder SAMBAPOS5 any chances of creating a new one or do I have to reinstall samba?
Thanks
Would have expected samba would recreate new one…
I’d reconmend SQL express generally over localDB
No backups?
You realise a new database will be back to default without products and automation you have crested or transactions.
Also tutorial category is for giving tutorials not asking questions, gave changed it
Im trying to connect SQL Express tutorial as stated but when I reach the SQL Server Compact tool it says my SDF file is corrupted I should repair it. Any thoughts as Im trying to go through the steps but cannot with no SDF file
You do not need an SDF file for SQL express.
But when I try following the steps in the tutorial I need to copy a script of a sdf file and creata new database with a new querey?
Do you need data from the sdf file? If not you can skip that. Just install SQL express and connect to it using the connection string explained in that tutorial.
When you say connect to it it dosent connect saying sa username invalid
You probably need to enable mixed mode authentication and enable sa user.
Kb.sambapos.com has a better tutorial for setting up SQL express.
sa user is enables and mixed mode enabled
Show your connect string with the error in a screenshot.
okay cool will send one shortly
Sorry it worked but it completely wiped out my data, is there a way to have my data but be on SQL?
sorry for the hassle
He did say if you didn’t need your data.
So it tells you your ce database file is corrupt? Might not be a huge amount that can be done. Did samba stop working when it got corrupted?
Guess you don’t have any backup?
CE is known to corrupt easy. It’s crap and discontinued by Microsoft because they realized it was worthless.
btw see it mentioned so I wanted to clarify. CE is not localdb they are completely different versions. CE is the version that uses SDF files.
I did the data string connected but it completely wiped out my data, I have a backup but as soon as I save the connection string it reverts to the default format
okay so if i want to convert my data from LDB to SQL i would have to follow a tutorial on it? As Im tryign to connect 2 pcs but its taking ages just to do the first one. Sorry not a computer wizz just enjoy reading but its taking ages so thought i post something
It didn’t wipe out anything. Your data is in the sdf file. So now you convert it to scripts and execute them. It created a new database.
Your not using localdb. Your using ce. Now your connected to SQL express so you need to convert the CE DB to SQL and import it.