Very Computer

> I need to learn how to access databases (Oracle, SQL Server, Postgres) from
> unix (solaris 2.8).  I have tried to do some research on amazon but can seem
> to find any books on the subject.  I want to code to a very generic library
> and not be tied to anything (definitely not oracle).

> > I need to learn how to access databases (Oracle, SQL Server, Postgres) from
> > unix (solaris 2.8).  I have tried to do some research on amazon but can seem
> > to find any books on the subject.  I want to code to a very generic library
> > and not be tied to anything (definitely not oracle).

> There is no standard way to access the DB server process(es)
> from a client process (= application), because the means of
> communication (mechanism, protocol, encoding, ...) are specific
> to the DBMS.

> The closest you can get may be ODBC, but IMHO this is no good
> approach because ODBC (like all M$ designs) pretends to _know_
> what _you_ want, and hence does not pass your requests unchanged.
> You still need to link your routines with the specific ODBC lib.

> The standard to access an SQL DBMS is to use "embedded SQL"
> (as defined by X/Open, ANSI/ISO, ...) and then to pass this code
> through a preprocessor, compile the resulting code (which is
> product-specific) and link it with the respective runtime libraries.

> > Any suggestions for resources for database programming in unix?

> "Adabas D" ( http://www.adabas.com/sqlindex.html ) is available
> as a "personal edition" (limited for 3 users, 1 CPU, 100 MB data space)
> free of charge for Linux (and Win32);
> you might ask your local Software AG branch whether they can provide
> a "personal edition" for Solaris (or other Unix variant: AIX, HP-UX,
> Tru64, ...) as well (or buy a license from them ...)

> Regards,
> Joerg Bruehe

>I need to learn how to access databases (Oracle, SQL Server, Postgres) from
>unix (solaris 2.8).  I have tried to do some research on amazon but can
seem
>to find any books on the subject.  I want to code to a very generic library
>and not be tied to anything (definitely not oracle).

>Any suggestions for resources for database programming in unix?

>thanks for your time...