Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert MS Access application into a Web app. (VB6 & DB2)

    I have an application that was created with VB6 for the Front end and MS Access to store the data. I have been asked to look into converting this desktop application into a Web based application. Can anyone tell me what I am looking at? We have created the tables in DB2 and using VB 6 we can create/update the forms(data).

    Where would I have to look to see about moving this into the Web. What software and hardware would we need.

    Thank you

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert MS Access application into a Web app. (VB6 & DB2)

    There are a number of web/database technologies available, including ASP, PHP, JSP, etc... (like alphabet soup).

    I find ASP/ADO one of the best languages to work with, primarily because of my VB/VBA background. You can use any application to write ASP files - even Notepad! If you have Visual Studio 6, Visual Interdev is the best app to use for this. If you have VS.NET, it's all integrated into the same interface. (FYI: You can still write traditional ASP with VS.NET. You're not forced to use ASP.NET, although most of the helpfiles are geared toward .NET.)

    I used Microsoft Script Editor (comes with Office 2000 and 2002) before purchasing VS.NET. For Office 2000, look for MSE.exe (mine is in Program FilesMicrosoft Visual StudioCommonIDEIDE98). For OfficeXP, look for MSE7.EXE (mine is in Program FilesMicrosoft OfficeOffice 10).

    On the server side, ASP only runs from IIS (3.0 and later). For Database access with ASP, you'll need MDAC and JET drivers (see http://www.microsoft.com/data).

    ASP can be long and tedius to write, but I enjoy working with it!

    A few websites that have helped me:
    4 Guys from Rolla
    Learn ASP
    W3 Schools

    HTH <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert MS Access application into a Web app. (VB6 & DB2)

    I have a book call "Visual Basic 6 - Unleashed" by Rob Thaer. In it they talk about using Active X Documents in Visual Basic to create component-based applications. That way they can be used either on the desktop or the Internet without a separate interface for each.

    Will I need to have a dedicated server for this to work?


    I am a beginner in VB so I need to keep this as simple as possible.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert MS Access application into a Web app. (VB6 & DB2)

    I'm not familiar with Active X Documents, but I imagine it would be much more difficult and time-consuming to create a COM application to work both on desktop and internet. This is actually something that becomes a bit more of a reality with .NET.

    It's really quite easy to connect to a database with ASP (via ADO). I can't imagine that creating the ActiveX Documents would be any simpler.

    As for hosting an ASP application, any shared web server with IIS can host this - no need for a dedicated server. If your database use is significant, however, you might consider using SQL server for back-end rather than Access.

    I'll step aside now and let others share... <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert MS Access application into a Web app. (VB6 & DB2)

    This is all very good information and we will start looking into this. One other thing is we will not use any SQL server or Access. We plan to go directly into IBM DB2. At this time we have created some forms in VB6 and we can create/update the information directly to the different tables.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert MS Access application into a Web app. (VB6 & DB2)

    Daniel,

    From what I've seen of .NET (VB.NET and ASP.NET) it may be a lot easier upgrade than ASP current version. ASP.NET looks very much more impressive than its predecessor.

    But I'm only going on a cursory knowledge.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Convert MS Access application into a Web app. (VB6 & DB2)

    To the best of my knowledge there is no connectivity available from ASP 3.0 pages to DB2. (If you use ASP.NET this may not be the case.) You will either have to resort to using an ODBC driver and making a permanent connection, where you are likely to run afoul of MDAC or ODBC problems, or you will need to use an IBM supported technology.
    Wendell

  8. #8
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert MS Access application into a Web app. (VB6 & DB2)

    Using VB to DB2 we have to connect using and ODBC drivers. Right we are hard coding the connection (UserID and Password) to the DB2. Later we will create a login window to hand this. This setup was working great until they told us to convert so we can go through the web.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •