Data Tier

  • Thread starter Thread starter William Ryan eMVP
  • Start date Start date
W

William Ryan eMVP

Hi Jerry:
Jerry said:
I have written one distributed application where the base is SQL 2000 and
the clients all have their own module for handling data access calling
stored procedures on the server.
The application I am designing now, I would like to have a data engine on
the server which serves all the data to the clients. I know this can be
done with an XML Web service, but can this be done as a Windows Service?
can one pass data back and forth from a windows service running on the
server?
Click to expand...
If you're asking if you can basically have a service that returns
datasets/datatables and/or individual values, then yes, you can. However,
accessing the thing may be a bit cumbersome and such things lend themselves
quite well to the web service approach. There are a whole lot of
configuration issues and tother such things that can easily be avoided.

HTH,

Bill
 
I have written one distributed application where the base is SQL 2000 and
the clients all have their own module for handling data access calling
stored procedures on the server.
The application I am designing now, I would like to have a data engine on
the server which serves all the data to the clients. I know this can be
done with an XML Web service, but can this be done as a Windows Service?
can one pass data back and forth from a windows service running on the
server?
 
Hi Jerry,

In addition to Bill,

I am also curious what the extra middle Tier in dotNet gives me more than a
lot of trouble and unreadable design, however I think that I am kicking to a
lot of classic ideas now.

And in past I found it the way to go (even more tiers).

However just my idea.

Cor
 
Hi Jerry:
Jerry said:
Thanks for the reply Bill.
I guess I am going to have to go Web Service with it.
Click to expand...
To know them is to love them... you'll really enjoy working with them

I was hoping to make
it accessable to companies that have networks, but not intranets and leave
IIS out of the loop.
Click to expand...

Well, I can certianly see why you may feel this way. However, things are a
lot more secure these days and IIS 6 is very powerful and as long as you
keep up to date with the updates, and you follow the security guidelines,
you'll find you have a lot ofeatures available to you that makes life really
pleasant.

I like Windows services too, and they are real life savers, but I've found
web services a lot easier to use in a distributed environment.

Let me know if you have any problems.

Cheers,

Bill
 
Thanks for the reply Bill.
I guess I am going to have to go Web Service with it. I was hoping to make
it accessable to companies that have networks, but not intranets and leave
IIS out of the loop.
Regards
 
Back
Top