Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
engrpetero
Starting Member
2 Posts |
 Posted - 2010-03-23 : 16:42:26
|
| Hi all,I have a VB6 app that has long been working with MSDE (SQL2K) databases. Recently, I found that it needed to also connect to an instance of SQLExpress (Sql2005) and as the app was, it didn't work.I spent much of the day searching the Internet for comments and discussions on this issue. It seems that a 'backward compatibility version' of SQLDMO is needed for allowing apps targeting SQL2K to connect to SQL2005. I downloaded this from the MS site (SQLServer2005_BC.msi is the file) though to be honest, I am not sure what to do with it. I assume this needs to be installed on the clients on which the initial VB6 app resides. But does the VB6 code that uses SQLDMO need to be recompiled with the new SQLDMO.dll? Nothing I'm trying seems to fix the problem - any help is certainly sppreciated.Sincerely,Peter |
|
|
engrpetero
Starting Member
2 Posts |
Posted - 2010-04-05 : 14:02:46
|
| The solution (that worked for me) was to install Windows XP SP3 and then SQL Express 2005 SP3. After that, I could get security settings/logins to 'respect' my VB6 app login. |
 |
|
|
|
|
|
SQLDMO