Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Client-Side Database Connection

Status
Not open for further replies.

jas7b

Programmer
Jun 2, 2004
1
CA
Is it possible to connect to an Access database by using a client-side script? I want to create a website that will be able to run on a standalone machine, not connected to a server, if it is even possible.
 
By definition a website has a server. A webserver is a program that accepts HTTP requests and sends HTTP responses. The webserver can be running on the same machine as the browser which is sending the HTTP requests. So you need to setup a webserver on that standalone machine.

A client-side script, in the web world, refers to Javascript included within the HTML of a web page. Such a script is executed by the browser, loosely speaking. So far as I know there is no provision within Javascript for connecting to a database.

But the web server running on localhost can certainly execute scripts which can connect to the database on localhost. These scripts can be CGI or ASP programs provided that the appropriate Perl or ASP processors are also available on localhost and that the web server is configured to run them.

Typically a webserver, a database server, and a browser client run on three different machines, but they can all run on the same machine.
 

>> By definition a website has a server.

Not so - you can browse local websites perfectly well without the need for a web server.

As far as I know, Access database connectivity is possible client-side, but with the following 2 caveats:

1. It will only work in IE, and
2. It requires the use of ActiveX.

Hope this helps,
Dan
 
Viewing HTML files on the local machine with a browser does not mean that you have a website. It means you have a type of viewer called a browser.

You might have a set of HTML files full of relative links and be able to move from file to file and it works just like it does when the files are on a web host, but that set of files is not a website.

Things that only work in IE with ActiveX are not websites, they are Microsoft Windows applications with an IE interface.
 
>> Viewing HTML files on the local machine with a browser does not mean that you have a website. It means you have a type of viewer called a browser.

I guess we'll just have to agree to disagree on this one, then.

As far as I am concerned, a website is a collection of linked web pages, although having said that, a website could feasibly consist of one single page (a holding page, home page, or index page, for example).

Where the site is hosted makes no difference to what it is - it just means it is hosted in a different place (in this case, on a local hard drive, rather than on a remote web server).

>> Things that only work in IE with ActiveX are not websites, they are Microsoft Windows applications with an IE interface.

We'll have to disagree on this one, too. A web page (or site) that happens to integrate ActiveX technology is still a web page (or site) - it just happens to only be viewable using a specific viewer (in this case, IE, although conceivably new browsers could come along which could also run ActiveX technology).

I would say that to call a web page (or site) that uses ActiveX technology a "Microsoft Windows application" is incorrect. A Microsoft Windows application is a compiled, executable file, usually with a ".exe" extension (with the first two bytes being "MZ", after Mark Zbikowsky, who conceived the format).

This is just my opinion, of course. You are still entitled to yours ;o)

Dan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top