You need to be running Net8 and use a tns connect string in this case. This is because D2K 6.0 is based on 8.0 software (client software) whereas 8.1 is not. We need to use sqlnet to connect this 8.0 client to the 8.1 server.

So, you need to make sure your sqlnet listener is running under 8.1.5 -- you'll configure the listener.ora to get it up and running. That file will be found in $ORACLE_HOME\network\admin and will look something like:

# LISTENER.ORA Network Configuration File:
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=tkyte-del)(PORT=1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = tkyte816)
(ORACLE_HOME = C:\oracle)
(SID_NAME = tkyte816)
)
)

Yours will be similar but different. You can verify if your listener is running via:

C:\oracle\network\ADMIN>lsnrctl status

that'll show you if it is. If not, you can use lsnrctl start to start it (and you can set the service to "automatic" to get it to start on your next reboot).


Then, you need to make sure you have configured your TNSNAMES.ORA in your D2K oracle home (NOT in the 8.1 oracle home). D2K will be looking at its $ORACLE_HOME\net80\admin (note the directory name is different). That tnsnames.ora should have an entry like:

mylocaldatabase =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST=tkyte-dell)(PORT=1521))
(CONNECT_DATA=(SID=tkyte816))
)


Now, you can log in with the D2K user/pass@mylocaldatabase syntax....