Re: Mac ODBC Oracle Config?

Timothy J. Wangelin <wangelin_at_i1.net> wrote:

Hi,
it's not that simple, I spent 2 months trying to get it to work. I won in the end, but not the way you are trying to go.

I can possibly help you if you give me the following.

1. The version of the intersolv drivers
2. the versions of the oracle libraries that are in your system folder:extensions:oracle libraries
3. the version of your system software
4. the name of your system volume (yes it matters, intersolv did not allocate enougth storage for the full systempath to preference folder, it gets truncated, so it will never find the drivers)

the best way to find out if intersolv & the oracle drivers are working is below.

open the intersolv odbc ppc manager,
select filedns
select add
select your driver
select finish
give it a name
select finish
if at this time you get a system "beep"
go into your system folder:preferences:ODBC File Data Sources:"name you saved"
and look at the setup using simpletext
if it shows "driver=NTERSOLV xx.xx Oracle PPC" then the versions are incompatable! ( give up now!!& follow below from 5.)

4. to get you started I have sent a copy of my intersolv setup. If you don't get a beep then below is a sample setup file this goes into system folder:preferences:ODBC File Data Sources

file name 'tcp'
[ODBC]
PWD=TIGER
UID=SCOTT
SRVR=TCP
DRIVER=INTERSOLV 3.02 Oracle PPC

note the name of the driver 3.02, this will only work with oracle linked against 2.3.2.0.3
also "tcp" is defined in easyconfig with the ip address of the server

If i suspect your "demo" copy is from where I think it is, forget it!!.

(5.)
Your solution would be :
1. get intersolv driver demo 3.02 from Filemaker pro demo(available on filemaker pro web site)
2. get oracle "demo" cd-rom part No. Z23078-01

3. Don't try to use the graphical admin stuff that was supplied with the oracle 7 for power mac
against an oracle 8 database.

Note that the running SQL* plus from the mac, does not interact with the intersolv drivers, you can even write "c" to access the oracle using the old drivers from the "demo" oracle 7, but they will not interact with certain versions of the intersolv drivers.

steve

> How do I configure the Intersolv Oracle ODBC driver?
>
> I am trying to access an Oracle 7.3.4 database on Solaris 2.5, and an
> Oracle 8.0.5 database on Solaris 2.5.
>
> I have an old trial copy of Personal Oracle7 for PowerMac. I set up my
> tnsnames.ora file. I can do a successful NetTest on the Oracle 7.3
> database, the Oracle 8.0.5 database with a SQL*Net listener, and the
> Oracle 8.0.5 with a Net8 listener.
>
> I can use SQL*Plus to access the databases. I can also Telnet to the
> Unix prompt and run SQL*Plus from there.
>
> What do I need to do to get the ODBC driver configured? What do I need
> to put in the Server Name and Server List fields? What other
> configurations do I need on my machine?
>
> Any help would be greatly appreciated.
>
> Thanks in advance,
>
> Tim Wangelin
Received on Wed Jul 21 1999 - 11:48:29 CEST