Re: Connecting SQL Server to Oracle - versions problem.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:m09pv15mdj3gtahppdqjpu6tmaj0lpgag3_at_4ax.com...
> On Wed, 22 Feb 2006 10:30:48 -0000, "Shabble"
> <gbarbour_at_baesystemsdotcom> wrote:
>
>>We have a vendor/customer induced problem. Oracle versions only change
>>by...... well they don't.
>>
>>A Windows 2003 server running SQL Server 2000 "needs" to connect to an
>>Oracle 7.3.4.5.0 instance.
>>As far as I am aware the lowest Oracle Client version that will run on
>>Windows 2003 is Oracle 9.2.0.2;
>>and.... as we all know Oracle9i will not connect to Oracle7.
>>Has anyone laughed at and worked round this one?
>>
>>Shabble.
>>P.S. Versions we administer, 7,8,8i,9i,10g. (Some Terminal some not
>>Terminal) - yes we are kept busy.
>>
>>
>>
> Is it your problem? Make it the customers problem!
>
> --
> Sybrand Bakker, Senior Oracle DBA

Thanks Sybrand, Actually you are right (as usual).

Being too enthusiastic and taking ownership of these technical problems is the real issue.
I will give the customer the following.

    : Upgrade Oracle7 to 10G r2

        ~ the cost here would be application re-write and testing.

    : Provide an in-between Instance of Oracle 8i, using (materialized) views to the Oracle 7 Instance via db links.

        ~ the cost would be reverse engineering the requirements from the Oracle7 instance.
Shabble. Received on Thu Feb 23 2006 - 04:04:23 CST