Updating an online database through a VB program


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Updating an online database through a VB program

  1. #1
    Nick Jones Guest

    Updating an online database through a VB program


    I am writing a program that updates a database online - so that one can write
    news and articles offline, then upload them at a later date.

    I know how to download the database, modify it, then upload and over-write
    the existing database - but this would lead to problems with lots of people
    updating the database.

    Is there a way I can update the database without having to download and upload
    it each time through a VB app?

  2. #2
    Jose Saiz Guest

    Re: Updating an online database through a VB program


    "Nick Jones" <nickjones@eidosnet.co.uk> wrote:
    >
    >I am writing a program that updates a database online - so that one can

    write
    >news and articles offline, then upload them at a later date.
    >
    >I know how to download the database, modify it, then upload and over-write
    >the existing database - but this would lead to problems with lots of people
    >updating the database.
    >
    >Is there a way I can update the database without having to download and

    upload
    >it each time through a VB app?




    Have you tried ODBC but you have to make sure that the server you connecting
    you have rights to do so.

    if ask you hoster or provider to set you up for ODBC
    connection and use ADO with active server page within your vb app.

    hope this help
    Good luck


  3. #3
    JC Marin Guest

    Re: Updating an online database through a VB program


    Nick:
    I can safely assume that you have ruled out synchronization with what
    you are trying to do and without getting a full fledged DBMS system in place,
    which by the way would solve your problem right away, you would have to turn
    to some other type of system that will enable you to enter a record into
    some kind of database. My choice in this case would have to be the use
    of MTS as a "Host" at the server side and that process will do the database
    operations for you at the server as if you were physically there. You will
    have to create an ActiveX DLL that will be running in the address space of
    the server and with normal procedure calls you can enter and retrieve data
    from the database without having to connect to it from the client side.
    MTS will even do connection pooling at the server so that each caller doesn't
    recreate a new connection to the database. You still have a problem and it
    is that for each client requesting services an instance of the component
    will have to open a recordset at the server, so you might have to increase
    the amount of memory in the server. The beauty of the process is that you
    will be connected for just enough time to open the database and enter the
    record, then it closes and destroys itself, so depending on how many users
    you have you will not have as many concurrency problems. If you are not
    familiar with MTS you will have to learn quite a bit about it before diving
    in, but at least it is free because it comes with the WindowsNT 4 server
    Option Pack (I hope that it is what you are running at the server). I really
    hope this helps, if you need any more assistance I will be glad to help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center