multiuser/N tier

[sing12]

hi
can i create a logon to the sql server by deploying components in the mts through vb something like that of win Nt logon.
i am having problems by registering components and using them as in multiple machines.
anybdy who has worked with n-tier architecture please help me.
bye roopa

previously posted
{

i am developing n-tier application(multiuser environment) using vb6 and sql server 7.0 on windows 2000 platform.

Multiple users will be logging on diffn machines to access data.At user level they will have access to thin clients. the main components will be at the terminal server through which they will access the database.

at present i have developed the components and tested the application on the same machine. i find it is successfull including the mutiple users logging and accessing data.(wisthout registering in the MTS)

when register my component in the MTS i am unable to do the same.
my threading model in Apartment
Instancing-Multiuse
Trasaction-Usestransactions

my code
dim oc as ObjectContext
set oc=GetObjectContext()

----
oc.setcomplete
---
oc.setabort

my problems
1. when 2 or more users are logged on either one of them disconnect the database gets disconnected even though other users are yet logged on.
2. it identifies only the recently logged on user(fo eg.fa) but when f1(previously)logged tries to disconnect through a difn exe it identifies as (fa disconnectd/logged out)

but both these cases work well when not registered in MTs

does anybody knows how to solve it
thanks for your time
bye
roopa
}