[Tehilah]

Hi all.

I am totally new to your site, so please forgive me if I don't play be the rules", it is not my intention."

Software developed in VB^with MS Access database.

I have developed a Karaoke player called KJ Player Pro. Been around for many years. I am trying to now automate the registration process of new clients. They require only their email address and cellphone number to activate the software on the net currently.

My problem is that the activation can be used more that once, unless I do the manual process of removing a small ini file from the internet.

Question:
Is is at all possible for me to :
* Create a small access or mysql db on the net
* Have me software access the db over the net
* once the ëmail"and "mobile"(username/password) has been confirmed, update a booelian value from false to true

This way, once a client has used the activation once, it will be flagged as üsed"

Please if anyone can give me direction on this, for I have been trying for months (intermittendly) and people are pirating my player in a huge way.

[modi123_1]

Quote

* Create a small access or mysql db on the net

I would recommend mysql or mssql. Multiple people hitting an Access db is rarely a good idea. You would need to host a database somewhere. Plenty of cheap hosting sites. Google for them.

Quote

* Have me software access the db over the net

Yes this is a common setup. You would embed the address to the database and a specific user name and password to route the the hits.

Quote

* once the ëmail"and "mobile"(username/password) has been confirmed, update a booelian value from false to true

Yes a small stored procedure can easily handle this.


There are plenty of tutorials here or just with a cursory search.

For example this shows the basics of connecting to mysql.
http://dev.mysql.com...b-handling.html

[Tehilah]

Thank you for the reply.

i do have an ISP. What should they do on there side please? I have one spare mysql not used by my Koomla sites ...

[modi123_1]

I am not sure what you mean. Are you planning on hosting this yourself at home or hosting it on a site?

You need to install MYSQL.
Create a table that keeps track of your input.
Create a unique login that has all the permissions locked down except to query that table.
Create a stored procedure that takes in your log in information.
Have your app connect (using that login info) to your DB.
Using that info check if that flag is set. If it is - do what ever. If not then update that row in the database.
Have your program react to the results.

[Tehilah]

modi123_1, on 18 March 2011 - 07:53 AM, said:

I am not sure what you mean. Are you planning on hosting this yourself at home or hosting it on a site?

You need to install MYSQL.

Thank you. The databse will be running on a website hosted by our ISP. How do they make the database available for my to connect to please?

I will create the databse using mysql on their server. Not sure how to connect to it. My site name = http://tehilah.co.za (New site, started building today)

This post has been edited by Tehilah: 18 March 2011 - 07:57 AM

[modi123_1]

I don't know the specifics of "how" they will do it - just tell them you want to be able to access your site's database openly. Go talk to them.

How to connect - well this is where your work starts, right? That link I provided gives examples of how to connect to a MYSQL database. There are the gripe of tutorials.

Heck there are even some here!
http://www.dreaminco...se-using-adodb/