Getting data from SQL Server on a different server

Avatar

Avatar
Level 1
Guddie
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
Guddie
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
Guddie
Level 1

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

Avatar

Avatar
Level 1
bholli
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
bholli
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
bholli
Level 1

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.

Avatar

Avatar
Level 1
Guddie
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
Guddie
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
Guddie
Level 1

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.