Re: Re: Trying to connect to an Oracle DB on Windows from DBD:ODBC on UNIX.

Question: I thought the whole point of ODBC is that it can be used to read any database??

To install DBD:Oracle I need to have Oracle installed on my UNIX box. We have a client Oracle installation through a third party which requires this, but it does not have all of the needed files. For example, Pro-C etc.

Comment from README file


    Install enough Oracle software to enable DBD::Oracle to build.
    That usually includes Pro*C and SQL*Net. That's not very specific
    because it varies so much between Oracle releases.
[download]

Since this is a 'proof of concept' project, and since time is short, and since bureaucracy takes for ever to purchase anything, I had hoped to do this with open source stuff.

I went to my DBM and asked about Oracle for UNIX and they did not have any info for me. The Oracle web-site is simply a labyrinth of confusion.

Is this really not possible to do??

Anybody know anything about DBD-Proxy?

Thanks, Sandy

Comment on Re: Re: Trying to connect to an Oracle DB on Windows from DBD:ODBC on UNIX. Download Code

Replies are listed 'Best First'.
Re: Re: Re: Trying to connect to an Oracle DB on Windows from DBD:ODBC on UNIX. by Roger (Parson) on Nov 27, 2003 at 03:42 UTC
You should listen to the master mpeppler - author of DBD::Sybase. ODBC is just a convenient top level interface, you still need database specific drivers. If you 'google' for 'Freeware Solaris 2.8 Oracle ODBC Driver', you will end up with thousands of related links. Beware that most of these Oracle drivers are not free, you will just have to keep searching. The following ODBC driver for solaris looks good, but it's not free. :-( http://www.easysoft.com/products/2104/main.phtml	[reply]
Re: Re: Re: Re: Trying to connect to an Oracle DB on Windows from DBD:ODBC on UNIX. by Itatsumaki (Friar) on Nov 27, 2003 at 06:07 UTC
I believe the Oracle client software itself includes an ODBC driver for many platforms, depending on your install options. You might look to see if that is available on your machine first, before trying 3rd part drivers.	[reply]