title: Problem using SQLDMO/Vb6 against SQL Server 2008
body: <p>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.</p>
  
  <p>The majority of the app still runs fine (doesn't use SQLDMO), but the admin functions which rely on SQLDMO stopped working.</p>
  
  <p>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:</p>
  
  <p><strong><em>to connect to the server you must use SQL Server management studio or sql server management objects (SMO)</em></strong></p>
  
  <p>Any thoughts? Should the backward compatibility pack give me ALL the functionality back, or is this a known issue?</p>
  
  <p>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.</p>