I have a standalone application that uses a local database using Microsoft SQL Server Desktop engine Version 8.00.761. We are going to retire the application. There are many of these machines some on XP pcs some Win2K pcs but both with the same SQL database.
We want to be able to look at the old dbs on one machine (a Win2k) I am able to restore a DB from the XP machine and it gives me the message Restore database successfully processed.
However when I launch the application it gives a connection string error.
I thought that this might be a setting that is in the application itself so I copied the entire folder of the application from the XP machine over to my Win2K machine and tried to use it with the Win2Ks Db and it works fine.
So can anyone give me an idea whether a db backed up on a 8.00.761.XP machine can be restored on a 8.00.761.Win2K machine?