HP UX ODBC Drivers.

[Neil Harris]

Does anyone know of an ODBC product that will run in HP-UX and connect UNIVERSE to ORACLE. Alowing Universe to send SQL to oracle. Weird I know but its what we have.

[harry d brown jr]

neil,

I used to be a universe (pick) programmer and my company just bought another company that uses Pick for some applications. Anyways, how about perl? I'll check http://www.cpan.org for any universe modules. I Know they have Oracle odbc modules.

live free or die
harry

[Neil Harris]

Thanks for that Harry, I am trying to avoid PERL if I possible can.

[harry d brown jr]

ODBC Data Sheet:
http://www-3.ibm.com/software/data/u2/pubs/datasheets/universe_odbc.pdf

ODBC Programmers reference:
http://www.informix.com/answers/english/docs/100univ/8759.pdf

SQL Overview: http://www-3.ibm.com/software/data/u2/pubs/techbriefs/tb11.pdf

General Docs: http://www.informix.com/answers/english/puniv100.htm

at http://dbforums.com/arch/52/2002/3/327610

live free or die
harry

[Steve Steel]

Hi


See

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xac07543254bfd611abdb0090277a778c,00.html

and the referenced

http://www.datadirect-technologies.com/



New Release of ODBC Driver Extends Support for DB2 on All Platforms
Use one ODBC driver for access to DB2 on OS/390, Windows NT, Windows 2000, UNIX and now IBM iSeries


Regards

Steve Steel

Quote of the moment
-------------------
"We are drowning in information but starved for knowledge."
-- John Naisbitt

[H.Merijn Brand (procura]

Why avoid perl? Because your perl cannot deal with DBD-Oracle? Go grab my Oracle prepared perl-5.8.0 binary distribution from https://www.beepz.com/personal/merijn and build DBD-Oracle against it. The build already includes DBI-1.30

[harry d brown jr]

Don't forget he need's a PICK UNIVERSE (IBM's/Informix's U2 product) ODBC.

and of course I agree that perl is the best to do what you are trying to do.

live free or die
harry

[Neil Harris]

Avoiding PERL is based on the fact that the Universe app is third party and the developers would like to use the Universe<-->ODBC<-->Oracle root and just pass sql to Oracle.

[H.Merijn Brand (procura]

Good reason. AFAIK there is no perl interface to Universe :/

[harry d brown jr]

Procura, but there is an odbc interface in Universe (U2), so perl should be able to talk between U2 and Oracle.

As a matter of FACT, http://ascentialsoftware.com has such a tool. I eval'ed it last month.

live free or die
harry

[Neil Harris]

Long time afgter the origional question I know but a folow up. We have migrated to Universe 10.x which came with a JDBC driver so I solved the problem using that.