Click here to Skip to main content
15,885,309 members
Home / Discussions / C#
   

C#

 
GeneralRe: ComboBox events Pin
elena1234513-Jan-04 8:09
elena1234513-Jan-04 8:09 
GeneralRe: ComboBox events Pin
Heath Stewart13-Jan-04 8:49
protectorHeath Stewart13-Jan-04 8:49 
GeneralRe: ComboBox events Pin
elena1234513-Jan-04 10:14
elena1234513-Jan-04 10:14 
Generalunzip zip file Pin
murali_utr13-Jan-04 6:00
murali_utr13-Jan-04 6:00 
GeneralRe: unzip zip file Pin
Judah Gabriel Himango13-Jan-04 6:14
sponsorJudah Gabriel Himango13-Jan-04 6:14 
GeneralRe: unzip zip file Pin
murali_utr13-Jan-04 9:20
murali_utr13-Jan-04 9:20 
QuestionLicensing solution per SQL Database? Pin
Alex Korchemniy13-Jan-04 4:56
Alex Korchemniy13-Jan-04 4:56 
AnswerRe: Licensing solution per SQL Database? Pin
Heath Stewart13-Jan-04 5:39
protectorHeath Stewart13-Jan-04 5:39 
So basically you want to license the database itself? We have a similar setup with our flagship product where a single database manages the accounts that can access each of the company databases (or sub-office database in your case). Similar to you, we allow unlimited user accounts. You could even forego this and just use Windows Authentication using SSPI. The thing that maintains how many people can access each database at a time is a .NET Remoting object that caches the current license count for each company (just in case the Remoting object shuts down or something). It hands out licenses and takes care of decrementing those counts when a client disconnects. The latter part is problematic, however, since if your client application crashes there's not really any good way to decrement the count since the clean-up code didn't run. If you don't have to expose your Remoting object through IIS in order to hang-off port 80, you could always poll clients by implementing your own ILease and returning that in GetLifetimeService.

As far as limiting connections in SQL Server, all you can do is limit licenses for a SQL Server instance, but that's nothing that a DBO couldn't change.

 

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
GeneralRe: Licensing solution per SQL Database? Pin
Alex Korchemniy13-Jan-04 5:49
Alex Korchemniy13-Jan-04 5:49 
GeneralRe: Licensing solution per SQL Database? Pin
Heath Stewart13-Jan-04 5:52
protectorHeath Stewart13-Jan-04 5:52 
GeneralConvert HTML to PDF Stream into DB Pin
Regardt13-Jan-04 2:54
Regardt13-Jan-04 2:54 
GeneralRe: Convert HTML to PDF Stream into DB Pin
Alex Korchemniy13-Jan-04 4:48
Alex Korchemniy13-Jan-04 4:48 
GeneralRe: Convert HTML to PDF Stream into DB Pin
Heath Stewart13-Jan-04 5:32
protectorHeath Stewart13-Jan-04 5:32 
GeneralCustom permissions Pin
Hans Ruck13-Jan-04 1:43
Hans Ruck13-Jan-04 1:43 
GeneralRe: Custom permissions Pin
Heath Stewart13-Jan-04 5:30
protectorHeath Stewart13-Jan-04 5:30 
GeneralRe: Custom permissions Pin
Hans Ruck13-Jan-04 22:21
Hans Ruck13-Jan-04 22:21 
Generalaxwebbrowser excel mdicontainer Pin
mylitziname12-Jan-04 22:28
mylitziname12-Jan-04 22:28 
GeneralRe: axwebbrowser excel mdicontainer Pin
mylitziname12-Jan-04 23:24
mylitziname12-Jan-04 23:24 
GeneralEnvironment variable Pin
cfl12-Jan-04 22:03
cfl12-Jan-04 22:03 
GeneralRe: Environment variable Pin
mylitziname12-Jan-04 23:33
mylitziname12-Jan-04 23:33 
GeneralRe: Environment variable Pin
Heath Stewart13-Jan-04 5:15
protectorHeath Stewart13-Jan-04 5:15 
GeneralRe: Environment variable Pin
cfl13-Jan-04 15:42
cfl13-Jan-04 15:42 
General.NET version dependent compilation Pin
brain2cpu12-Jan-04 21:09
professionalbrain2cpu12-Jan-04 21:09 
GeneralRe: .NET version dependent compilation Pin
Heath Stewart13-Jan-04 5:12
protectorHeath Stewart13-Jan-04 5:12 
QuestionDragDrop to a native window? Pin
TuringTest112-Jan-04 19:20
TuringTest112-Jan-04 19:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.