Welcome to Office & SharePoint Pro Sign in | Join | Help
in Search

SUBSCRIBE to Windows IT Pro Magazine & SAVE 30%      FREE Email Newsletters Vista UPDATE, Windows IT Pro UPDATE & More

Error on getting description of categories in SPS2001

Last post 02-20-2007, 4:58 AM by kizin. 0 replies.
Sort Posts: Previous Next
  •  02-20-2007, 4:58 AM 28193

    Error on getting description of categories in SPS2001

    An error occured when i try the command :"oDoc.DataSource.Open"

    the error is : 2147217768 meaning :
    " The provider was unable to create an object at this URL because an object named by this URL already exists "
    _____________________________________________
    Sub GetDescCategorie
    on error resume next

    Dim strDoc, dictCats, SingleCat, typeBoucle, dictCatsDesc

    strDoc = HttpRoot & "/Catgories/" & Rub1

    Set oDoc = createobject("CDO.KnowledgeCategoryFolder")

    oDoc.DataSource.Open strdoc, Nothing, adModeRead,,,UserAdm ,PwdAdm
    if err <> 0 then erreur = "Erreur lors oDoc.DataSource.Open 1 :: \nNum de l'erreur : " & err.number &"
    "
    Rub1 = Rub1 & " - " & oDoc.Description
    if err <> 0 then erreur = "Erreur lors Rub1 - oDoc.Description :: \nNum de l'erreur : " & err.number &"
    "
    ' Set oDoc= Nothing

    If Len(Rub2)>0 Then
    strDoc = strDoc & "/" & Rub2
    response.write "TEST : RUB2" & strDoc & "
    "
    oDoc.DataSource.Open strDoc, Nothing, adModeRead,,,UserAdm ,PwdAdm
    if err <> 0 then erreur =erreur & "Erreur lors oDoc.DataSource.Open 2 :: \nNum de l'erreur : " & err.number &"
    "
    Rub2 = Rub2 & " - " & oDoc.Description
    if err <> 0 then erreur =erreur & "Erreur lors Rub2 - oDoc.Description :: \nNum de l'erreur : " & err.number &"
    "
    ' Set oDoc= Nothing

    End if

    If Len(Rub3)>0 Then
    strDoc = strDoc & "/" & Rub3
    response.write "TEST : RUB3" & strDoc & "
    "
    oDoc.DataSource.Open strDoc, Nothing, adModeRead,,,UserAdm ,PwdAdm
    if err <> 0 then erreur =erreur & "Erreur lors oDoc.DataSource.Open 3 :: \nNum de l'erreur : " & err.number &"
    "
    Rub3 = Rub3 & " - " & oDoc.Description
    if err <> 0 then erreur =erreur & "Erreur lors Rub3 - oDoc.Description :: \nNum de l'erreur : " & err.number &"
    "
    ' Set oDoc= Nothing
    End if


    If Len(sRub3)>0 Then
    strDoc = strDoc & "/" & sRub3
    response.write "TEST : sRUB3" & strDoc & "
    "
    oDoc.DataSource.Open strDoc, Nothing, adModeRead,,,UserAdm ,PwdAdm
    if err <> 0 then erreur =erreur & "Erreur lors oDoc.DataSource.Open 3b :: \nNum de l'erreur : " & err.number &"
    "
    sRub3 = sRub3 & " - " & oDoc.Description
    if err <> 0 then erreur =erreur & "Erreur lors sRub3 - oDoc.Description :: \nNum de l'erreur : " & err.number &"
    "
    End if


    If Len(Rub4)>0 Then
    strDoc = strDoc & "/" & Rub4
    response.write "TEST : RUB4" & strDoc & "
    "
    oDoc.DataSource.Open strDoc, Nothing, adModeRead,,,UserAdm ,PwdAdm
    if err <> 0 then erreur =erreur & "Erreur lors oDoc.DataSource.Open 4 :: \nNum de l'erreur : " & err.number &"
    "
    Rub4 = Rub4 & " - " & oDoc.Description
    if err <> 0 then erreur =erreur & "Erreur lors Rub4 - oDoc.Description :: \nNum de l'erreur : " & err.number &"
    "
    ' Set oDoc= Nothing
    End if

    Set oDoc= Nothing
    ' S'il y a un problme, arrte l'excution de la page
    on error goto 0

    ' Puis affichage
    if erreur <> "" then
    Response.write(erreur)
    RESPONSE.end
    end if
    end Sub


    _____________________________________________
    the result :

    TEST : RUB2http://W2sspsgn/edelib/Catégories/0/02
    TEST : RUB3http://W2sspsgn/edelib/Catégories/0/02/020
    TEST : sRUB3http://W2sspsgn/edelib/Catégories/0/02/020/0202
    TEST : RUB4http://W2sspsgn/edelib/Catégories/0/02/020/0202/0202-04
    Erreur lors Rub1 - oDoc.Description :: \nNum de l'erreur : -2147220240
    Erreur lors oDoc.DataSource.Open 2 :: \nNum de l'erreur : -2147217768
    Erreur lors Rub2 - oDoc.Description :: \nNum de l'erreur : -2147220240
    Erreur lors oDoc.DataSource.Open 3 :: \nNum de l'erreur : -2147217768
    Erreur lors Rub3 - oDoc.Description :: \nNum de l'erreur : -2147220240
    Erreur lors oDoc.DataSource.Open 3b :: \nNum de l'erreur : -2147217768
    Erreur lors sRub3 - oDoc.Description :: \nNum de l'erreur : -2147220240
    Erreur lors oDoc.DataSource.Open 4 :: \nNum de l'erreur : -2147217768
    Erreur lors Rub4 - oDoc.Description :: \nNum de l'erreur : -2147220240 ____________________________________________ I want to get the description and i don't understand the meaning of the error. This function works on an other server but not on this one. Somebody knows the package/API/something missing? Thanks, Yann
View as RSS news feed in XML
SPONSORED LINKS FEATURED LINKS

SharePoint Security SimplifiedHaving trouble with Permissions in your SharePoint environment? Check out USPM v2007® Order Your Fundamentals CD Today!Get up to speed quickly and learn how to uncover rich information management and deployment capabilities with this free SharePoint CD. Simplify Content Migration for SharePointEase the job of SharePoint migration and ongoing site maintenance. Michael Noel outlines your migration options in this white paper. Download today! Prepare Yourself for Exchange CatastropheRead this white paper to learn how you can keep Exchange server healthy, as well as predict and respond to server failure. Featured eBook - Fundamentals of Fax Server TechnologyTake advantage of the benefits of fax servers and find out how you can implement a solution that is easy to support, secure, and integrate. Dramatically Accelerate Microsoft SharePointDeliver unimpeded access to SharePoint - Learn how to fix more than just the symptoms of slow application delivery and poor performance. Protect Your Company’s Digital AssetsDo you know the risks of sending important files over email or FTP? Read this white paper to learn what you can do to safeguard your company’s data. Boost Customer Confidence and SatisfactionRead this eBook to learn how fax servers can ease communication with less computer-savvy customers while reducing your security, compliance, and support woes. Implement a Successful Archiving SolutionView this web seminar to learn the best practices for creating an email archive that is secure, compliant, and searchable.