I wrote my VB app with a reference to the sqldmo.dll 8.0 library on a machine with SQLServer 2000 installed. Now I want to change the reference to sqldmo.dll 7.0 instead and include that file in my package. I tried to remove the reference to 8.0 and copied a version of 7.0 to the same directory where 8.0 was. Then went into VB and tried to set a reference to the 7.0 dll. When I press OK, I get an error "Can't load dll file".
What am I doing wrong?