SQL License Key Integration

[foxprox558]

Hello, once again. I would like to write a simple-license key validation that will run from my DryCleaning program to my SQL server on my computer (It should not be over-complicated, I have a static IP) with an SQL table that has only 4 fields per record:
1-Key Code
2-Active/Inactive
3-How Many times it can be used
4-How many times it's been used.
I have no experience with SQL, any help would be much obliged.

 

[Mike Lewis]

What exactly do you want to know?

You mentioned a static IP address. Are you asking how to find the IP address of the computer on which your program is running? If so, this might help:

http://www.news2news.com/vfp/?example=506

If that's not what you want to know, perhaps you could clarify your question.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[foxprox558]

No, I don't need the IP of the remote at all. I HAVE the IP of the host (Me) but I need the Remote (Them), each time the program opens, to check the entered license key (Stored on THEIR local system) if it is valid for the Host (My System). But I don't know how to work SQL at all, that's what I'm asking.

 

[Mike Lewis]

But I don't know how to work SQL at all, that's what I'm asking

OK, so your question has got nothing to do with licence keys or IP addresses. You want to know how to "work SQL". Is that right?

If so, that's a very vague question. SQL is a complete language in its own right, integrated into VFP. It is also the language used by the majority of back-end database servers, such as MySQL and Microsoft SQL Server. You can access these databases from VFP via a variety of methods.

I suggest you read the relevant topics in the Help file. Then, if you have any specific questions, come back.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

Using your computer for checking license keys has more to it than learning SQL or setting up an SQL Server. You have to learn about security and other stuff. This is nothing you do that way, license checking is something I would always solve by using a third party product and the expert knowledge inside it.

Bye, Olaf.

 

[craigber]

Do not expose SQL Server to the Internet. You're asking for trouble. That means you have to find a different way of doing this. Look at web services.

Craig Berntson
MCSD, Visual C# MVP,

http://www.craigberntson.com/blog