Access SQL using port 80

  • Thread starter Thread starter Steve Koon
  • Start date Start date
S

Steve Koon

I have a WinForm application that browses url inside an IE browers window on
the form. I currently query the SQL server over port 1433 and retrive a data
hirecachry that creates the menu that users are click on an push the assign
URL entery to the IE window. Due to the issue that using port 1433 present I
would like to move to using port 80 to retrive this data which I would then
poplate my menu with. Does anyonw know where I can get a good example of how
I can accomplish this?

SQL Table columns
ContentID,ContentName,ParentID,ContentURL
1,Google MainSite, ,www.google.com
2,Images,1,www.google.com/images
3,News,1,www.google.com/news
4,Yahoo MainSite, ,www.yahoo.com
5,Movies,4,www.yahoo.com/movies
6,Maps,4,www.yahoo.com/maps


Menu Example
Google MainSite
Images
News
Yahoo MainSite
Movies
Maps



Thanks for any help,
Steve
 
Hi,

I don;t really understand what you want to do, you could move the SQL
server to listen in port 80, but you will not be able to use a web server
then.

additionally you could use a web service, you pass the SP or query to
execute and it return a table.

as the last alternative you could use the SQL CE , now this is intented to
be used in mobile devices, maybe you can install it in a desktop, note that
I have never try this and can not assure it will work, but I think it worth
a try.


cheers,
 
Back
Top