Dynamic Database Connection
1) Provision of Changing the database connection based on the Company Change at Login
2) Introduction of Table named DB_Connect which stores information as
Table / DB_ConnectField_Nm / DataType / Size / Description
Co_Cdsr / smallint / 2 / Co_Mst(Co_Cdsr)
UID / varchar / 5 / User ID
Pwd / varchar / 10 / Password
Initial_Catalog / varchar / 10 / Database
Driver / varchar / 20 / Driver(SQL Server)
Server / varchar / 30 / Server(I.P address)
Installed_At / varchar / 20 / Installed At(Site_Cdsr)
Site_At / varchar / 20 / Site At(Site_Cdsr)
Created_By / smallint / 2
Created_Dt / smalldatetime / 4
Modified_By / smallint / 2
Modified_Dt / smalldatetime / 4
3) In every database this Table should be available
4) The data entered in the table should be in Capital Letter
5) The User, who is logged In, should have rights for the Sites for different Companies in User_Tranrights
6) The Company & Site is displayed based on User_Tranrights at the time of Login
7) The Module & its related menu get displayed based on User_rights, so make User_Tranrights & User_rights coherence
8) There is no need of Employee Information for the User who logged in, but must have data in Login_Mst
9) The data in User_Tranrights, User_SiteRights & User_Rights should be updated for the user concerned regarding Company & site
10) The Login_Mst should also be same for the User who is logged-inn. If User Login_Cdsr differs in different databases, it should be updated alike everywhere.
Steps
a) Enter information in DB_Connect table based on the requirement
b) At the start of the application, the Register setting screen will get displayed as previous, the only change is Company Option(Cdsr).
c) Enter the information from which you want to connect
d) This information is verified from the DB_Connect information at the time of Login
e) The initial information entered at first should be used by default
f) When User changes the Company, the system checks the information from Db_Connect table and connects the application accordingly( The registry information get updated)
ERP / ERA GROUP / 2