Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.frii.net!newsfeed.frii.net!news.compaq.com!uunet!sac.uu.net!dfw.uu.net!ash.uu.net!an02.austin.ibm.com!ausnews.austin.ibm.com!not-for-mail From: Ed Stevens Newsgroups: comp.databases.oracle.server Subject: Re: ODBC & ORACLE 7 Date: Mon, 05 May 2003 09:37:16 -0500 Organization: IGS Internet News Server (AUSTIN) Lines: 55 Message-ID: References: <3eb5e890$0$31082@echo-01.iinet.net.au> NNTP-Posting-Host: gsine04.us.sine.ibm.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: ausnews.austin.ibm.com 1052145230 13980 9.14.6.44 (5 May 2003 14:33:50 GMT) X-Complaints-To: abuse@ausnews.austin.ibm.com NNTP-Posting-Date: Mon, 5 May 2003 14:33:50 +0000 (UTC) X-Newsreader: Forte Free Agent 1.92/32.572 Xref: core-easynews comp.databases.oracle.server:185319 X-Received-Date: Mon, 05 May 2003 08:27:34 MST (news.easynews.com) comments embedded On Mon, 5 May 2003 12:29:25 +0800, "Ian Hooper" 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.