help with sending simple databases between hosts
hello!
i'm a newbie to the forum and to VB as well. i'd like to send simple databases in between hosts/clients but am cluless as to where to start. i've been learning a little about ADO controls but so far i haven't encountered anything on sending the actual database in between machines. can someone enlighten me on this? i'd really appreciate any help i could get.
thanks!
alcyone
[434 byte] By [
alcyone] at [2007-11-11 7:51:55]
# 1 Re: help with sending simple databases between hosts
Do you want to access a MS database in a network or over the internet. If in a network then you can access the database through a shared folder, which may not be the best possible solution. Other wise you can use TCP/IP and send the data. For this you will need sever and client. You send the server messages and the server executes your messages and returns the results back to you. There is also the RDA control which alows you to connect to a database remotly.
major at 2007-11-11 17:26:15 >
# 2 Re: help with sending simple databases between hosts
well, thing is, i'm trying to do a program which simulates how the RIP routing protocol sends its updates (i.e. a router sending its whole routing table to its neighbors) using only pcs acting as routers. the updates are simple tables of network info which gets swapped in between hosts on regular intervals. i thought the best way to do that is simply to send the database as it is (just like how a real router does it). i hope you, or anyone, could suggest an easier way of doing it than i imagined.
thanks again!
# 3 Re: help with sending simple databases between hosts
I understand what you are saying. You still need an underlying connection between the computers connected to the network. Depending on how big your database is, it could lead to curruption if ur sending the database at regular short intervals. Personally i would suggest sending only the relevant records in the table rather than the whole database. This is just my personal option, there may be some one out there with a better solution. Sorry I couldnt help any further.
major at 2007-11-11 17:28:24 >
# 4 Re: help with sending simple databases between hosts
I assume you are taking CISCO classes! :p
Actually, if I remember correctly, I don't think RIP sends the database itself. I think, when they say it "sends the database", it actually replaces the routing table in the receiving router with the routing table in the sending router. OR, it deletes the data in the receiving routing table and replaces it with the data from the sending routing table. This is just a difference in terminology between networking engineers and developers but an IMPORTANT one, as you can see!
I could be wrong about this but you could send a little email to CISCO and ask them.
If I'm correct, you would have to delete the table in the receiving database and then export your table to it (or delete the data in the receiving table and then export your data to that table). This is a little tricky if you're a newbie as you stated but we (I include myself only as an attempt to massage my EGO!) LOVE to help!
Post what you have already (if anything). I'll see what I can find out about which method is used in broadcasting the router tables in RIP.
L
Laurel at 2007-11-11 17:29:18 >
# 5 Re: help with sending simple databases between hosts
DAYUM!!! I was WRONG again! (I hate when that happens!)
Look at this:
http://www.cisco.com/univercd/cc/td/doc/cisintwk/ito_doc/rip.htm
RIP sends routing-update messages at regular intervals and when the network topology changes. When a router receives a routing update that includes changes to an entry, it updates its routing table to reflect the new route. The metric value for the path is increased by 1, and the sender is indicated as the next hop. RIP routers maintain only the best route (the route with the lowest metric value) to a destination. After updating its routing table, the router immediately begins transmitting routing updates to inform other network routers of the change. These updates are sent independently of the regularly scheduled updates that RIP routers send.
If you REALLY want to do it the way the router does it, you are going to have to create a database, copy it to the other (networked) computer, and then evaluate each record in the table on the receiving database to see if the same record in the table on the sending database has changed. There are various ways to do this.
I'm sure you will have many differing opinions on how to do this in NO time. I'll reserve my opinion (and my EGO) until I see some of the other opinions.
L
Laurel at 2007-11-11 17:30:25 >
# 6 Re: help with sending simple databases between hosts
yes, i am taking cisco classes. :D
the flow of what i want to do is as you said. the updates have the entire routing table and the receiving router would only change the entries of its database if there's some new information. i'm not exactly sure how to copy databases from one point to another. that's where i'm stuck at right now. i hope anyone can help me write the code.
thanks so much for all the replies!
# 7 Re: help with sending simple databases between hosts
OK, let's get the terminology right first. The router is sending a TABLE. It's not sending the entire database (Let's assume the database has other junk in it besides just the routing table.....like packet header/footer information, timer information, holddown mechanisms, etc.) What needs to be sent to the other routers is the ONE table with the changed topology information in it. The receiving router has to evaluate what's sent to it to see if anything has changed.
Anybody wanna take it from here? I need to get to sleep!
alcyone, if you don't get replies tomorrow, I'll help you with it tomorrow evening (Sunday) or Monday morning when I get to work.
Laurel
Laurel at 2007-11-11 17:32:29 >
# 8 Re: help with sending simple databases between hosts
i might have scared people off with the wrong use of terms. yep, it's just a little table that i want to send in between hosts. thanks, laurel, for the clarification. :D
any suggestions are very much welcome. laurel, thanks! i'll be waiting. :)
alcyone
