I have a painfully simple app I wrote for in-house use here at work, and it functioned perfectly until we swapped out the server housing the SQLserver DB. I changed the servername in the system DSN (and also tried creating a new one) on the station running the app (mine) but the app no longer makes connection. The DSN successfully connects according to the test, but the app crashes.

Since the old server ran 2000 server, and the new one 2003 server, I thought perhaps there's an updating of provider required. Here's what I'm using:

cnSPR.Provider = "Microsoft.Jet.OLEDB.4.0;"
cnSPR.ConnectionString = "Provider=MSDASQL;DSN=SPR;"

That worked fine, up until now. Any help appreciated.