I can''t make my connection work via DMO to SQL Server 2005

  • Hi, I'm trying to use a legacy application that connects to SQL Server via DMO but i't wont work

    The reply from SQL Server 2005 is ;

    [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).

    I've tried to figure out how to setup DMO on the SQL Server but no success so far.

    Anybody has any tips ?

     

    /Regards Anders

     

  • Install SQL Client tools for SQL 2005 on the client machine and it should work as it will upgrade the SQLDMO.dll so it can connect to SQL2005 instances. 

     

    regards,

    Mark Baekdal

    MSN m_baekdal@hotmail.com

    +44 (0)208 241 1762

    http://www.dbghost.com

    http://www.innovartis.co.uk

    Build, Comparison and Synchronization from Source Control = Database change management for SQL Server

     

     

  • What made it work was "Feature Pack for Microsoft SQL Server 2005 - November 2005".

    Download and install..heureka !

     

    /Regards Anders

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply