Click here to Skip to main content
15,906,463 members
Home / Discussions / C#
   

C#

 
AnswerRe: Arabic / SQL Pin
dan!sh 15-May-09 20:01
professional dan!sh 15-May-09 20:01 
QuestionHow to compare two dates...???? Pin
harishkharvi15-May-09 16:50
harishkharvi15-May-09 16:50 
AnswerRe: How to compare two dates...???? Pin
Luc Pattyn15-May-09 16:57
sitebuilderLuc Pattyn15-May-09 16:57 
QuestionTableAdapter not inserting new row Pin
Shato15-May-09 16:35
Shato15-May-09 16:35 
AnswerRe: TableAdapter not inserting new row Pin
Mycroft Holmes15-May-09 17:11
professionalMycroft Holmes15-May-09 17:11 
QuestionHow to code for import pdf to database with c# Pin
nomsod15-May-09 15:53
nomsod15-May-09 15:53 
QuestionCopying files needed for a program installed with a VS Setup and Deployment project Pin
choo_chu15-May-09 14:06
choo_chu15-May-09 14:06 
QuestionPointers Ideas and examples please Pin
Bryden.Murdoch15-May-09 13:21
Bryden.Murdoch15-May-09 13:21 
Scenario : client server application. vb6 client side application to Microsoft SQL server database.
all clients have registry keys to provide odbc connection to a database holding available environments.
Once a user has selected the environment they require the specific odbc string is supplied from this master to the specific db for the selected environment and the master plays no further part.


Problem : because every user selects from the same list all connections are listed under the same user in SQL making life very difficult to resolve locking issues that occure.
The use of windows integrated logins is not possible as i have no access to the application code and we need to prevent r/w access to the environment databases from say office applications.


Solution : I am therefore considering implementing a wrapper for the client application to generate individual sql logins and account in the master DB so that the connections can then be distinguished in SQL.
The wrapper will need to talk to a service that will have the relevant sql access to create / disable / enable the logins.

Question : with all this said can I please have relevant pointers / ideas / examples to first create this service that will need to talk to SQL via a dedicated admin account and also to clients on the network probably via IP using again probably XML.

I am not looking for spoon feeding as I enjoy learning in this hands on method just places to go / articles and examples that explain principles that I can then adapt.

Thanks for the assistance

Bryden

P.S I do realise that this will not be a walk in the park and that I could probably have posted this on a number of different forums but I plan on using c# unless advised differently.
AnswerRe: Pointers Ideas and examples please Pin
Mycroft Holmes15-May-09 13:46
professionalMycroft Holmes15-May-09 13:46 
GeneralRe: Pointers Ideas and examples please Pin
Bryden.Murdoch15-May-09 14:03
Bryden.Murdoch15-May-09 14:03 
GeneralRe: Pointers Ideas and examples please Pin
Mycroft Holmes15-May-09 17:06
professionalMycroft Holmes15-May-09 17:06 
Question[Message Deleted] Pin
sjmclean15-May-09 12:47
sjmclean15-May-09 12:47 
QuestionRe: IP in Text Box Pin
harold aptroot15-May-09 12:57
harold aptroot15-May-09 12:57 
Questiondataset Simple sort. Pin
udikantz15-May-09 12:13
udikantz15-May-09 12:13 
QuestionCan i use web space in C# project? Pin
abhishek2915-May-09 9:26
abhishek2915-May-09 9:26 
AnswerRe: Can i use web space in C# project? Pin
DaveyM6915-May-09 9:59
professionalDaveyM6915-May-09 9:59 
AnswerRe: Can i use web space in C# project? Pin
EliottA15-May-09 11:46
EliottA15-May-09 11:46 
GeneralRe: Can i use web space in C# project? Pin
abhishek2926-May-09 9:08
abhishek2926-May-09 9:08 
GeneralRe: Can i use web space in C# project? Pin
EliottA26-May-09 9:20
EliottA26-May-09 9:20 
GeneralRe: Can i use web space in C# project? Pin
abhishek2926-May-09 17:55
abhishek2926-May-09 17:55 
QuestionMDI parent form maximize problem Pin
atifamin200215-May-09 9:15
atifamin200215-May-09 9:15 
AnswerRe: MDI parent form maximize problem Pin
DaveyM6915-May-09 9:44
professionalDaveyM6915-May-09 9:44 
QuestionBackground worker Pin
Payam Rastogi15-May-09 6:54
Payam Rastogi15-May-09 6:54 
AnswerRe: Background worker Pin
DaveyM6915-May-09 9:50
professionalDaveyM6915-May-09 9:50 
GeneralRe: Background worker Pin
Payam Rastogi15-May-09 9:57
Payam Rastogi15-May-09 9:57 

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.