DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Options for DB on web server rather than LAN

  1. #1
    Jeff Rhodes Guest

    Options for DB on web server rather than LAN

    We have a VB6 "Administrator" program that currently uses ADO 2.5 to connect
    to an Access DB on either the local machine or LAN server to add/edit
    various tables and records. In the new version, the DB can be either Access
    or SQL Server and can also be on a web server. I'm looking for suggestions
    on how to handle the web server part. We frankly don't want to go to
    tremendous effort with this release, but would like to see what our options
    are. Questions are:

    1. Is it possible to use ADO to connect directly to the DB while on the web
    server? If so, can we still bind text boxes, etc. to various tables/queries?

    2. Does the answer to the above change with SQL Server versus Access
    databases?

    3. If we decide to go with a more "low tech" solution, can anyone recommend
    a third-party control or approach for ftping the DB locally, editing it, and
    the reuploading?

    Thanks very much for any ideas!



  2. #2
    Michael Crawford Guest

    Re: Options for DB on web server rather than LAN


    Hi Jeff,
    You can connect to a database on a webserver just the same as you do a lan
    server. The webserver will have an ip address just as your lan server does.

    For example:
    set x = createobject(activex_dll, "WEB_SERVER_IP_ADDRESS")
    or just point your connection object to an ODBC connection.

    Connecting to an SQL database is slightly different than an access database
    in general terms, but connecting to an SQL server on a webserver will be
    no different than the above example.

    In either case you can still bind your textboxes.

    I can help you further If this is something you want to go ahead with.

    Regards,
    Michael.

    "Jeff Rhodes" <jrhodes@plattecanyon.com> wrote:
    >We have a VB6 "Administrator" program that currently uses ADO 2.5 to connect
    >to an Access DB on either the local machine or LAN server to add/edit
    >various tables and records. In the new version, the DB can be either Access
    >or SQL Server and can also be on a web server. I'm looking for suggestions
    >on how to handle the web server part. We frankly don't want to go to
    >tremendous effort with this release, but would like to see what our options
    >are. Questions are:
    >
    >1. Is it possible to use ADO to connect directly to the DB while on the

    web
    >server? If so, can we still bind text boxes, etc. to various tables/queries?
    >
    >2. Does the answer to the above change with SQL Server versus Access
    >databases?
    >
    >3. If we decide to go with a more "low tech" solution, can anyone recommend
    >a third-party control or approach for ftping the DB locally, editing it,

    and
    >the reuploading?
    >
    >Thanks very much for any ideas!




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