Unable to run backups in PixelPos Published
The PixelPoint Database BackUp system may experience problems if you attempt to back up a database that was created on an operating system using different regional settings. For example, if a database is created on a system running Windows in English and is then transferred to a system running Windows in French, then the following
[MaxDelayTime] - Could not convert variant of type (OleStr) into type (Double).
error may occur when running the server component (PixelBackUpServer.exe) to back up the database:
The fix is to run the following in one of the SQL server tools in C:\Program Files (x86)\SQL Anywhere 10\win32, after first closing PixelBackup Manager;
Drop table PixelBackupCodes
Drop table PixelBackupEventLog
Drop table PixelBackupExecData
Drop table PixelBackupMiscData
Drop table PixelBackupPlan
Drop table PixelBackupSetup
Drop procedure PixeBackupGetNextID
And then restart the PixelBackup manager program.