Re: how to get both old and new value for a changed text box

Hay BK,

How do you tell the middle layer which database it's working with?

I've yet to write any Ntier apps and am interested in thier design.

Thanks,
Izzy


BK wrote:
Moving forward...IMO, I would develop 2 versions of your app. 1 for
Access clients and another for SQL Server clients.

Not to fuel any fires, but.... We have all our db I/O go through a
middle tier class. The front end knows nothing of the backend. The
form sends requests for adding and updating records to the middle tier
class and that class knows what db to send things to. I can easily
accomodate ANY db this way, and in fact do. We have a mixture of DB2
(IBM iSeries), Oracle, and SQL Server. I could just as well accomodate
Access if I had to. I also have my audit trail here since all updates
come through this class.

Just my 2 cents.

.

Relevant Pages

  • Re: how to get both old and new value for a changed text box
    ... Access clients and another for SQL Server clients. ... form sends requests for adding and updating records to the middle tier ...
    (microsoft.public.dotnet.languages.vb)
  • How do I convert datasets?
    ... The business logic needs to reside in a COM+ middle tier. ... for SQL Server: ...
    (borland.public.delphi.database.ado)
  • Re: Balancing security needs in ADO.NET applications
    ... Create Views that return focused subsets of the tables as needed by the applications, but do not grant "write" access. ... Hitchhiker's Guide to Visual Studio and SQL Server ... It's simple enough to give the user logon credentials on ... Or maybe write a "middle tier" that alone interacts with the SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: distributed transaction problem
    ... > Could you give us some more details about your middle tier code? ... > connecting to SQL with enlist=true in the SQL Connection String or are you ... >> server to a SQL Server. ...
    (microsoft.public.dotnet.framework.component_services)