Re: PO7.0 SQL NET

In article <32CD37FB.1CC2_at_fithd.ca>, Ken Ridgway <Ken_at_fithd.ca> writes
>Frank Zheng wrote:
>>
>> Folks,
>>
>> I installed Personal Oracle 7.0 NT version on
>> my NT4.0 Server (beta version). But SQL_Plus3.2
>> has problems to connect to PO7.0 Server. Both
>> SQL_Plus3.2 and PO server run on same pc. When
>> I specified host string as t:tiger (tiger is host
>> name of my pc), an error message appeared:
>>
>> ERROR: ORA-03121: no interface driver connected - function not
>> performed.
>>
>> Then SQL_Plus3.2 was connected to the local database.
>>
>> Any help is appreciated.
>>
>> Frank
>
>I assume that your NT box does is not connected to a network.
>If this is the case you are not required to enter a host connect string
>to connect to the local database.

Look at the [ORACLE] 'SQLNET DBNAME' string in oracle.ini in your windows/winnt directory.

I'm not certain about Personal Oracle for NT (not seen it yet) but Personal Oracle (Win 3.x, Win95 and, OS/2 versions) normally requires the lines;

LOCAL=2:
SQLNET DBNAME ORACLE7=2: (substitute the 'name' of your Personal Oracle database for 'oracle7')

In fact they are usually installed by default, but who knows what changes might be made when adding a version. -:)

A windows client calling an NT Workgroup Server would require this line to recognise the server (even when connecting to the Oracle instance on the same machine).

SQLNET DBNAME ALIAS_NAME=t:SERVER_NAME:ORCL

substituting your database 'alias' for ALIAS_NAME, and your NT Server name for SERVER_NAME. (presuming the instance name is the default ORCL)

-- 
Mike Proctor

Turnpike evaluation. For information, see http://www.turnpike.com/