Re: Can One Query an Oracle 10 Data Base under FreeBSD?



Tyson Boellstorff writes:
On Tuesday 02 June 2009 17:07:57 Gary Gatten wrote:
Surely there's a native Oracle SQL or ODBC client in the ports
collection. Have you checked there?


I believe OP is looking for assurances that the oracle 7 and 8 clients
listed
in ports/databases would work. If he just needs a connection and to run
ANSI
SQL, it would work just as fine or maybe a little better than ODBC. The
problem is that some things are not supported in the 7/8 clients that he
may
want. In that case, he should be looking at running the linux-based
clients
for more direct supportability from Oracle.

First, my sincere thanks to everybody who answered. I
did look in ports first thing and found a bewildering array of
possibilities. We are going to be querying a Pinnacle server and
I suspect the suggestions to use the linux-based instant clients
are going to be what we need. I presently know next to nothing
useful about oracle data bases so the suggestions are much
appreciated.

My understanding of the project we have been asked to do
is that we go to the Pinnacle server, query the data base and
look for a given flag that something new is here, pull in what
is new, massage some headers and then send them to another
device. Only the initial retrieval uses the oracle data base,
but it is not a data base we control so we get it from the
Pinnacle server and we will have to speak in tones it likes.:-)
Martin McCormick
_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"



Relevant Pages

  • Re: Installing 32-bit and 64-bit oracle client on windows 2003 Server
    ... Windows services to connect to the oracle database server hosted on HP- ... if you want to install 2 different clients you need to install ... and hit the documentation button. ...
    (comp.databases.oracle.server)
  • Re: (484 lines) The "CEO-as-crook" FAQ
    ... And, from some past writings of his, he's not any less of an asshole ... R&D at Oracle had been in decline before the dot com era; ... at Oracle or by working for one of its partners a/o clients. ... and Oracle, successful consultants. ...
    (sci.research.careers)
  • Re: Installing 32-bit and 64-bit oracle client on windows 2003 Server
    ... Windows services to connect to the oracle database server hosted on HP- ... if you want to install 2 different clients you need to install ... The oracle documentation does not cover how to run two clients on ...
    (comp.databases.oracle.server)
  • Data Flow Task in SSIS, and Oracle Schema
    ... I have a question regarding SSIS and Oracle ... We have a number of clients that are on Version 1, ... In the SSIS, for each package I have two connections, ConnectionOne ...
    (microsoft.public.sqlserver.dts)
  • Re: What problems are people in the MV world trying to solve
    ... So how do your clients define a "real world problem"? ... Industry approached us because they needed to integrate to Oracle ... Aside from the Oracle and EFTPOS thing, everything else is task dujour ... customer told me, and solved the problem they reported --> and then ...
    (comp.databases.pick)