IIS 7 and Above
IIS7: ?How? to setup virtual XML feeds from SQL Server
Last post Sep 24, 2008 05:05 AM by shaves23
Jul 30, 2008 02:22 PM|davidtg|LINK
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
Any help is appreciated, David
Jul 31, 2008 03:13 PM|davidtg|LINK
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.
Jul 31, 2008 04:19 PM|davidtg|LINK
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....
Sep 24, 2008 05:05 AM|shaves23|LINK
Great spot. Thumbs up!
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$ -