Unable to Completely Uninstall MSDE and SQL2000 locally linked to a VB6 program on XP Pro
I inherited a working vb6 program using MSDE and have developed it into a royal dilemma.
On the initial vb6 program install, the path of the MSDE was requested and supplied. Program setup installed MSDE. Program executed with perfection over and over. VB6 program worked properly; however only on first install.
PROBLEM BEGAIN once vb6 program was UNINSTALLED.
At REINSTALLATION, no VB6 requests to set path for MSDE occurred,
How would vb6 use MSDE and mssql's database file?
Start fresh, wipe down all traces of earlier installs and get program functioning as occurred or original install was the goal. Program would ask for MSDE path again if I uninstalled MSDE, yeah right, sour logic, that's a big negative. I UNINSTALLED MSDE desktop engine from add/remove in control pannel, regedit deleting of mssql hkeys, and unintalled vb6 program.
I REINSTALLED vb6 program, executed it and
received error message titled Microsoft SQL Server Login Connection failed: SQLSTate: '08001' SQL Server Error: 17
[DBNETLIB][ConnectionOpen (Connect()).)]SQL Server does not exist or access denied. I interpreted this to mean that the vb6 program did not reinstall MSDN.
I tried directly to manually INSTALL MSDN SETUP and got an error message, "A strong SA password is required for security reasons. please use SAPWD switch to supply the same. "
Knowing program has worked before and thinking the attempts to uninstalled both the vb6 program and the MSDE I made it worse by finding the full SQL 2000 cd in order to use the full uninstall feature, but the uninstall button was blacked out. I proceeded to installed SQL2000 and with redoing an wiping clean using the SQL2000 uninstall feature but have read how that was not a good idea because of MTS COMPONENTS and STUFF?? and how both use different system Dlls and can overwrite each other and cause conflicts.
Can anyone help? I know this program works on original install. Am on XP Pro and have used System Restore, even that didn’t wipe everything off.
Thank you in advance.