Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: direct IP connect to oracle

Re: direct IP connect to oracle

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 6 May 2004 10:53:31 +0100
Message-ID: <409a0b1b$0$25317$ed9e5944@reading.news.pipex.net>


"Frank Esselbach" <spam_at_ghostlink.de> wrote in message news:Xns94E16E37DAE5spamghostlinkde_at_62.153.159.134...
> If I write the code in java or in "my" basic ... thats not the problem,
but
> I need the description of the protocol basics, like this (fantasy):
>
> - socket.port=1521, socket.address=myserver
> - constr="DSN=mybase; USR=username; PASS=mypass"
> (mypass must bee encoded by Base64 ... or whatever)
> - socket.connect
> - if the socket connected then the socket must send constr+crlf
> - the listener answers an string that contains another port and handle
> - switch the port to this and if connected then send handle+sqlstring+crlf
> (sqlstring must bee encoded by Base64 ... or whatever)
> - answer=socket.read
> (the answer must decode by Base64 or whatever)
> - socket.close
> - parsing the answer string (I must know the structure) ...
>
> Its possible?

Already done with the JDBC thin driver.

sql*net is a proprietary protocol, it isn't described anywhere, AFAIK.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
Received on Thu May 06 2004 - 04:53:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US