Re: How to talk to LISTENER

Great, thank you Jim.

I did not know Oracle lets you download their products for free for development purposes. This is great. Actually fantastic. Documentation is there too!

I/m downloading in B/G, I hope the installation won't ask me for some product key off some CD, is it?

Well anyway, I'll do as you say with tnsping and network sniffer. But do you have to be so picky about how we call the servers?

When you say sql server, every one knows that your talking about a server that gives you data in exchange for sql expressions. Now all servers, in computer terminology, serve data. Be it a file server, web server, ICQ server, real media server.

And I don't agree to call only MS SQL Server a 'SQL server' (despite its name) and all other RDBMS by their individual product name. MS SQL Server is not the only SQL Server. And hence the component I am working on.

  In the latest MS Platform SDK, MS has added an API function to find only MICROSOFT SQL Servers. A great idea. Something we wanted for a long time. But I think it is incomplete. I think it should list all sql servers or RDBMS that can receive SQL, not those RDBMS that receive specialized DBF type of commands.

Thank you Jim
Agron.

Jim Kennedy wrote:
> Lets get the terminology correct.
> SQLServer is a product of Microsoft Corporation.
> ORACLE is a product of the Oracle Corporation.
> Both products are Relational Database Management Systems -> RDBMS.
> So both vendors would cringe at the phrase "oracle sql servers ".
>
> They don't serve up sql they use SQL - Structured Query Language - to
> manipulate data.
>
> You could read the docs at otn.oracle.com. Sign up, its free. And go to
> documentation. Or use tnsping and a network sniffer to see what it is
> doing.
> Jim
>
>
> "Agron" <agron_ng_at_7kosova.com> wrote in message
> news:3E9CCF76.2060702_at_7kosova.com...
>

>>I wrote an non-linux component to scan the local network for one of the
>>non-oracle sql servers. What I want is to include oracle sql servers in
>>that list too. Now I don't have an oracle server or documentation about
>>it. So I need someone from your community to help me with the following.
>>
>>So far I found out that oracle sql server has an Intelligent Agent that
>>listens to the ports 1521 and /or 1526.
>>
>>I need to know what do I need to send there and what response can I get.
>>
>>I am mostly interested to get some version and instance information.
>>
>>Any help is appreciated.
>>Thank you.
>>Agron.
>>