Highlighted

Getting data from SQL Server on a different server

Guddie

06-11-2008

Before I dive into this, I want to make sure it's possible
and relatively painless 🙂



My Flex web app is hosted on one server (call it server01)
which is the web server, and I have a SQL Server 2000 database on
another server (server05), which is not a web server. In the Flex
app, I'd like to populate a ComboBox using data from a table in SQL
Server. Is this possible even though they are on different servers
and server05 doesn't has web access? Thanks.

Replies

Highlighted

bholli

07-11-2008

Are you using a web service? As long as your web service (on
web server) is able to communicate with the database, then the web
service can then send that response to your flex
application.
Highlighted

Guddie

10-11-2008

I'm not using anything as of yet to accomplish this. It seems
that using web services is the recommended method. Could you
provide any information on setting up a web service, or resources?
Thanks.