Guest_imported
New member
- Jan 1, 1970
- 0
Anybody who have three tier program sample please let me know. Thanks a lot.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Three Tier Program 2
- Thread starter Guest_imported
- Start date
- Status
-
2
- #2
Sorry, I don't have a sample I can send, but in concept it's very simple.
You write an active-X DLL that does all database access. The user interface has no, repeat NO, database code in it -- it only calls the middle layer.
So if you have an employee table, you'd write an CEmployee class in an Employee VB DLL project. In this class, you'd have Create, Remove, Update, and Delete methods (known in the industry as CRUD, believe it or not).
You can then write any user front-end you want on top of this DLL -- Web/ASP, Client-Server, whatever. All the front end does is call the DLL, who does most of the work for you.
A big benefit of this is that all your business logic is in one place. So you can add protection from unauthorized persons from updating employee salary info, for example. These rules would then be applied no matter what client was used to connect to the middleware.
Chip H.
You write an active-X DLL that does all database access. The user interface has no, repeat NO, database code in it -- it only calls the middle layer.
So if you have an employee table, you'd write an CEmployee class in an Employee VB DLL project. In this class, you'd have Create, Remove, Update, and Delete methods (known in the industry as CRUD, believe it or not).
You can then write any user front-end you want on top of this DLL -- Web/ASP, Client-Server, whatever. All the front end does is call the DLL, who does most of the work for you.
A big benefit of this is that all your business logic is in one place. So you can add protection from unauthorized persons from updating employee salary info, for example. These rules would then be applied no matter what client was used to connect to the middleware.
Chip H.
- Thread starter
- #3
Guest_imported
New member
- Jan 1, 1970
- 0
Hi Chiph,
I'm have try the concept's you give me but it's still not working. The message is (Internet Client Error : Cannot Connect to Server). Do you have any ideas?
Thank you.
regards,
Lim King Hua
I'm have try the concept's you give me but it's still not working. The message is (Internet Client Error : Cannot Connect to Server). Do you have any ideas?
Thank you.
regards,
Lim King Hua
Can you post a copy of your code?
It sounds like you're using ASP, so in your ASP page, you'd do something like:
My2ndTier = server.CreateObject("My2ndTierDll"
Name = My2ndTier.GetFirstName()
Response.Write "First Name is" + Name
Since this is ASP, all of this occurs on the server, so there's no internet client involved other than Internet Explorer. Wait a sec... are you testing both the client and the server on the same machine? If so, you can connect your browser to IIS by putting " in as the address.
Chip H.
It sounds like you're using ASP, so in your ASP page, you'd do something like:
My2ndTier = server.CreateObject("My2ndTierDll"
Name = My2ndTier.GetFirstName()
Response.Write "First Name is" + Name
Since this is ASP, all of this occurs on the server, so there's no internet client involved other than Internet Explorer. Wait a sec... are you testing both the client and the server on the same machine? If so, you can connect your browser to IIS by putting " in as the address.
Chip H.
Go to Planet Source Code ( and search for '3 tier demo'.
Regards,
Clay
Regards,
Clay
- Thread starter
- #6
Guest_imported
New member
- Jan 1, 1970
- 0
Thanks a lot chiph & challer the problem i'm face before are solved thank you for your suggestion and opinion.
kinghua
kinghua
- Status
