Re: PC --> UNIX Oracle

In article <34q87v$e3f_at_info.census.gov>, tompenn_at_info.census.gov (Thomas Pennington) wrote:

> Problem: We are running Oracle on a Sparc 10, and
> need to have people initiate a few update/load tasks
> from PCs. First: Is this possible. If so, how does
> the remote shell get the username and the environment
> variables setup. If not, do I have to have SQL*NET to
> do this??. Any help appreciated.

There are two pieces that you need to do this. A front-end application and some middleware. For a straight Oracle solution you should get Oracle's SQL*Net as your middleware. There are other middleware solutions available for this task. There is EDA/SQL from Information Builders, SequeLink from Techgnosis, SQL*Net from Oracle and the DAL Server for Unix from Pacer Software (the company I work for). All of these work quite well. If you would like more information on DAL please send me email at the address listed below.

There are many front-end applications available on the PC that are ODBC aware. Anyway, there are many popular front-ends that allow you to access the remote Oracle data. These include GQL from Andyne, DataPrism from Brio, MS-Access from Microsoft and Clear Access from Fairfield Software. There is a catalog available from Microsoft that lists the ODBC aware applications. Unfortunately I do not have information on how to get it. If anyone out there knows where I can get that catalog please let me know.

I hope this helps you in your search for a solution.

-- 
Paul Kamp
Pacer Software, Inc.
pgk_at_pacersoft.com
Applelink: PACER