What's up everyone? My colleague and I have been discussing an issue that we think we have a solution for. Just looking for some input on it, to see if anyone else did anything similar. Basically right now, we are in a main office. We have a bunch of employees with Laptops around the country. We use a purchased program that creates a remote connection to the laptop through thier IP Address. If they are on a dial-up connection, it's absolutely dreadful. They have a local Access database that we like to run queries off of. We have an in-house program that does this installed locally on their machines. However, because of the dial-up connections, it takes forever to open up this app, and run what we need. We also have an intranet site set up that everyone accesses.
Here is our proposal.... We would like to create some type of Java service that runs on the machine. We want to have something on our machines that we can run that will send commands to this service over IP. Basically, send a SQL statement or something to the specified IP Address.. We want this service to pick up this request, run the SQL, and then send us back the results. Anyone have any ideas on this? We have some initial ideas on what direction to take, but we're very open to suggestions. Thanks in advance all!
Doug
Here is our proposal.... We would like to create some type of Java service that runs on the machine. We want to have something on our machines that we can run that will send commands to this service over IP. Basically, send a SQL statement or something to the specified IP Address.. We want this service to pick up this request, run the SQL, and then send us back the results. Anyone have any ideas on this? We have some initial ideas on what direction to take, but we're very open to suggestions. Thanks in advance all!
Doug