vb6 Client Server Application

[Jacques01]

Hi Guy's

I've wrote a application in vb6 with a MS Access Database using ADDOC Controls.

This works 100% as a standalone but I need to Change this to a Client/Server application, or basicly I need to install the Database on one of the Machines and have 3 or 4 other machines using that Database and would not like to use another one

Please Guy's and GIrls I only do this as a Hobby and have never even had a manual and can use your help

PLEASE,PLEASE, Very Desperate.

Regards

[jhardman]

I've used a couple different styles of client/server apps, and I have decided that I prefer those that communicate via web service. They are easy to troubleshoot and network and don't require a lot of added programming.

Have you ever looked into web services before?

Jared

[Jacques01]

I found that removing the Adodc crontrols from my forms and using code to access my Access database work 100% better .its faster and I can Update the same table.I open the application about 10 times at the same time running the same funtion on all the applications opened(with a RND module I added in)
and I had no Problems.

Questions is will this would in a real enviroment ,having the database on one machine and installing the application on oyhers.

Have not Tried Webbased before is one of my goals...we should I start? what application, etc . 100 of Questions

Many thanks
Really thanks a million - it's great to know there is someone who can help.

Jacques

[jhardman]

I found that removing the Adodc crontrols from my forms and using code to access my Access database work 100% better .its faster and I can Update the same table.I open the application about 10 times at the same time running the same funtion on all the applications opened(with a RND module I added in)
and I had no Problems.

Questions is will this would in a real enviroment ,having the database on one machine and installing the application on oyhers.

Theoretically: it should work, you can communicate to a db on a remote computer almost as easy as communicating to a db locally, there's no reason you would have to do anyting radically different, I just find web services very easy to troubleshoot and use.

Have not Tried Webbased before is one of my goals...we should I start? what application, etc . 100 of Questions

I switched to C# the same time I started writing web services, so I've never actually made a web service in VB, but it should be very easy. If I were you, I would start by downloading "Visual Web Developer" from microsoft, there is a free "express" version. You should be able to write web services in VB using VWD, just note the actual web service needs to be hosted like a web site (so make sure IIS is running on a computer that can reach the db).

Then google (or "bing" if you are so inclined) "web service VB tutorial", there are probably hundreds of code examples on the net. Basically the web service is a list of methods (functions or subroutines) that a remote computer can call via http. So all you have to do specify the methods that the client computer will call and program them in the web service. Once the web service is running, you reference it in your client program, and VB will pick up what arguments it needs to pass and what the response should be. Let me know how far you get, and I'll see what I can do to help move you along.

Many thanks
Really thanks a million - it's great to know there is someone who can help.

Jacques

No problem, Jacques. I hope I can be of help, and if not I might be able to refer you to someone who can.

Jared

[Jacques01]

Hi Jared

the problem is that the Application I Working on in vb is for Schools tuckshop and I think that the vb6 frontend will be a bit faster as wabbased(These Guy's have slow machines and the Sales must go Fast you know Kids.)and I don't wanna give in to this problem as Yet.

As for VWD Dawnloaded it this Morning and YES I am going to try it , it's going to take some time to get used to.But we'll see

Regards

Jacques

[jhardman]

Hi Jared

the problem is that the Application I Working on in vb is for Schools tuckshop and I think that the vb6 frontend will be a bit faster as wabbased(These Guy's have slow machines and the Sales must go Fast you know Kids.)and I don't wanna give in to this problem as Yet.

If you want, just check out your db connection string. You should be able to modify it to go to a remote-hosted db, rather than go through any server app. From what you are explaining, I don't think a server app is actually necessary. If you want to go that direction, I think it will be an easier conversion from what you already have, and I could take a look at your connection string if you want help with that.

As for VWD Dawnloaded it this Morning and YES I am going to try it , it's going to take some time to get used to.But we'll see

Regards

Jacques

I bet it will be easier than you think. Good luck.

Jared