dakota97 Posted August 5, 2004 Posted August 5, 2004 Hi all, Is it possible to connect to a database that is stored on a web server? What I'd like to do is create a program that our customers can download which connects to an Access database stored on our website. I know how to connect to a database on a stand-alone computer and across an internal network to a server, but is it possible to connect to one over the internet? Thanks in advance, Chris Quote if(computer.speed == "slow") { hamster.feed(); } if(computer.speed == "really slow") { hamster.kill(); BuyNewHamster(); }
Administrators PlausiblyDamp Posted August 5, 2004 Administrators Posted August 5, 2004 You would probably be better of writting a web service that runs on the webserver and expose methods that return the data - to actually access the file direct would involve opening several firewall ports (mainly the ones you don't want to open) Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Joe Mamma Posted August 5, 2004 Posted August 5, 2004 and remember, Access is not a database server, it is a shared file. I believe the file would have to be shared across the I-Net via a web folder. the users local Jet DLL is used for the queries, I believe, the entire set of queried tables would have to be pulled accross the wire for a select query to be executed. I could be wrong. Extremely slow. . . I have never tried it as I only use access for single user/local situations. Too many headaches. The easiest solution to use is MSDE and open the SQL server port. If the SysAdmin doesnt want to do that, or you dont want to switch to MSDE, you can use a web service to hit either Jet or MSDE. In my experience, MSDE is adequate for around 50 users. True, concurrency is throttled down after, what, 5 concurrent users? But even with 50 users, with ADO.NET and proper conneciton management, I rarely, I mean rarely, hit a bottleneck. Keep in mind, WebService has a huge overhead as the data is wrapped in XML metadata. An 100kb query return came back at almost 1mb. I might of been doing something wrong. Turning on HTTP Compression fixed it though but it put a drain on the cpu. Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.