Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr25.news.prodigy.com.POSTED!af4f5987!not-for-mail
From: Mark Bole <makbo@pacbell.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: direct IP connect to oracle
References: <Xns94E0BAE1C3E5Espamghostlinkde@62.153.159.134> <c7b594$o1i$1@nntp.fujitsu-siemens.com> <Xns94E0D22C81D42spamghostlinkde@62.153.159.134>
In-Reply-To: <Xns94E0D22C81D42spamghostlinkde@62.153.159.134>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Lines: 58
Message-ID: <wKfmc.60677$ve2.29426@newssvr25.news.prodigy.com>
NNTP-Posting-Host: 63.201.157.10
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr25.news.prodigy.com 1083803676 ST000 63.201.157.10 (Wed, 05 May 2004 20:34:36 EDT)
NNTP-Posting-Date: Wed, 05 May 2004 20:34:36 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1: FKPO@MONXJVEBWTXNCOF_W\@PJ_^PBQLGPQRZQMIWIWTEPIB_NVUAH_[BL[\IRKIANGGJBFNJF_DOLSCENSY^U@FRFUEXR@KFXYDBPWBCDQJA@X_DCBHXR[C@\EOKCJLED_SZ@RMWYXYWE_P@\\GOIW^@SYFFSWHFIXMADO@^[ADPRPETLBJ]RDGENSKQQZN
Date: Thu, 06 May 2004 00:34:36 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:138071


Frank Esselbach wrote:
>>Sorry, but there is no possibility. The client libraries are
>>responsible for parsing and binding, all the handles, and incidentally
>>also the socket. 
> 
> 
> Hmmm ... why? Is this so difficult? The encoding, the data handling or 
> what? I need only one connection to send a sql string and receive the 
> answer, no more. To programming this for mysql I have needed twoo days - 
> works fine.
> 
> 
>>Maybe you can have a statically linked application
>>that contains all the necessary libs?
> 
> 
> This makes the things more difficult. I use a IDE named "RealBasic" ... 
> (little bit like VB but much more better :-)) please do not flame against 
> basic. This is a modern visual, event driven and object oriented tool that 
> contains a cross plattform compiler: MacOS Classic, MacOS X, Win32 and 
> Linux. With one ckick to the running application, without external dlls, no 
> runtime lib, no installation.
> 
> The native realbasic code is platform independ, the oracle client libs not.
> 
> 
>>Lots of Greetings!
>>Volker
>>
> 
> Greetings, Frank
> 
> P.S. Können wir auch per Mail in deutsch kommunizieren? Verwende die 
> Mailadresse, indem du alle "s" entfernst: sisnsfsos@sqsusaslsisdsasts.com

Several platform independent methods are available (which don't require 
a native Oracle client library), although I cannot speak from personal 
experience.  I'm guessing you won't be very happy with these, but they 
do exist.

1) Java JDBC thin client

2) iSQL*Plus -- "iSQL*Plus is a light weight, web enabled version of 
SQL*Plus released as beta version for Oracle 8.1.7" -- so all you need 
is a HTTP client.

3) roll your own - write a program on the database server to listen on a 
network socket, accept your message (SQL string) and run it locally, and 
return the result (not very good for any but the most simple queries, 
due to formatting and datatype issues).

Oracle 8i is obsolete and not well supported any more.

HTH,

Mark Bole