Very Computer

My applications are running under Guardian D43.

I have a need to programmatically perform SQL
queries on an Oracle database residing on an
HP9000 (Unix).

TNS says that there is no Tandem utility / functionality to
allow a program running on the Tandem to access
an outside Oracle database.  Has anyone ever been able
to do this?  I would sure like know how.

Regards,
Jeff McLamb

Whats about Tandem ODBC ?

Quote:> My applications are running under Guardian D43.

> I have a need to programmatically perform SQL
> queries on an Oracle database residing on an
> HP9000 (Unix).

> TNS says that there is no Tandem utility / functionality to
> allow a program running on the Tandem to access
> an outside Oracle database.  Has anyone ever been able
> to do this?  I would sure like know how.

> Regards,
> Jeff McLamb

Dan Parker
Sterling Software, Inc.

--
-- "If food is the body of good living, wine is its soul"
--
--   Clifton Fadiman, American editor and writer.
--   1904-?
--

Thanks for your feedback.

This was the first area I looked
into as well, but Tandem ODBC only
allows you to perform Outside/In queries
on Tandem SQL files.

In other words it will allow you to access
Tandem SQL databases from another host such
as a PC or Unix Box, but it doesn't allow
you to access an Non-Tandem Oracle database
residing off the system.

You are correct, but don't get trapped into thinking that this is a
Tandem deficiency.  This is true of ANY vendor's ODBC implementation.
ODBC client drivers are always supplied by the vendor of the server
DBMS, not the client environment.  For instance, the Windows drivers
that allow you to access Oracle, Sybase, and Paradox from a Windows
client are developed and provided by Oracle, Sybase, and Borland...not
Microsoft (I know, I know...you can get them from Microsoft, but they
get them from the DBMS vendors.)

Dan

--
-- "If food is the body of good living, wine is its soul"
--
--   Clifton Fadiman, American editor and writer.
--   1904-?
--

Jeff,

We looked at expanding our ODBC product (DynaAccess) to include a gateway
that will run on the Tandem system and access databases on other platforms
via ODBC but market research did not warrant for turning this module into a
full fledged product.  The DynaAccess product suite today allows Unix
Clients (Sun, HP and AIX) to reach the Tandem SQL and Enscribe databases
via ODBC, but not the other way around.
Have you considered developing a Tandem process talking to an HP/Oracle
process and retrieving your database info.  This could be accomplished by
using the Piccolo middleware to send and receive messages between the
Tandem and the HP systems.

Good Luck

Karim