Small Database

[wittfield2000]

Hi all,

just enquiring as to how i would go about making a small database using VB.

Initially i am receiving data via UDP. Those data packets will be containing an IP address and a 4bit binary number.

I wish to make a database which will already contain the binary code. So when the data comes in i need to log the IP address next to the corresponding binary code which came in the packet with it. (If that makes sense)

A user will then do a search to see what IP address is next to which binary number they choose(once again i hope this makes sense)

Any info anyone could give in regards to how i can do this would be great!! Or even any resources which may be of use to me in this case.

Thanks again
Chris

[phinds]

from the little you describe, I'd say you don't need a database at all, just a flat file

[wittfield2000]

The reason i thought i needed a database was probably not explained very well. Sorry about that..

The user will be selecting a name, not a binary number. This name will correspond to a an ID number in a table in the database. This ID will then match an ID in the table which had the IP address next to the binary code.

Once the IP address has been obtained it will then be referenced( as each IP will correspond to a physical location ) This location will then be displayed to the user.

I hope this makes some sense!!

The application i am making is for a locating system. I have a web coprocessor which will send UDP packets over a LAN. These packets will contain the IP of the coprocessor and a 4 bit binary number. The app will receive these packets and put the info into a database. A user will then come along and access the app. The user will select from a range of names which will be related to a particular binary number. So when they search for the last known location they are really looking to see the last known IP.(hope this all makes sense)

Anyway thansk again. If what i am saying isn't right PLEASE let me know where i am going wrong!!!

Thanks

Chris

[phinds]

I say again, based on what you have said, it seems to me to be ridiculous overkill to use a database for something so trivial. Just use a flat file.

[wittfield2000]

OK then.

So how do i go about it. I am not an expert at this so i dont have much of an idea.

Thanks

Chris

[phinds]

sorry. if you are unfamiliar with even how to create a flat file, then you really need to study fundamental programming some more. I don't mean to be rude but you are asking for a tutorial on really fundamental stuff.

There is a "sandbox" project at the link below my name that has examples of how to create flat files. perhaps that would be a good place to start.