Re: SQL Net Newbie

The easiest way to get SQL*NET working is install from the disk as the instructions say for a client install but don't try "EasyConfig". Go to the server and copy the following file to disk:

$ORACLE_HOME/network/admin/tnsnames.ora

Next go to the client machine and put the file in $ORACLE_HOME\network\admin directory.
If there is a sqlnet.ora file on the client machine in this directory, delete it.

SQL*NET should work fine now. The "EasyConfig" just builds the tnsnames.ora file for you, but it is tricky sometimes. Just copying it works fine.

Kenny Gump

David MacLeman wrote in message <7h9g0c$3df$1_at_nnrp1.deja.com>...
> Hi!
>I am very new to Oracle and am currently working with Oracle7 on
>Solaris 2.6. I am trying to set up ODBC to use MS Access etc. to link
>to the Oracle database. SQL Net is installed but not configured. Could
>someone explain to me as simply as possible how I go about configuring
>SQL Net.
>Thanks for any help!
>
>--
>David MacLeman
>damacl_at_my-dejanews.com
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Tue May 11 1999 - 14:57:39 CDT