Re: [HELP] Can SQL*Plus work with local Personal Oracle Lite database??

I am also having a few problems trying to get Lite to work with Developer.

When I sign on to SQL*Plus as the default OOT_SCH, I get the following message:-

SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 29 13:47:33 1998 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Error accessing package DBMS_APPLICATION_INFO You may need to install the Oracle Procedural option SET APPINFO requires Oracle Server Release 7.2 or later Server version too low for this feature
Connected to:
Oracle Open Client Adapter for ODBC 1.0.14.4.0 POLITE ORDBMS 2.4.3.1.1

• when signed on I can access a couple of tables,but cannot sign on as SYSTEM, to grant on the system tables.

When trying to sign on as SYSTEM, either directly, or while attempting to build the common tables in Developer, I get the following error message:

ERROR: ORA-03121: no interface driver connected - function not performed

Being a newbie, as far as Oracle is concerned, I would appreciate any help you could give me.

TIA
Geoff Badger
geoff_at_pondeset.demon.co.uk

Jonathan Trifts wrote in message <34CDF131.6521_at_CGI.CA.NOSPAM>...
>Pasting the message from comp.databases.oracle.tools...
>
><steve k wrote:>
>
>PO Lite uses ODBC to connect to the database. I'm assuming you
>have loaded PO Lite and created the default database. To connect
>to it, try this:
>
>username: OOT_SCH
>Password: abcdef (this can be anything since po lite ignores)
>Database: odbc:polite
>
>OOT_SCH is the default user that po lite sets up. You need to
>have the odbc:polite there to tell oracle to use the odbc drivers
>rather than try and go thru sql net.
>
>I'm new to this too but found the above to work for me. Once you
>get a little more knowledge, you can go in and create new users
>and databases.
>
>Good Luck
>Steve
>
>--
>Regards,
>Steve
>skondolf_at_hatespam.frontiernet.net
>skondolf_at_hatespam.compuserve.com
Received on Wed Feb 04 1998 - 00:00:00 CST