An I.T. Problem Shared . . .

A blog of problems . . . and solutions

Entries for the ‘Databases’ Category

Access 97 Date Format

OK so in 2010 we shouldn’t still be dealing with Access 97 databases but in the real world some people still have them! So a client tells me their Access 97 database form is showing them the wrong data for the date range they enter. The form is opened from a command button on another […]

Deleting Microsoft SQL Server 2000 from Windows 7 Sync Center

If you have to install Microsoft SQL Server 2000 on Windows 7 you’ll find that Windows Sync Center automatically starts at Windows startup. Opening Sync Center will show that Microsoft SQL Server 2000 has been automatically added and cannot be deleted. To remove this sync partnership you need to edit the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SyncMgr\Handlers Find […]

PHP mssql_connect() unable to connect to server

Running PHP on a Windows 2003 Server and connecting to Microsoft SQL Server 2000 Service Pack 4 we found that sometimes the PHP script could connect to the SQL Server but most of the time we’d get ‘mssql_connect() unable to connect to server’. After Googling the problem I found a lot of references to needing […]

Losing data on MySQL SQL restore

I recently had to backup and restore a MySQL database so I dumped the whole database into a SQL file but when I came to restore I found that in one of the biggest tables a lot of the data was missing. Looking at the warnings when I ran the restore query I found I […]