Problem using SQLDMO/Vb6 against SQL Server 2008

Posted by E.J. Brennan on Stack Overflow See other posts from Stack Overflow or by E.J. Brennan
Published on 2010-03-23T20:05:50Z Indexed on 2010/03/24 6:13 UTC
Read the original article Hit count: 452

Filed under:
|
|
|

I have a client, that uses SQLDMO for a portion of a custom application that was written against SQL Server 2000, and they recently upgraded to SQL Server 2008.

The majority of the app still runs fine (doesn't use SQLDMO), but the admin functions which rely on SQLDMO stopped working.

I installed the SQL2005 backward compatibility pack, and now SQLDMO partially works, i.e. I can run "select" type queries, but any "Update" queries fail with the error message:

to connect to the server you must use SQL Server management studio or sql server management objects (SMO)

Any thoughts? Should the backward compatibility pack give me ALL the functionality back, or is this a known issue?

BTW: I realize SQLDMO has been deprecated and will go away next release, none-the-less I need to do what I can to solve the problem at hand.

© Stack Overflow or respective owner

Related posts about sqldmo

Related posts about vb6