Results 1 to 3 of 3

Thread: does SQLDMO work with MS SQL Server 2005?

  1. May 31st, 2007, 05:59 PM #1
    benmartin101
    benmartin101 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jul 2005
    Posts
    1,168

    does SQLDMO work with MS SQL Server 2005?

    I am unable to connect to a 2005 server using SQLDMO com object. I even tried installing "SQLServer2005_BC.msi" and still I'm unable to connect. It keeps giving me a message that I need to use SMO. Is there a way around this? Could I still use SQLDMO to connect to SQL server 2005?
    Reply With Quote Reply With Quote
  2. May 31st, 2007, 07:20 PM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: does SQLDMO work with MS SQL Server 2005?

    Unfortunately nope. Doesn't work.

    BUT, SMO can connect to both SQL2000 AND SQL2005.

    SMO has a lot more to it than SQLDMO did.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Jun 1st, 2007, 10:19 AM #3
    benmartin101
    benmartin101 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jul 2005
    Posts
    1,168

    Re: does SQLDMO work with MS SQL Server 2005?

    thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width