Re: ODBC with Oracle 7

ian.hooper_at_qns.ii.net said...
> We have recently installed a phone system that runs on Oracel 7.
>
> One of the selling points of th systems was that you could create an ODBC
> conenction into the database. (However no assistance would be provided in
> doing htis)
>
> 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.
>
> 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)
>
> a) Anyone have a url that cn help with the Windows 2000 ODBC prob I have.
> 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.
>

I don't know if this is what you're looking for regarding ODBC, but...

1. First you need to setup the tnsnames.ora file on your Win2k client. That's where you specify the IP. You should have a copy of this file in your %ORACLE_HOME%\network\admin folder. I don't remember if it was required, but I specified a dedicated server connection to the database.
2. Now setup your ODBC connection. I used a User DSN, rather than System DSN, so I don't have to login as an Administrator. That's where your username goes. You supply the password when you connect.

You can also investigate using Java or Perl on your Win2k client. Both of these languages can connect to Oracle, though Java seems easier.

Also, I assume you know that you do have to install Oracle client on you Win2k box so you have Oracle networking available.

-- 
/Karsten
DBA > retired > DBA