|
Hi everyone,
First, let me say I haven't ever really done much with Web Services except for the brief coverage in MS .NET curriculum...
Our network doesn't allow clients to connect directly to a SQL server that is on a different subnet (firewall port blocking, etc). In the past, we have used file DSNs on each client to connect to SQL, but I recently had the revelation to try WebServices (don't ask why it took me this long).
I can run TaskVision fine on clients that are on the same subnet as the SQL server, but not across subnets (same problem we had before).
If I use WebServices to return data (as in TaskVision) to a client, the client itself shouldn't need to be able to connect directly to SQL, because the IIS server is talking to SQL (which is on the same subnet), correct?
Is my thinking flawed, or am I forgetting something?
Thanks in advance, chris |