Send HTTP request using SQL Sever 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

Send HTTP request using SQL Sever 2005

Author

Topic

satyamamin
Starting Member

5 Posts

Posted - 2007-04-16 : 06:04:11

I have Lotus Notes Database which stores employee database. If I request following http URL on browser, which fetch data from Lotus Notes Database and response me following XML text. I need to pass some id as a parameter in HTTP request to retrieve particular data.

HTTP Request:
http://kernel.com/global/corp/ecd.nsf/xmlemployeesactivebyguid?readviewentries&StartKey=sesa249&count=1

HTTP Response:
<?xml version="1.0" encoding="UTF-8" ?>
<viewentries toplevelentries="53656">
<viewentry position="14310" unid="FC86BCB9224169F4C12570AD005A775C" noteid="D9FA2" siblings="53656">
<entrydata columnnumber="0" name="GUID">
<text>SESA24941</text>
</entrydata>
</viewentry>
</viewentries>

I need to send this http request programmatically. To do that,

1) Is thr any functionality in SQL Server 2005, which can send http request to any other server like LOTUS NOTES
2) If not,thn do you know how to do it programmatically using c# ?

When U have some time, let me know. Thanks in advance man.

Satyam

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-04-16 : 18:15:46

The HttpWebRequest and HttpWebResponse classes in the .NET Framework will let you do that with C#. Take a look in the documentation or search Google for those two classes and you'll find lots of examples.

satyamamin
Starting Member

5 Posts

Posted - 2007-04-17 : 04:13:36

Thanks Sean for your reply. Finally I also did it by this two classes only. But still looking for any functionality in SQL Server, which will call HTTP call ? Otherwise, do you know that how to implement C# code inside SQL Server which will retrun response ?

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-04-17 : 10:52:27

You can create a CLR stored procedure using C#, see
http://msdn2.microsoft.com/en-us/library/ms131094.aspx

satyamamin
Starting Member

5 Posts

Posted - 2007-04-23 : 09:38:13

Thanks for your reply. Finally I did it with Sql Server User Defined function which will return me query.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources