Re: ODBC & ORACLE 7

comments embedded

On Mon, 5 May 2003 12:29:25 +0800, "Ian Hooper" <ian.hooper_at_qns.ii.net> wrote:

>We have recently installed a phone system that runs on Oracel 7.

RED FLAG! Your company purchased an app that runs (only?) on an obsolete, unsupported rdbms?
>
>One of the selling points of th systems was that you could create an ODBC
>conenction into the database.

THAT was a selling point? That's like saying "if you by my brand of computer, you will actually be able to run a variety of programs!"

>(However no assistance would be provided in
>doing htis)

Another RED FLAG.
>
>I have gone to the Oracle and downloaded the Oracle 7 ODBC software however
>the information requested does not reflect the informatin I have.
>
>I have the ip, username and password.

You need the name of the database. If I recall correctly, when the ODBC config panel asks for 'server' name, it really means 'database name, as defined in your TNSNAMES.ORA file.' ODBC cares not a whit about ip addresses or server (machine) names. That is resolved in your TNSNAMES.ORA file.

>
>Alternatively if I can not get this to work is to download and install
>DBD::Oracle and use it with Perl on a Linux box. (However Linux is by far my
>weekest skill)

"Cannot get this to work" is pretty broad. Error messages? If no error messages, how about steps leading up to failure?
>
>a) Anyone have a url that cn help with the Windows 2000 ODBC prob I have.

An uncertified, unsupported combination. Win2K wasn't even a gleam in Bill's eye when Oracle 7 went out of support.

>b) anyone know were I can get a debian package for DBD::Oracle
>
>I went to CPAN however and the Oracle stuff I found there required older
>versions of DBD::Oracle which I am unable to locate
>

And like Jim Kennedy asked -- did you install the Oracle client software? ODBC just runs on top of whatever native client software is needed to support the database. If you can't connect via SQL-Plus -- for whatever reason -- you'll never be able to connect with ODBC. Received on Mon May 05 2003 - 09:37:16 CDT