|
HI Christian,
thnx for the super quick reply.
what do u mean by SS Instance?
can u please provide some URL where I can get more information about this.
I am more interested in using SQL Express than MS Access.
my only fear is ppl being able to view the complete database if they install Enterprise manager on their machine.
Regards,
Prady
|
|
|
|
|
ahujap wrote: what do u mean by SS Instance?
I just mean SQL Server. You can have more than one instance of SQL Server installed on one machine, there's the default and then you can have named instances.
ahujap wrote: I am more interested in using SQL Express than MS Access.
That's a wise decision, so long as you're ready for the extra headaches of deploying SQL Server.
ahujap wrote: my only fear is ppl being able to view the complete database if they install Enterprise manager on their machine.
They are no more likely to do that, than they are to install Access ( which more people have ) and open your MDB.
The main questions are:
1 - is this a rational fear ( i.e. are you hiding stuff you don't want people to see ? )
2 - how desirable is this data ( that is, to what lengths would people go to get it ? )
You log on to SQL Server. If you make sure the sa password is not blank, and make sure that the user doesn't know the SQL Server password ( which means you'll need to install a named instance, otherwise, you want to change the SA password on an instance they may have ), then make sure that information is hidden in your code. But, if your code is C#, then it can be found through reflection, so, again, the question is, how secure does it need to be ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Christian Graus wrote: That's a wise decision, so long as you're ready for the extra headaches of deploying SQL Server.
I think instalation of SQL Express can be bundled with application installer using VS2005, am I wrong?
Christian Graus wrote: 1 - is this a rational fear ( i.e. are you hiding stuff you don't want people to see ? )
Yes, application is about ppl attempting some coureware and then the results will be uploaded to server once they have internet connection on the machine.
So we dont want ppl to go to database and change results.
what do u suggest?
|
|
|
|
|
ahujap wrote: I think instalation of SQL Express can be bundled with application installer using VS2005, am I wrong?
I believe that ClickOnce may do that, does it also script the creation of your DB for you ?
ahujap wrote: Yes, application is about ppl attempting some coureware and then the results will be uploaded to server once they have internet connection on the machine.
So we dont want ppl to go to database and change results.
OK, so the database is on the server ? Or this is a client side app with a client side database ?
I'd write this as a web app, personally. Then, the database is hidden from them, and your server security will protect the database.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Christian Graus wrote: OK, so the database is on the server ?
nopes, database is on the client machine.
actually, one MAIN database is on server.
but this aplpication will use local database whenever user is not online.
and as soon as user gets online, data from local database will be sent to MAIN database on server.
Regards,
Prady
|
|
|
|
|
any pointers??
any help will be highly appreciated.
thnx
|
|
|
|
|
IF you have a local database, you're screwed. People will have reason to break into it, your code will be C#, so it will be visible through reflection, I don't see how you can get away with it.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
ohhh...
so, do u think password protected ms access database is my best bet?
|
|
|
|
|
No, I think a web app is your best bet. Password protected Access may well be second best. Or, if you could have just a central server, and store answers in an encrypted file, so they can't see what to change to change the result.
But, so long as it's C#, they can read your code.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
I need to have this stand alone app.
'cos the requirement of the project is to allow users to be abel to take tests when they are not online.
any suggestions?
|
|
|
|
|
I thought I'd made them. Put your database on the server, store your answers locally in an encrypted file, so if they alter the file, the server won't accept it. Send the answers to a web service when the app can find a connection. Accept that people who reverse engineer your code and create new encrypted files probably deserve to get good marks anyhow.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
agreed.
but the problem is,
there are too many fields and too many things to take care of.
so using flat files will be a big head ache.
thats why we need database.
we have thaught about using files but concluded that we will need to use database.
whats ur view?
|
|
|
|
|
I think I've stated my views often enough. Anyone can read your code, a password is easily broken. In fact, almost anything you do, will be broken reasonably easily, but just a password, that will be trivial.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
can i develop an application in -for example- VS2005 and run it over Linux, well i know about the mono-develop project!! but it's different from my requirement, am talking about full portability like in Java??
thanks in advance
Never stop learning!!
|
|
|
|
|
No, Mono is your only option.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
well i have a related second question -maybe it's stupid one-, i understand that Sun made JVM -Java Virtual Machine- to support portability for all O/S, but what i don't understand why Microsoft used also a Virtual Machine while their .NET applications are going to run only over Windows
|
|
|
|
|
I have no idea, I suspect it has to do with MS regardig the other 3% of the market to not be their problem. MS have said people are free to develop versions for other OSs, but Mono is the only one that's come to light, so far.
Perhaps it also has to do with multi platform being why every Java GUI app is a nightmare. Perhaps MS just didn't want to go there. What .NET does is multi language to a common framework, not a common framework for many platforms ( although it CAN do that, too, if anyone wants to do it )
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Well, he can code in VS2005 and just compile it with Mono - that's what I do. In many respects, Assemblies produced by MS's compiler are compatible with Mono too (you're asking for trouble if you execute them, missing dependencies, etc, etc, but you can probe them easily).
|
|
|
|
|
Hi.
I don't underestand what is delegate, and where is need !!
I'd read many papers ....
You know any refrence that describes it clearly ?
Best wishes
|
|
|
|
|
A delegate is a function pointer. An example of a delegate is a click event. If you place a button on your form class, that button defines a delegate, that is, a function signature. Your form class can subscribe to the delegate, that is, it can write a function with that signature, and tie it to the event. When your button class registers that it's been clicked, the code in your form class is called. so, delegates are a way for one class to call a method in another class.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
A delegate is a something like int,string etc used for functions.
Basically a delegate declares a type for a specific function signature.
Then using this delegate you can create a function pointer.of coarse target function signature and the delegate's function signature must much.
|
|
|
|
|
So I want to poll for example if program is in "C:\prog1\" I want to put this path in string at program start up, so i can manipulate files accoring to that as root folder?
|
|
|
|
|
It actually happened to me few times some files ended who know where when I only set file names in program and no path... (all work fine with absolute path but I don't want to hard code it) so I want to prevent this behavior?
|
|
|
|
|
string originalPath =System.Reflection.Assembly.GetExecutingAssembly().CodeBase;
will this work for you.
this gives full path of ur exe file u have to parse to get the path only.
|
|
|
|
|
Application.ExecutablePath, I believe. It's something like that.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|