Q: web services

[Guest]

Hello,

I have an asp.net application developed by someone else and it seems it
interacts with database through web services. What is the benefit of this?
Any idea?
Thanks,

 

[Kevin Spencer]

If the database is on another domain, and is not a database server such as
SQL Server, MySql, or Oracle, or does not have a public IP address, or is
otherwise not available directly, that would be a good reason to do this. If
the database is on the same domain, or is a database server with a public IP
address, this would be a bad idea.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
We got a sick zebra a hat,
you ultimate tuna.

 

[Guest]

Hi Kevin,

Thanks for the reply. The asp.net application is on a web server for
internet users. Web server is a DMZ machine as far as I heard which is a
different domain then the SQL Server database in the domain. In this case,
can I go without web services? Can I make connection from DMZ to SQL Server
without web services, or I have to use web services?
Thanks for your help.

 

[Kevin Spencer]

Hi Jim,

SQL Server databases are usually connected to using TCP/IP, and have an IP
address (of the machine on which they reside) and port number (usually
1433). So, if the SQL Server can be accessed from the other domain (usually
this means that it has a public IP address), there is no need for a web
service. Otherwise, there is a need for some kind of service to connect to
it.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
We got a sick zebra a hat,
you ultimate tuna.