Mike,

I am trying to PUSH the XML string to a Java Server Page. It looks like I have the dynamics set up properly because I can see that the page activity is logged when I send the data. The problem now seems to be that only a NULL is being sent or received. I don't know if perhaps I am using sp_OACreate incorrectly or what.

Thanks for you help.

George

>I'm confused. Are you trying to PULL or PUSH xml out of SQL Server? You can retrieve xml (PULL) from SQL Server by using the FOR XML clause on your queries. The XML will be returned to the client as a stream instead of a result set.
>
>PUSHing is a different story.
>
>-Mike
>
>>Thanks Eric, I'll take a look at this. Once it is set up on the Web server, then what steps are needed within SQL Server? If you could just point me in the right direction to find this info I'd appreciate it. And thanks for the quick reply!
>>
>>George
>>
>>>There is alot eaiser way to get xml out of a sql server over HTTP. Assumin you have iis running on the sql server, goto the sql server in the start menu, select configure sql xml support in iis. Select your website, right click select new virtual directory and follow the wizard.
>>>
>>>Eric