To solve this problem, the existing SQL server needs to be uninstalled,
then reinstalled from our dB35 CD by using the following procedure:
1 Uninstall Microsoft SQL server desktop engine from control panel >
Add/Remove Programs
2 Reboot the PC, Insert the dB35 install CD and select "Exit" to escape from the introduction screen.
3 Click - Start | Run then type "cmd" (OK) to open a DOS
window. Navigate to the CD by typing "D:" (Enter) where D is the drive
letter for the CDROM, then change to the directory: MSDE
2000A\English by typing "CD\MSDE 2000A\English" (Enter)
4 Type ".\setup SECURITYMODE=SQL SAPWD=casella" (Enter)
This should install just the SQL engine from the CD
5 Reboot the PC and the SQL server icon
should appear in system
tray (with green arrow)
6 Start dB35 and double-click the splash screen with the image of the
dBadge when it appears.
This will automatically start a new database procedure.
7 Click OK in the directory selection dialog box when it appears. A new
data base is now created and dB35 will work correctly.
There will not be any loss of functionality compared to the existing
SQL that was originally installed on the PC.
If this does not work, follow the path shown below, where ‘user name’ is
the individual pc user's own name:
8 C:\Documents and Settings\User Name\Application Data\Casella CEL
Ltd\dB35\default\data
9 Within the final ‘data’ folder will be 2 files, an .ldf and an .mdf
file, delete both of them. Then open dB35 as normal and it should work as
expected.