June 11, 2008 at 6:27 am
i have a financial software using sql data base i need a way to use a centralized database for more than one location so each user can connect to this data from diffrent offices
June 11, 2008 at 1:29 pm
What is your question?
June 12, 2008 at 4:27 am
my question is there any technic that i can use to work online connecting to one database using sql server, to run my application from diffrent location using the same database, centralized database
June 12, 2008 at 4:45 am
yes there are ways,
What sort of network does your organisation have?
June 12, 2008 at 4:48 am
we have customers that we need to connect them so its depend on the customer but at most they have microsoft windows server 2003
June 12, 2008 at 6:11 am
You could steup some API calls to your SQL server, put these APIs on IIS that is located on the same network as your SQL server.
The customer applications can then access these APIs via the internet to interact with your DB. This would allow for control over what people can access rather than exposing SQL straight to the Internet.
June 12, 2008 at 6:19 am
It doesn't sound like there is anything you are doing that's strange. Almost everyone connects to a central SQL Server database in some way with their application.
If you're unsure, it sounds that you might not be the person to design or set this up. Most likely you would do well to engage someone with more experience that can help you learn how this works and get it set up.
If you describe more about what you are doing technically, we're happy to present more information.
June 12, 2008 at 7:17 am
Dear steve thank you
here is more information about what im looking for.
i have an financial application created using visual basic 6.0 and the database is sql, what im looking for if i want to install this software at some company but at diffrent locations all the users should access the same database at the same time cause this software is multi user at the same network but if i have a geographical distance im looking to connect the same company at the same database
King Regards
June 12, 2008 at 8:04 am
Might have to setup something like a web service to run on an intra net... lot's of folks do such a thing... Talk to anyone who writes ASP.Net or Java for the internet.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2008 at 6:54 am
Sounds more to me like there's a customer here with geographically dispersed offices who doesn't already have connectivity between those offices. Establishing that in such a way that a VB6 application can look at the same server from any given location probably means having an ODBC connection to that one server from each and every user, regardless of location. The only way I can see that happening is if the customer involved sets up, at minimum, a secure VPN connection to each of their offices from the one where the server will be located. While there are inexpensive ways to do that, having the least expensive DSL connection in each location might not be enough in the way of bandwidth to reliably support the objective. My guess is most of the secure VPN solutions use network "keep alive" packets and these usually need a reasonably fast connection as opposed to the relatively low speeds associated with basic DSL. In this case, upstream bandwidth becomes just as important as downstream. I'd go looking for a vendor that sets up VPN networks and get their expertise. It won't be cheap, but it will probably be far more reliable than trying to establish some kind of web service, which might require significant recoding of the application to deal with it.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 13, 2008 at 7:10 am
The VPN suggestion is one way, but it would be costly and maybe difficult to convince your clients to set up all this infrastructure to get your application working.
You would be better off modifying your application to take advantage of API calls via a web service, and set up a web service to talk to your database. A .Net developer should be able to do this a lot cheaper than setting up VPNs.
At any rate it seems like you may need to hire a consultant with expertise in this area as you may not get the magic easy solution from here.
June 13, 2008 at 7:40 am
I'd like to see a financial application do any sizable report without performance issues where a web API provides the connectivity before concluding that anything less than VPN is sufficient to meet the performance expectations of a client that may not have been stated, but are likely to appear after implementation - especially if basic navigation or similar simple tasks aren't nearly instantaneous response situations.
Call me skeptical...
Steve
(aka smunson)
:ermm::ermm::ermm:
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 13, 2008 at 7:56 am
Fair enough, VPN would be the case if large amounts of data is to be transferred.
Financial application can mean a lot of things though and not enough information has been provided about what is involved in the application to give us an idea on what it does.
I think this case has gone a lot beyond the scope of simply connecting to SQL and they need to have a look at their application architecture as a whole..
If more information is given, perhaps people here could provide more advice, but it sounds like they need to hire a consultant/contractor..
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply