Registration using vb script and access

[LordyLordy]

Hi All,

Got quite a large question here in terms of complexity, sorry!

I'm trying to develop an application that is going to take a scrambled code from an ASP page. The code gets descrambled and ends up being two separate codes (hard drive number and serial number).
I then want the program to check using an access database whether the hard drive number has been registered against the serial number.

Basically the database will have a list of serial numbers already in it, so in theory I just need to check to see if the hard drive field is null or not for that particular number. But then if it is empty, register it and bring back another asp/html screen saying "it's registered" and obviously if it finds that the hard drive field in the database is full, for another page to say "this serial number has been registered"

First of all, is this possible?
Second can this program be written in VB and then turned into VB script through Visual Basic 6?
Third Can anyone give me any tips on how to do this!

I'd be very grateful for any help

 

[Bastien]

Hi Lordy,

yeah, its possbile and relatively easy. just break it down into several small managable components and build it.

on registration hit the db
select the hard drive field
if the field is null
redirect to the registration page or sub if using a self referencing page
else if the field has a value
redirect to the already registered page or sub
end if

you can use VB by creating it as a COM object (create the VB as .dll file and registering it on the server) this only really hides the SQL and Db connections to make the db a little more secure. What you need to figure out is if the host will left you install a custom dll file on the server.

Straight ASP will also do the trick.

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[LordyLordy]

Cheers Bastien