« Previous Next »

Answered Thread: IIS7: ?How? to setup virtual XML feeds from SQL Server

Last post 09-24-2008 5:05 AM by shaves23. 3 replies.

 

RSS

Page 1 of 1 (4 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 07-30-2008, 2:22 PM

    • davidtg
    • Not Ranked
    • Joined on 07-17-2008, 11:08 PM
    • Posts 7

    IIS7: ?How? to setup virtual XML feeds from SQL Server

    Reply Contact

     Hi,

    Previously I've used the IIS Virtual Directory Management for SQLXML to create the virtual folders and connections to the SQL servers but am at a loss for how to accomplish this in IIS7 and MSSQL 2005. I can't seem to find any documentation or post regarding this subject.

    Any help is appreciated, David
     

  • 07-31-2008, 3:13 PM In reply to

    • davidtg
    • Not Ranked
    • Joined on 07-17-2008, 11:08 PM
    • Posts 7

    Answered Re: IIS7: ?How? to setup virtual XML feeds from SQL Server

    Reply Contact

    Let me follow-up on this as I'm a bit less confused on this issue but still have a problem.

    The SQLXML 3.0 uses virtual folders and an SQLXML ISAPI filter to provide a conduit for URL-based queries to SQL Server. The new SQLXML 4.0 that is part of SQL2005 no longer supports this method. Perhaps for the better but I'm not yet in a possition to migrate all our datafeeds.

    In theory I can install SQLXML 3.0 into IIS7 (Win2008 64-bit server), but after what appears to be a successful installation and configure of the virutal folders its not working.

    Attempts to call one of the xml templates just gives a 500 error 0x800700c1. Permissions and all appear correct. The IIS Virtual Direcotry Manager for SQLXML 3.0 throws an error when I attempt to Restart Application DLL "Error occurred unloading the application".

    Hopeful that someone else may have experiences with SQLXML 3.0 and IIS7 or any insights as to why it may not be working. 

    David 

  • 07-31-2008, 4:19 PM In reply to

    • davidtg
    • Not Ranked
    • Joined on 07-17-2008, 11:08 PM
    • Posts 7

    Re: IIS7: ?How? to setup virtual XML feeds from SQL Server

    Reply Contact

     Oh my...ack!  Fixed.

    I was sure I'd already set the AppPool to support 32-bit applications but upon re-checking it was set to False. 3+ hrs of tbshooting semi-needlessly.  Setting the AppPool 32-bit support "True" and now SQLXML 3.0 is working correctly on IIS7 64-bit.

     Now I have the time to migrate the xml feeds to SQLXML 4.0....oh joy....

    David 

  • 09-24-2008, 5:05 AM In reply to

    • shaves23
    • Not Ranked
    • Joined on 09-24-2008, 5:00 AM
    • Posts 1

    Re: IIS7: ?How? to setup virtual XML feeds from SQL Server

    Reply Contact

    Great spot. Thumbs up!

    Steps:

    1. Open IIS Manager, Select Application Pools.

    2. Under Actions pane, Select 'Set Application Pool Defaults'.

    3. Set 'Enable 32-bit Applications' to 'True'.

     

    - $ha've$ -
Page 1 of 1 (4 items)