I need to bone up on SQL Server Express. It is limited, so it does not have
all of the features of SQL Server 2005 Enterprise/Standard. One option is
SQL Server Service Broker, but this requires a local instance to communicate
to the hosted instance, as well as some set up. The cool thing is you can go
offline and it will communicate when it next comes back online. True asynch.
Not sure if SQL Express has HTTP Endpoints, but they are a nice option.
Basically a web service portal to your service. I would examine carefully,
however, to ensure you have the proper security set up.
For straight querying, the port option is probably the best, although a
hosted database does not generally have a domain login. This is not as bad
as it sounds, but there are potential risks, esp. if your passwords are easy
to guess at.
--
Gregory A. Beamer
*************************************************
Think Outside the Box!
*************************************************
"scott" <ai************@yahoo.com> wrote in message
news:uj**************@TK2MSFTNGP04.phx.gbl...
what is the best way to send data to and query SQL 2005 server express
edition db hosted on a dedicated server with ISP ?
i need to query it directly from an application on my LAN (asp site on
same machine as sql db also needs to query db)
i can obviously use port 1433 but what other option do i have ? i.e ssl
port, xml web service ?
Any information is helpful
Scott