Re: [MacPerl] SQL DB

[Michael Scoltock <scoltock@ictp.trieste.it>]

>some remarks about interfacing MacPerl to Oracle on a remote server:
>
>I'm still struggling with this connection. If someone knows
>more please inform me.
>
>My understanding is:
>There is no Mac ODBC driver available from Oracle (you get it for
>free for Windows platforms).
>The Oracle ODBC driver included in MS Office 98 does not work
>with remote databases.
>FileMakerPro delivers Oracle ODBC driver but without a license.
>The producer of this driver does no longer exist. You won't
>get support.
>Oracle ODBC driver can only work if you owe a SQL*Net license.

The fundamental point here is that your program (Perl, Filemaker,
whatever) uses ODBC to talk to a _local_ interface. That interface
could be a local Oracle server, or a SQL*Net connection to a
remote server. To talk directly to a remote Oracle server, you need SQL*Net=
.

>For developing your own DBD driver you would need to buy a
>developer license for OCI (Oracle Call Interface, C library).

Not true, you need the header files, which are found in the examples
that Oracle supplies with core product (my experience was with Oracle 7
however). The DBD::Oracle module is buildable by any owner of an Oracle
server, on the same machine (and for the same type of machine) that hosts
Oracle.=20

>
>My views may have been outdated. I'd like to be corrected.
>
>A possible solution for interfacing MacPerl with Oracle is
>the DBD::Proxy idea. I'll need to check this.
>
This certainly works, I've done it (MacPerl to a Solaris hosted Oracle
server). The proxy engine, on the server, talks to (its) local Oracle.The
remote DBD::Proxy driver talks the proxy engine. No SQL*Net is needed in
this case, only a network connection between 2 Perl programs running on
2 different machines.
>
>Best regards
>
>
>Axel
>
>
>P.S.: Does anybody remember Larry Ellison (Oracle CEO, member
>of Apple Board of Directors) saying that every Oracle software
>will be available for the Mac??
>----------------------------------------------------------------------
>Axel Rose, Springer & Jacoby Digital GmbH & Co. KG, mailto:rose@sj.com
>  pub PGP key 1024/A21CB825 E0E4 BC69 E001 96E9  2EFD 86CA 9CA1 AAC5
>  "... denn alles, was entsteht, ist wert, da=DF es zugrunde geht ..."
>
># =3D=3D=3D=3D=3D Want to unsubscribe from this list?
># =3D=3D=3D=3D=3D Send mail with body "unsubscribe" to macperl-request@mac=
perl.org


------------------------------------------------------------------------
Michael Scoltock                       Phone:  +39 040 2240.501
Administrative Computer Section
Abdus Salam International Centre for Theoretical Physics
Strada Costiera, 11
34136 - Trieste
Italy                                  E-mail: scoltock@ictp.trieste.it
------------------------------------------------------------------------



# =3D=3D=3D=3D=3D Want to unsubscribe from this list?
# =3D=3D=3D=3D=3D Send mail with body "unsubscribe" to macperl-request@macp=
erl.org