Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Location
    THAILAND
    Posts
    15

    Unanswered: DTS designer error

    When I open my DTS package at my PC ( Client ) .There is an error message show like below .

    DTR Designer Error.
    There was a problem retriving the list of OLE DB providers.

    No. Provider is selected .TO continue,you must select a valid provider.


    Please help
    1

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    Delete the server registration in EM and re-register the server.

    Post back if problems.

    Cheers

    SG.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What is the level of service pack of SQL on the client machine?
    Ensure to maintain similar service pack on Server and on client as well.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Mar 2004
    Location
    THAILAND
    Posts
    15
    Originally posted by sqlguy7777
    Howdy

    Delete the server registration in EM and re-register the server.

    Post back if problems.

    Cheers

    SG.
    I have already done as your mention but it still show the same error message

    Any idea ??
    1

  5. #5
    Join Date
    Mar 2004
    Location
    THAILAND
    Posts
    15
    Originally posted by Satya
    What is the level of service pack of SQL on the client machine?
    Ensure to maintain similar service pack on Server and on client as well.

    How can I check the service pack verion of both server and client ? Please introduce me

    Thanks
    1

  6. #6
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    SELECT serverproperty('ProductLevel')

    Regards!!

  7. #7
    Join Date
    Jan 2004
    Posts
    16

    Post

    select @@version;

    This will give you the details of OS level as well as SQL Server level.

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    This causes due to .DLL mismatch or even MDAC version between client and server machines, so ensure you have all the similar levels.

    This @@Version or Serverproperty will give you version on server for SQL Server and on client machine ensure to run service pack for SQL again which might resolve the issue.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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