Re: Local Oracle access

|> >
|> > I'll try this question again....Does anyone know if I can access a local Oracle database
|> > using a standard callable API set such as x/open CLI or ODBC? OCI seems to be the only
|> > documented API's for this purpose, but it is not portable to other RDBMS's.
|> >
|> > Michael Mckeehan
|> > IBM Rochester, Minnesota
|> >
|> > ODBC is supported for Oracle7. You can download Oracle's ODBC drivers
|> for Win31, Win95, and WinNT from www.oracle.com.
|> --
|> Rich Woods, Field Support Analyst
|> Oracle Corporation, USA
|> The comments and opinions expressed herein are mine and
|> do not necessarily represent those of Oracle Corporation.

I realize that ODBC can be used when talking over a network stack such as TCP/IP using SQL*Net. I would like to run an application on an NT server that talks directly to a local database running on that same NT server. My current understanding is that there are two callable API sets that I can use for this: 1) OCI, going directly to the local database (no comm stack) 2) ODBC, which does require the performance overhead of going through a comm stack such as TCP/IP.

If I choose option 1 and use OCI, the database access code is not portable to any other RDBMS's. If I choose option 2 and use ODBC, performance suffers due to running the comm stack.

What I am hoping for is the ability to write my server application code using the API's of ODBC (or the subset of X/OPEN CLI) and have these api calls perform as well as using the native OCI api's.

Can anyone clear this up for me?

-- 
Michael Mckeehan
IBM Rochester, Minnesota