Re: cannot connect to a new Oracle9i Lite db

I figured this out in the end - so for anyone else, here what's happening.

My confusion came from the fact that "polite" is both the name of the default database, and the name of a connection subprotocol. To connect to the database "mylite" using msql over a Native Driver Connection, use: "msql user/password_at_jdbc:polite:mylite"

"odbc" can be used in place of "jdbc" in the url syntax. Here "polite" refers to a subprotocol, not to any database.

However, why the following syntax works to connect to the polite database I'm not sure:
"msql user/password_at_polite"

Also, anyone else starting to work with Oracle9i Lite should realise that the documented info is not always where you'd expect it to be. For example, while I'm working with Win32 only, there was info on msql I found in "Developer's Guide for Web-to-Go" that wasn't in "Developer's Guide for Win32".

cheers,
Owen.

"Owen Murphy" <owen_at_owenm.com> wrote in message news:b2ajli$19odfu$1_at_ID-163650.news.dfncis.de...
> I can connect to the default Lite database POLite using msql from the
> command line:
> "msql system/manager_at_odbc:polite" or "msql system/manager_at_polite"
>
> So, I then created a new database, using the createdb tool:
> "createdb mylite mylite"
>
> I then added an ODBC datasource for MYLite, using the same odbc settings I
> see in the existing odbc entry for POLite, except pointing to my new
mylite
> database file.
>
> But I cannot now connect to my new database using msql from the cmd line:
> "msql system/manager_at_odbc:mylite" or "msql system/manager_at_mylite" gives...
> ***
> Oracle MSQL Version 1.0.0.0.2
> (c) Copyright 2001 Oracle Corporation. All rights reserved
>
> No suitable driver
> ***
>
> (It also makes no difference whether I set up the ODBC DS first and then
run
> createdb)
>
> Strangely, while msql fails, I seem to be able to connect to mylite (and
> POLite) using Oracle's ODBC Test tool, and other apps supporting ODBC
> connections. My first thought was that my CLASSPATH setting might be
wrong,
> but then why can I connect to the default database POLite using msql?
>
> I'm completely at a loss here, any help greatly appreciated.
>
> if it helps at all, my CLASSPATH is:
> C:\Oracle\Lite9i\JDBC\Lib\Classes12.zip;
> D:\Oracle\Lite9i\MOBILE\CLASSES\OLITE40.JAR;
> D:\Oracle\Lite9i\Mobile\Server\bin\webtogo.jar;
> C:\Winnt\System32\QTJava.zip;
>
> thanks,
> Owen.
Received on Wed Feb 12 2003 - 12:08:56 CET