Re: Win32 client / sqlplus OR msql / Driver problem

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Feb 2005 05:37:59 -0800
Message-ID: <1109597879.331402.28860@g14g2000cwa.googlegroups.com>

mcode wrote:
> "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:<1109543544.848259.26690_at_g14g2000cwa.googlegroups.com>...
> > mcode wrote:
> > > Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> > news:<v7su11hm05li9denl8mi3nla9mhmmq0nv8_at_4ax.com>...
> > > > On 25 Feb 2005 06:26:38 -0800, microcode2004_at_hotmail.com
(mcode)
> > > > wrote:
> > > >
> > > > >
> > > > >How to reinstall this driver for this jdbc connection string
to
> > work
> > > > >properly ?
> > > >
> > > > sqlplus doesn't use jdbc at all. You need to set up an
tnsnames.ora
> > > > and use the service_name in your tnsnames.ora as connection
string.
> > >
> > > but exactly the same error when the parameter string is used with
> > msql

> >

> > This connect string will not work with sqlplus as you are trying to
> > use. This is already pointed out. Now, are you trying to connect to
> > Oracle database or msql (I assume you are saying Sql Server?). If
it's
> > Sql server then you are in the wrong NG.
> >
> > Please describe in detail what exactly you are trying to do instead
of
> > just posting one liners. We can't read your mind :>).

> >

> > Regards
> > /Rauf

>
> NO! Really I begin to find the Oracle Newsgroup's people very bizarre
> !!!

Please do not generalize.

>
> When I write MSQL, I mean MSQL.EXE ! If you don't know what MSQL is so

> please don't try to reply ! When I go on a newsgroup about subjects
> that I don't understand to I don't try to reply :) I only reply If
> this subject is easy for me to understand :)

I have never used Oracle lite so I am not familiar with msql. I have come across posts where people sometimes refer to Sql Server as just SQL or combination of my sql etc. That is why I mentioned Sql server. If you had referred to msql as msql.exe then it would have been much clearer that you are referring to a tool and not Sql server or anything else.

In any case, my mistake for reading your post incorrectly.

>
> I'm not here to teach people about MSQL.EXE, I'm here to find a
> solution to my problem while trying to use MSQL... But in case

someone

> needs to know what MSQL.EXE is :
>
> MSQL.EXE is the client application equivalent to SQLPLUS
> MSQL means MOBILE SQL
> SQLPLUS is for connecting to ORACLE SERVER
> MSQL is for connection to a mobile Oracle Database (Oracle Lite)
> MSQL is also for connection to an Oracle server (Oracle 10g database)
> so MSQL can be used as an equivalent for SQLPLUS in some environments
> such as development environments...

If msql sits on top of Java and you are trying to use Oracle's jdbc driver (thin or OCI) then,

Does Oracle lite client come with jdbc drivers?
Look for classesxxx.zip or classesxxx.jar files in your Oracle home. If you find one then you may have to include it in the classpath.
If you don't see classesxxx anywhere then you can download it from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
It may all be listed in Oracle lite client documentation. Searching for msql.exe at http://tahiti.oracle.com yields 0 results so can't point you there.

Regards
/Rauf Received on Mon Feb 28 2005 - 07:37:59 CST