Second line should be
set DATABASENAME=SambaPOS4.sdf
Change the first line to
@echo on
Run and post screen shot.
Ok I see part of the issue. I’ll work on it when I get home.
What version of windows are you running?
its windows XP.
Thank you so much
Replace your Clear_CE_Data.bat file contents with
@echo off
REM Set your Database name here.
set DATABASENAME=test.sdf
set DATESTAMP=%DATE:/=-%_%TIME::=-%
set DATESTAMP=%DATESTAMP: =_%
set BACKUPFILENAME=%CD%\%DATABASENAME%-%DATESTAMP%.bak
pause
echo -- BACKUP DATABASE --
copy %DATABASENAME% %BACKUPFILENAME%
echo -- CLEAR DATABASE --
SqlCeCmd40 -d "Data Source=%DATABASENAME%" -i V4_dtrans.sql
pause
Don’t forget to change your Database Name.
The error you are getting from SqlCeCmd40.exe is a .NET error. Try repairing your .NET installs through Add/Remove Programs in Control Panel. .NET 2.0 should be a problem here.
What .NET versions do you have installed?
Microsoft SQL server Compaq 4.0 ENU
Install NetFx20SP2_x86.exe
from here http://www.microsoft.com/en-au/download/details.aspx?id=1639
My guess is that SqlCeCmd40 does not like .NET 4.0 on WinXP.
Does it make a difference that I am on SP3
No. .NET 2.0 actually had its own service pack 2.
PS - echo on is just to show what the script is doing behind the scenes. Setting to echo off just hides all of the command line stuff.
It’s hard for me to test on WinXP as I don’t have any XP computers around. I run Win7/8 on my computers.
Most desktops will run Win7 if they ran XP before. It’s laptops that can be hard to upgrade to Win7, and usually it’s the wifi drivers. But I have found that vista drivers usually work.
You are a Genius that worked. Thank you so much for that. All the transactions are all gone brilliant
I’m glad we finally got it working.
So am I. Thank you so much. I do have another issue with the delivery screen but thats for another day. Once again thank you so much especially for your patients