Post reply

DTS Designer Error

  • October 26, 2006 at 3:14 pm

    #114895

    Hello,

    I've recently installed sql server 2000 on my home computer. I can create databases, but am having an issue with the dts package designer.

    When I try to create a new SQL Server connection I get the following DTS Error:

    "No provider exists for this connection on this computer".

    I probably didn't set something up right, but I can't seem to find the answer.

    Any thoughts would be helpful.

    Thank you.

  • October 30, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • October 30, 2006 at 6:47 pm

    #668908

    what connection are you trying to use?

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • October 31, 2006 at 5:45 am

    #668949

    Hello David,

    It's the SQL Server OLE DB Connection. It turns out that the version given to me was the Standard Edition as opposed to the Developer Edition.  Standard only allows me to connect to other servers and not create one on the machine.

    Thanks again for the response.

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

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