|
I would have thought a login / password system was already implemented, but if he did things the way I used to do them when I was starting out (before I discovered web services) I used to hardcore a login and password and then would query a table based off their login / password entry.
If you're going to do it that way, make sure the user you create to check that table has only access to read that tble and only that table, and use encryption in case they try to read your entire table.
|
|
|
|
|
I was meaning at a server level - using either windows authentication or create a user and generate a password. Either way, no access to the sql server means no reading the tables.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
As I mentioned to the OP, could always store the machine's serial number info in the database and have the app check against known values at runtime. If it doesn't find the machine's serial number in the database, just have the crap out without any warning [evil grin]...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Yep, that would work, although I prefer to prevent any access to the database... and then crap out 
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ashfield wrote: prefer to prevent any access to the database...
Perhaps just have a separate database for licensing purposes.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Could do. There are loads of options really.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi Thanks for your response and the ideas,
however,
lets also suppose the app is installed at a particular company, there is an administrator who has authority to access all sql dbs,
lets also suppose that the sister company can at any stage walk in, have a look at the software and then make copy of the software and sql db and take it with them...
how do i prevent this from happening...
i would think i need some sort of lic key generated that includes the licensed company...
any ideas>??????
thanks again
Anoop
|
|
|
|
|
Anoop Brijmohun wrote: thought about hardcoding the m/board serial number into the app(but this is not a good option)
You could have a separate table in your sql2005 database that stores the motherboard serial numbers of the machines that are allowed to run the app. Have the app check against known serial numbers in the database before running.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Hi,
for off-line copy protection the only solution AFAIK relies on some hardware characteristics. You must either choose built-in hardware or a separate protection device such as a dongle.
Choosing things the user can change (such as computer name) does not make sense to me.
Choosing things the user might want to change (CPU type, amount of RAM, disk serial number, etc) would be annoying: changing them for a good reason might break the software.
Baseboard numbers look great, except I was told they get stored in the BIOS and get lost when you upgrade your BIOS, resulting in all dependent software becoming useless.
So I would opt for an external piece of hardware. Dongles, costing a few tens of dollars/euros, are fine for expensive software. For cheaper software my first choice would be USB sticks, they all seem to have a unique serial number which you can retrieve through WMI (also as a regular user on Vista), and most users already have one or more USB sticks for other purposes anyhow. So have them provide their serial number, encode it in a license file, and have the app check the USB stick against the license file.
|
|
|
|
|
USB - now I didn't know that. You could actually get the user to register a USB and periodically (every couple of months) ask for a validation. If it fails they need to get in touch to register another USB and you can deal with that.
And then you have my position where corporate have disavled the USB slots on all machines 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
There are systems out there that use a USB stick to validate a program.
If the stick isn't present the program isn't going to start.
It has several advantages
- Program is licensed (biggest one for the programmer)
- The user can secure its usage (if he takes the stick out nobody else will be able to use it)
- It's not specific to a pc but per user so the user can install it on a differant pc and use the same stick (not at the same time)
- It's not that difficult (at least from what I hear (not my department))
- It's not expensive (just look at the price of usb sticks these days)
(Don't know why I didn't think of this when I posted my answer, we use it, must be the lack off sleep latly  )
|
|
|
|
|
Only trouble with using usb sticks, more and more corporates are disabling the ports to prevent unauthorised copying - particularly in the UK where there have been some high profuile data losses due to usb sticks. In my current client company any device plugged into a usb port gets automatically encrypted - not good for your ipod!
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Yeah but these sticks don't actualy hold data (from the company) they just hold a key and the program checks if the stick (so the key) is present.
The sticks themself can't be accesed so no data can be placed on them.
And I just found out that it's possible to have only 1 stick for an entire network so the stick could be plugged into a server in the server room that normally should be secure
Ashfield wrote: In my current client company any device plugged into a usb port gets automatically encrypted - not good for your ipod!
But but what will you listen to then
|
|
|
|
|
Hi,
You can have a separate table in your database that stores the processor ids of your machines that are allowed to run the app. Have the app check against with those ids in the database before running.
If you want more details,have a look at this article.
http://www.codeproject.com/KB/vb/hardware_Security_2.aspx[^]
good luck.
Believe!Success is always yours.
|
|
|
|
|
Hi,
I am using FtpXObjLib(Mabry Internet FTP/X COM Object) for copying a file from my computer to an FTPLocation. I am using below code for it
Dim objFTP As New FtpXObj
objFTP.Blocking = True
objFTP.Host = "ma****-1.corp.seic.com"
objFTP.LogonName = "*******"
objFTP.LogonPassword = "*******"
objFTP.Directory = "C:\Aleem"
objFTP.Connect()
objFTP.GetFile("Sample.exe", "myfile.txt")
As I have not been given the FTP location where to copy right now, I am testing the code with my compter as
objFTP.Host = "ma****-1.corp.seic.com"
when I run the application, it is passing from the statement
objFTP.Connect() so may be it is connecting using ftp, but giving exception at the statement
objFTP.GetFile("Sample.exe", "myfile.txt").
And the exception that I am getting is
'System.Runtime.InteropServices.COMException' occurred in SampleXceedZip.exe
Additional information: Invalid socket or not connected to remote.
Can anybody please help me to complete this task. In any way by giving a small code snippet or any links.
If any other .Net component is also available to do this task is also acceptable, if it not is not effecting the performance.
Thanks a Lot,
Aleem Mohammad.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
modified on Thursday, November 27, 2008 8:13 AM
|
|
|
|
|
Just a quiffer but maybe youre in the wrong directory / you have to fully qualify the filename with the directory?
What the hell is a quiffer...
|
|
|
|
|
I think you shouldn't be specifying any kind of drive letter specification in the Directory parameter. That should be the directory path on the FTP server, which won't expose any drive letters to you.
But, then again, since I've never used that library, I have no idea if that's true or not.
|
|
|
|
|
Agreed, don't most ftpd's store the ftp root in a config? That mean's (guessing now) you shouldn't have to specify any drive letter...
With any ftp'ing I've done (used .NET classes, never another third party addon) I never had to specify a drive....
|
|
|
|
|
Yes, I got it connected. Thanks for the help. But I am unable to copy the file from my location to FTP location.
Can anybody pleas help me in this. The below given is the code I wrote. Very much thankfull to you please help me in this. I tried with the put file and getFile both are not working can please anybody help me. I would be thankfull to them
objFTP.Blocking = True
objFTP.Host = "ssbse****"
objFTP.LogonName = "z***"
objFTP.LogonPassword = "Od***"
objFTP.Connect()
Label1.Text = objFTP.StateString
objFTP.GetFile("\\ssbseiathftp\Fileserver\Sample.W02", "\\ssbseiathftp\Fileserver\Sample1.W02") '''I am getting problem here
'objFTP.GetFile("C:\Aleem\Sample.W02", "\\ssbseiathftp\Fileserver\Sample.W02")
Thanks a Lot,
Aleem Mohammad
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
modified on Friday, November 28, 2008 2:21 AM
|
|
|
|
|
Well I assume GetFile saves a file from the location on the server to your machine, and you don't have a drive \\ssbseiathftp...
put it in a try catch and get the error it is giving you and post it
|
|
|
|
|
Why are you using the same path twice?? It looks like takes a source and destination path. The source would be the path that the FTP server makes available and the destination what file you want the file copied to on your machine. It plain old will not work if you specify the exact same path for both the source and destination filepaths.
Also, you seem to be under the impression that an FTP server makes the entire harddrive of the server available to you. This is NOT the case. You can only go to and use the files/folders in a subdirectory of the server that the FTP Server manages and makes available to you. You can NOT use just any path you want on the server and expect it to work.
|
|
|
|
|
I want an input from UserForm1 to be a Number.
I want to carry that number into UserForm2.
If, say that figure was 3, then I want either...
Three TextBoxes to open/be visible, OR
I want to ask for input on the Same TextBox 3 times, assigning each value to an array.
What I have at the mo is this...
UserForm one has a Text box asking for tbNumberOfUnits, and an Enter Button.
On Enter it checks that the value is a number not text, throws exception.
Assuming it is ok, it calls UserForm2 by "UserForm2.Show"
There is a CommandButton Begin on UserForm2
At this point I would like the value of tbNumberOfUnits to be called, but it appears not to exist in UserForm2.
Also, How do I create TextBoxes to the Desired amount?
Any help/pointers would be appreciated, I have checked a couple of books and can't seem tofind what I want, and also feel I may not be asking the right questions from Google.
------------------------------------
We hang the petty thieves and appoint the great ones to public office.
- Aesop
|
|
|
|
|
Hi,
Based on my understanding you want to pass value from one form and generate textbox dynamically.So you can have a global variable and store value in tat variable from userform1.and in the page load of userform2 generate as number of textboxes dynamically using for loop.Otherwise get input as many times and get in an array.Store the values in the DB by using arr(0),arr(1)... like that.
pls free to ask again if i have misunderstood your problem.
Believe!Success is always yours.
|
|
|
|
|
That is it in a nutshell.
------------------------------------
We hang the petty thieves and appoint the great ones to public office.
- Aesop
|
|
|
|
|
can you give me your requirement with your code
Believe!Success is always yours.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
