cannot connect to a new Oracle9i Lite db

From: Owen Murphy <owen_at_owenm.com>
Date: Tue, 11 Feb 2003 10:35:30 -0000
Message-ID: <b2ajli$19odfu$1_at_ID-163650.news.dfncis.de>

[Quoted] 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 [Quoted] 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)

[Quoted] 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, [Quoted] 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 Tue Feb 11 2003 - 11:35:30 CET