🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: aus.computers.linux
Article #54516

Re: Using ODBC on Linux

#54516
From: Charlie Brady
Date: Wed, 15 Oct 1997 00:00
31 lines
1964 bytes

On 15 Oct 1997, Craig Harvey wrote:

> I'm pretty new to Linux, and have a question I hope you might be able to
> answer for me.
> 
> Are there any ODBC drivers for Linux that will allow me to interact with a
> MS Access Database via a web server (such as Apache through server side
> scripting)?
> 
> For example, an Access Database might be sitting on the server, and I want
> to be able to let users run simple queries via the web, which access the
> database, returns the result in a HTML file. I need to know if there is an
> ODBC driver for Access that runs on Linux to do this.

If you are storing your data on Linux, and you only want to access it from
the Web server, then you don't need to keep the data in Access format. 
Convert it one way or the other into some other form - a flat file, a DMB
file, a nice SQL database such as MySQL, and make use of it from the Web
server using PHP/FI, perl etc. 

Even if you are creating the data using Access, you can use an ODBC driver
on the poor Windoze machine to access the database server running on
Linux. You still avoid Access format files, and you only use Access is a
data entry/manipulation front end.

Charlie Brady - Telstra  |internet: cbrady@ind.tansu.com.au
Network Products         |Snail    : Locked Bag 6581, GPO Sydney 2001 Australia
Platform Technologies    |Physical : Lvl 2, 175 Liverpool St, Sydney 2000
 IN-Sub Unit - Sydney    | Phone: +61 2 9206 3470 Fax: +61 2 9281 1301
Technical Details
Message-ID: <Pine.GSO.3.96.971015193248.22805j-100000@hawk.ind.tansu.com.au>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bcd93b$018dcf60$3300a8c0@boris.ezy.net.au>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 102983,e1144a96fcd249ff,start
X-Google-Attributes: gid102983,public
From: Charlie Brady <cbrady@ind.tansu.com.au>
Subject: Re: Using ODBC on Linux
Date: 1997/10/15
Message-ID: <Pine.GSO.3.96.971015193248.22805j-100000@hawk.ind.tansu.com.au>
X-Deja-AN: 280760303
References: <01bcd93b$018dcf60$3300a8c0@boris.ezy.net.au>
To: Craig Harvey <cwh06@uow.edu.au>
Organization: Telstra
Newsgroups: aus.computers.linux