distributing a VB app

[Playmaker]

I have a VB database program that I want to now distribute to clients. I'm not sure of how to do this. I have a Window NT server with SQL 7 and 20 workstations that will use the program. How do I go about setting up the application on the server and allowing the client stations to access it. Do I need to install VB 6 on every machine? Thanks.

Eddie

[sushant]

If I assume that your environment is as follows:

1. You have a NT machine and VB is loaded in it.

2. SQL server is also loaded in this machine and you are acessing the database from the same machine.

Then you can do the followings

1. make a registry of your own where you can store the server and the database name. And hence modify your program to access the database from the server and database specified in the registry.

2. Create scripts for the tables and the standing data in your database. Some softwares are available for doing this. Or you can write by yourself.

3. If your client is using WIN'95, then you have to compile and make package your application in a different machine which has win'95 and VB5.This is because, some winNT files don't work on Win'95 machine.

4. Don't forget to keep the same registry in your client's machine. You can export the part of the registry and put in the setup program.

5. Now create a database in your client's server and according change the servar name and the database name in your client's client machines.

6. Now setup your application in your client's client machines and ENJOY!!

N.B. You need not install vb6 if you are using vb5 and RDO in your softwre.

For further help feel free to mail me sushant@writeme.com