Interfacing to Oracle or other SQL databases

QNX Newsgroups (Archives) qdn.public.qnxrtp.applications
1

We need to be able to send fairly high rate data from a QNX system to
an Oracle (or other SQL) database. To date, the only option we have
found is to use software from a company called EasySoft that (I think)
allows for the following to occur:

  • Encode data on the Qnx box
  • Send over bridge to Windows box
  • Decodes from bridge on Unix box
  • Goes through Windows “Master” driver
  • Goes through Oracle Drive on Windows box
  • Then, goes over network in some Net-8 format to the Oracle server
    box

Has anyone needed to interface with an SQL (preferably Oracle)
database before, and if so, can anyone give me some pointers as to
where to start?

THanks

Bruce (not a database guy) Gilland

2

Have you considered the Perl DBI::DBD stuff? You should be able to
connect straight to the Oracle machine (in principle).

Richard

gilland@cs.colorado.edu wrote:

We need to be able to send fairly high rate data from a QNX system to
an Oracle (or other SQL) database. To date, the only option we have
found is to use software from a company called EasySoft that (I think)
allows for the following to occur:

  • Encode data on the Qnx box
  • Send over bridge to Windows box
  • Decodes from bridge on Unix box
  • Goes through Windows “Master” driver
  • Goes through Oracle Drive on Windows box
  • Then, goes over network in some Net-8 format to the Oracle server
    box

Has anyone needed to interface with an SQL (preferably Oracle)
database before, and if so, can anyone give me some pointers as to
where to start?

THanks

Bruce (not a database guy) Gilland

3

Richard Kramer <rrkramer@kramer-smilko.com> wrote:

Have you considered the Perl DBI::DBD stuff? You should be able to
connect straight to the Oracle machine (in principle).

Sounds like you’ve never installed dbi::dbd module.
it requires oracle oci stuff.

\

Richard

4

fliu@bb.vipstage.com wrote:

Richard Kramer <> rrkramer@kramer-smilko.com> > wrote:
Have you considered the Perl DBI::DBD stuff? You should be able to
connect straight to the Oracle machine (in principle).

Sounds like you’ve never installed dbi::dbd module.
it requires oracle oci stuff.
You’re right - not Oracle, at least. MySql on QNX 4 only.

Richard

Richard

5

We are currently working on a “solution”. It will be based on Oracle’s IFS.
It’s functionality is fairly limited, but it is capable of inserting and
reading data from Oracle 8.1.7 and Oracle 9 .

Pavol Kycina


<gilland@cs.colorado.edu> wrote in message
news:3ce518f7.1799597@inn.qnx.com…

We need to be able to send fairly high rate data from a QNX system to
an Oracle (or other SQL) database. To date, the only option we have
found is to use software from a company called EasySoft that (I think)
allows for the following to occur:

  • Encode data on the Qnx box
  • Send over bridge to Windows box
  • Decodes from bridge on Unix box
  • Goes through Windows “Master” driver
  • Goes through Oracle Drive on Windows box
  • Then, goes over network in some Net-8 format to the Oracle server
    box

Has anyone needed to interface with an SQL (preferably Oracle)
database before, and if so, can anyone give me some pointers as to
where to start?

THanks

Bruce (not a database guy) Gilland

6

If you don’t mind using non-Oracle database, try Emrpess RDBMS. I’ve been
using their QNX Port for over a year now and I have had no real problems
with it, other than its lack of documentation and being somewhat different
from Oracle. They recently released a product that does “store and forward”
from their database to SQL Server. Might be something for you.

–
Randy Aeberhardt
<raeberhardt@tantalus-systems.com>
<www.tantalus-systems.com>


<gilland@cs.colorado.edu> wrote in message
news:3ce518f7.1799597@inn.qnx.com…

We need to be able to send fairly high rate data from a QNX system to
an Oracle (or other SQL) database. To date, the only option we have
found is to use software from a company called EasySoft that (I think)
allows for the following to occur:

  • Encode data on the Qnx box
  • Send over bridge to Windows box
  • Decodes from bridge on Unix box
  • Goes through Windows “Master” driver
  • Goes through Oracle Drive on Windows box
  • Then, goes over network in some Net-8 format to the Oracle server
    box

Has anyone needed to interface with an SQL (preferably Oracle)
database before, and if so, can anyone give me some pointers as to
where to start?

THanks

Bruce (not a database guy) Gilland