« Previous Next »

Thread: Server.CreateObject("IXSSO.Query") fails on IIS7

Last post 10-05-2009 9:42 AM by debuke. 10 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (11 items)

Sort Posts:

  • 05-27-2009, 5:25 PM

    Server.CreateObject("IXSSO.Query") fails on IIS7

    Hi,

    We've ported across a classic ASP site to Windows Server 2008 Enterprise 64 bit but can't get Indexing Service to work with it.

    As soon as the following line of code is hit:
    set objQuery = Server.CreateObject("IXSSO.Query")

    We get the following error:
    Err.Source: Microsoft VBScript runtime error
    Err.Number: 429
    Err.Description: ActiveX component can't create object

    The Indexing Service seems to have installed without issue and I've created the cataolg without issue and can see it's been populated.

    Any IIS7 gurus out there have any ideas what might be wrong?

    Thanks in advance,
    Gavin

    Gavin Harriss
    Portfolio: www.gavinharriss.com
  • 05-28-2009, 1:33 AM In reply to

    • WWWWeb
    • Top 100 Contributor
    • Joined on 04-30-2009, 9:42 AM
    • Posts 52

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    IXSSO should have 64bit only on 64bit system, make sure you are running worker process in 64bit.

    Check the user permission as well.

     

  • 05-29-2009, 12:34 AM In reply to

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    Hi, thanks for that - much appreciated! I was wondering if it was something to with 32 bit vs 64 bit.

    I've actually coded up a replacement Windows Search Service solution instead now as it was quite easy to swap over.

    Gavin Harriss
    Portfolio: www.gavinharriss.com
  • 05-29-2009, 11:59 AM In reply to

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    What does that mean, "worker process"?  It would be awesome to get indexing working with ASP classic again.

    Thanks

  • 06-16-2009, 10:10 PM In reply to

    • aadames
    • Not Ranked
    • Joined on 06-17-2009, 2:08 AM
    • Posts 2

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    Hi, currently I have the same problem using ixss0.query on IIS 7 W2008 Web Server. Can you shared with me your code solution?

     

    Regards,

  • 06-19-2009, 6:25 PM In reply to

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    The code I wrote was very specific to the environment I was in. However, there's some great examples on MSDN for different languages (.NET, classic asp, etc.) which I used. Can't remember the urls to examples but a quick search on MSDN should find them for you ;)
    Gavin Harriss
    Portfolio: www.gavinharriss.com
  • 06-19-2009, 6:57 PM In reply to

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    Actually, just dug out urls...

    Here's some code examples:

    http://msdn.microsoft.com/en-us/library/bb266517(VS.85).aspx

    And I used this info to figure out what sort of data is available to query:

    http://msdn.microsoft.com/en-us/library/bb419046(VS.85).aspx

     

    Gavin Harriss
    Portfolio: www.gavinharriss.com
  • 06-23-2009, 9:27 AM In reply to

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

     I wasn't seeing a Windows Search property for characterization?  Does anyone know which property that is?

  • 07-30-2009, 1:16 PM In reply to

    • Gazcon
    • Not Ranked
    • Joined on 07-30-2009, 5:08 PM
    • Posts 4

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    The IXSSO.Query is not working on windows 2008, but, the object MSIDXS is working yet, simply change the syntax of searches to:

    you can select other columns like: Rank, DocAuthor, DocAppName, DocTitle, FileName, Create, Access, Characterization, VPath

    other commands are available on http://www.codeproject.com/KB/database/Indexing_Service_HOW-TO.aspx?display=PrintAll 


    Set rs1= Server.CreateObject("ADODB.Recordset")


    rs1.Open "SELECT FileName,Characterization FROM SCOPE('DEEP TRAVERSAL of """ & your_directory& """') WHERE FREETEXT(Contents, '" & your_searchword & "') order by rank","PROVIDER=MSIDXS; DATA SOURCE=" & your_catalog_name & ";"

    if not rs1.eof then

     do while not rs1.eof

         file_name=rs1("file_name")

         resume=rs1("characterization")

    rs1.movenext

    loop

    end if

  • 09-30-2009, 5:40 PM In reply to

    • debuke
    • Not Ranked
    • Joined on 09-06-2006, 3:30 PM
    • Posts 2

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

    is it official that "IXSSO.Query is not working on windows 2008" or is that just someone's comment? 

    we are having the same issue (Error 429 ActiveX Component Can't Create Object) in a legacy ASP install under windows 2008 but other com objects are created just fine.


  • 10-05-2009, 9:42 AM In reply to

    • debuke
    • Not Ranked
    • Joined on 09-06-2006, 3:30 PM
    • Posts 2

    Re: Server.CreateObject("IXSSO.Query") fails on IIS7

     ok... i had the privilege of working directly with microsoft and i got the offical word that this component isn't supported in the 32-bit land on windows 2008 64-bit. 

     the solution that was offered was to copy the 32-bit version of ixsso.dll in to the 32 bit folder (syswow64) from a 32-bit environment and with some modifcations to the registry, it "may work".  of course, any subsequent patches to the O/S will result in this DLL being "left behind" (in terms of patches).  so this solution won't work for us.

     time to go about this another way... :)

     

Page 1 of 1 (11 items)