473,387 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

vb6 Client Server Application

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
Jul 8 '09 #1
5 3392
jhardman
3,406 Expert 2GB
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
Jul 9 '09 #2
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
Jul 11 '09 #3
jhardman
3,406 Expert 2GB
@Jacques01
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
Jul 13 '09 #4
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
Jul 13 '09 #5
jhardman
3,406 Expert 2GB
@Jacques01
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
Jul 13 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Matt | last post by:
I think this is the basic concept in ASP server-side development. My boss told me web application is NOT client-server application. I argued with him because browser is the client, and the server...
2
by: Microsoft | last post by:
I'm about to start converting my application from a old-style monolith exe (with flat files and limited database support for sharing some of the data) to a layered .NET SQL server version. I have...
18
by: cjl | last post by:
Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure...
4
by: Prince Kumar | last post by:
I joined a company recently and they have a java program which hangs (does nothing) after a while. This is no way consistent. It could succeed quite a few times and can fail a few other times....
11
by: Timothy Shih | last post by:
Hi, I am having a freezing issue with my application. My application serves several remotable objects, all of which must be initialized before their use. Furthermore, some of them depend on each...
6
by: Ken Allen | last post by:
I am relatively new to .Net and C#, but I hav ebeen programing in other languages and done some COM work for a number of years. I am attempting to understand how to map an older program...
12
by: ShepardBerry | last post by:
This may be a dumb question, but I'm not finding anything specifically what I'm looking for. Still kind of new to .NET as well. What I'm trying to do that I know I could do in VB6.0/ASP is to...
10
by: Ben | last post by:
Hi, I made an application in classic asp (reservation of books and video stuffs for students) and want to migrate to asp.net. The user has to chose a date, then pushung on a submit button. The...
22
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...
2
by: Wimpie van Lingen | last post by:
Hey I have some more questions with regards to Remoting in .NET 2. I'm using TCP with the Binary formatter. My solution consists of 4 projects: - Class Library containing the server classes...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.