Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Making standalone app. Browser enabled

Posted on 1998-06-03
Medium Priority
Last Modified: 2013-11-13
We have developed a financial quotation system in VB4.  It runs on stand-alone PCs, uses Access databases, performs financial calculations etc.

We have been asked to investigate the development of the system as a Browser enabled product, with it running on a Web server, the user interface will be a Browser.

It has been suggested that the server could be an NT 4.0 Server running IIS3.0 and the client would be Windows 95/98 running Microsoft IE4.0

We are thinking of developing this using Microsoft Active-X technology, but we are on  a steep learning curve.

So far we've got some vague ideas about this - We will change our VB forms into Active-X documents (written in  VB 5) on the Web server there will be a VB program performing tasks centrally.  We understand there is a Wizard to convert VB forms to Active - X.  Is it any good? How far will it get us? (I assume I'll have to upgrade my forms to VB 5 to use it).

I am curious about things like database access - will the bits that do this have to be on the server or will we be able to use database commands in the Active-X documents to get data from server.

We have been asked about VB script, what is it? and will we be needing to use it in the development.  Are there any good Web sites to read about this stuff.

I'd be very greatful for any suggestions/comments/answers - what we are trying to get together at the moment is an outline strategy - like do we need a complete re-write/re-design or can we convert?
Question by:deighton
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 1462385
Ok, here is where you should start:

1)  Take ALL your database access and move it to the server.  This will help keep your clients thin (no DAO required).

2)  Develop ActiveX DLLs or EXE to put on the server that does the DB access and returns the sets in collections of 2 dimensional arrays

3)  use Active Server Pages (since you are going to use IIS) to build your front end HTML.  This will give you netscape and IE support

4)  VBScript is basically a subset of VBA.  You can do a lot of the same things you can do in VB.

Basically, in Active Server Pages, you can run VBScript on the server or the client.  Since the client browser is unknown (and netscape does not like VBScript), you want to run it on the server.  This VBA will call your ActiveX Objects, get data, and build HTML to present it.  

If you are certain you only need IE support, then you can go with ActiveX documents.  These documents can communicate with the server via DCOM to get the data they need.

Expert Comment

ID: 1462386
It is better idea to put the database at the server side in your case.
There are three ways in which you can make your client communicate to the server which
ofcuorse, developable easily in visual basic. You can establish communication to the client and the server using winsock control, remote automation and through Dcom.
If you are totally build your application through VB then no need to know about ASP and VBscript.
You can make your client component as either activex control or as active document( well suported by IE and the web browser control provided with the vb).
Server component is going to be a activex exe in case of remote automation and DCOM.
server component can be standard exe with the winsock control.
Talking about ASP you can go for the book from the microsoft pree "Active server pages" a good one.
If you are interested in vbscript lot of books like Dummies which will give a good startup


Expert Comment

ID: 1462387
Sorry to reject your answer it has been of some help, as has anthonyc's comment.  There's a few things I'm not clear on yet.


You mentioned in relation to VBscript that it will build HTML pages - does this mean that we can avoid using (and therefore having to learn) HTML. ?

I'm not to clear on the meaning of 'Active Server Pages' please could you enlarge on this or give a definition?

A factor of Active-X that is attractive to us at the minute is that we understand that the components will be pushed out to the client and retained on his PC for future use, thus reducing future performance times. Therefore I'm very INTERESTED in what you said about using DCOM with MS IE only - we can specify the broswer that will be in use by the users.  Could you give any more details regarding this route.  You stated that Active-X documents can communicate directly with the server via DCOM, does this mean that we can open databases directly and use SQL for instance?  Could you explain DCOM we're unclear as to what it is.

I'd like to thank you both for your help so far, any further help you can give will be greatly appreciated. NB I've upped the points by a modest amount and I'll try to free up some 'lost' points I've got.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 18

Author Comment

ID: 1462388
Adjusted points to 130
LVL 18

Author Comment

ID: 1462389
Adjusted points to 150
LVL 18

Author Comment

ID: 1462390
Actually, to run your application from the WEB, there are many options:

1.  You can convert your VB application to EXE file, and run that file through HTML code.  Sorry, I do not remember the actual code, but I know for sure that there is an option to run any EXE file, provided you have necessary add-ins which your browser can support.

2.  Re-design your VB application using HTML, and VBScript.  As one of our friends above mentioned, VBScript is similar to VB, and there is nothing more additional to learn about that, but only the syntax of how to use the code along with HTML.  Sure, you must know HTML for this.

3.  Using Active-X controls and VB5.0

4.  Using Active Server Pages, this is also a similar software for developing web-based applications, through which you can design forms, access data from the database and even send data to the databases.

Try any of the above options, which suits you best, and let me know about what happended.

Accepted Solution

vamsi_k earned 300 total points
ID: 1462391
Thanks all for your help.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having just graduated from college and entered the workforce, I don’t find myself always using the tools and programs I grew accustomed to over the past four years. However, there is one program I continually find myself reverting back to…R.   So …
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question