Re: MSAccess to update Oracle database ???
Date: 1997/02/10
Message-ID: <32fefcfa.482724_at_newshost.us.oracle.com>#1/1
[Quoted] I guess I really don't get the gist of "data lying around". If this is truly static and unstructured data, you are best served to put this into some static HTML files and get the fastest and cheapest WebServer around, and off you go.
If this becomes structured data, and you want to put this in a database, then I think I see the solution you want to pursue, although I don't think it will work.
If I understand you correctly, you want to put your data into an MS Access database, let your UNIX server "see" this Access mdb file via Samba (NFS-like, which I have used before), and then somehow, via drivers, access the data in the mdb file from your UNIX Web Server.
Firstly, I personally do not know of any ODBC drivers that are available for UNIX systems that can read and manipulate data in an MS Access database file directly. You may have trouble tracking this one down. I imagine that if you host your Web server on NT, that IIS probably has drivers available for just this purpose.
My suggestion, although biased, would be to host all of this (database and WebServer) on NT using the Oracle7 Server and Oracle Web Server. You are put off by having to maintain your database using SQL*Plus. But that's what you are missing. With Oracle Web Server, you maintain your database and Web server through your browser!
As far as getting your data initially into Oracle7 Server, you would use SQL*Loader to populate your database.....and you define the structure of your input data file....comma-delimited, tab-delimited, etc. After that, it becomes a pretty easy problem making this dynamic data available through the Oracle Web Server.
Does this make sense, or have I missed your point entirely?
On Mon, 10 Feb 97 06:42:34 GMT, Stephen.Meredith_at_jcu.edu.au (Stephen Meredith) wrote:
>Hi, thank you for reading my post and I apologize for the
>cross-posting but, like any cross-medium solution this is a
>question for someone familiar with two very different
>environments.
> ~
>I have some data lying around which has to be accessed from
>the Web. My current thinking is to get Oracle's Web interface
>software, dump the data into Oracle and problem (more or less)
>solved. (I've prototyped this by hand with C programs and
>another database product and it all works but is not really
>maintainable).
> ~
>I don't really want to maintain the db with SQLPlus so I've
>loaded it into MSAccess and would like to use this product
>to maintain the physical db (visible on the Unix machine via
>Samba - a kind of Network File System).
>
>Correct me if I'm wrong but I think all I need to do is get
>an ODBC driver and use the appropriate 'ConnectString' to
>declare the remote db to MSAccess ? Performance is not a
>problem because I'm only loading the original data once in
>a while from my PC; the on-line updating will take place via
>the Web.
>
>This would be a great help if I could work from my PC instead
>of having to wrestle with Oracle itself. Can anyone tell me
>if this is viable ? I've got some ODBC drivers on floppy which
>came with another PC product - can I use them or is there a
>particular one to be preferred (where available ?). Do I have
>to do a 'Create Table...' first then load the data or is MSAccess
>able to do the whole thing as easily as it creates one of its
>own tables (when based on a spreadsheet or ascii file for
>instance) ?
>
>Any (intelligent) suggestions would be very much appreciated.
>
>Regards, Stephen.Meredith_at_jcu.edu.au
>
Thanks!
Joel
Joel R. Kallman Enabling the Information Age through Oracle Government Network Computing! Bethesda, MD http://govt.us.oracle.com jkallman_at_us.oracle.com http://www.oracle.com
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Feb 10 1997 - 00:00:00 CET