Re: Direct access over SQL*Net to a oracle database without ODBC from MSVC++

Stefan,

As far as I understand it, sql*net provides Transparent Network Substrate (TNS) datastream protocol.

Most of RDBMSes use some logical datastream protocol to establish network independent communication between client and server.

I guess, higher layers (ODBC, OCI) can access TNS via API it provides but I don't think they are widely documented outside ORACLE.

    Anyway, you can try asking ORACLErs for docs. I think to reverse engineering TNS shouldn't be a big problem, unfortunately you might have signed licence agreement which prevents reverse engineering.

What about advantages you can get using TNS API directly, I can't find any. ORACLE can change TNS providing that CLI interfaces (ODBC, OCI) will stay backward compatible. You would lose the support.

I don't know your reason why installing the driver is so bad that it is necessary to get rid of it. I understand that putting driver to the server side (one and only place) would make administration, configuration and maintanence easy. However, regardless you use ODBC driver or not you may need to install sql*net client part.

You can use OCI as David suggested but you can also develop your communication stuff (maybe based on DCOM or another IPC method). Server side contains all stuff necessary to access RDBMS (using either ODBC or OCI) and a simple process (deamon/service - DCOM server) serves your (DCOM) client requests. It is not necessary to have either sql*net or ODBC driver on a client side any longer in such scenario.

--
Thank you for keeping >anti-spam< habit: not including my address in your reply. Received on Mon Jul 26 1999 - 05:12:11 CDT