Re: Oracle and ODBC

On Tue, 04 Jan 2005 20:47:02 +0000, xhoster wrote:

> But I don't see why they couldn't use:
>
> client >> transport >> translator >> database.
>
> It seems you would lose very little, and the gain of having to install
> the db-specific translator on 1 server rather than 100 clients would be
> substantial.
>
> Yes, you would loose the functionality of SQL*Net, but haven't you
> effectively lost them already by using a lowest common denominator API?

I'm missing something here in your logic, from an ODBC viewpoint.

Assuming Oracle only responds to SQL*Net, Net8, OracleNetwork requests across the network, how would your ODBC talk to Oracle without a SQL*Net component, or something extra installed at the server side in addition to the client side?

Remember the ODBC spec pretty old and created in the days when client-server was king and 10-15 clients was serious. From where I stand, you really need to create a time machine, go back and knock some sense into the organization that backed the spec.

Fast forward to modern time, I suggest you at the 'Thin JDBC' spec.

lol/FGB Received on Tue Jan 04 2005 - 15:08:01 CST