Re: Help - SQL*Net and ODBC
Date: 10 Dec 1993 16:25:18 GMT
Message-ID: <2ea7te$oml_at_mailhost.interaccess.com>
James Young (u4imcjky_at_apollo.wes.army.mil) wrote:
: I am trying to access an Oracle db which resides on
: a Unix server via MS Access/ODBC and SQL*Net v1.1 for
: Windows. Everything appears to be set up OK and I can
: connect to the db using the test utilities which came
: with SQL*Net. Attempt to connect from Access and
: from Visual Basic both result in a failed ODBC call
: which returns ORA-9241 (ss_tln:error translating logical
: name). As I said, ODBC appears to configured properly.
: What gives? Any suggestions, comments or especially
: solutions will be greatly appreaciated.
There seemed to be a lot of people experiencing ODBC connection problem with Oracle (including myself). I finally got my ODBC to work. This is what I had to do:
When I could not get ODBC to connect to Oracle (via VB 3.0) I decided to try the connection with Q+E (came with Excel). Sure enough it failed also. After talking with Oracle support, I put in the following line in my AUTOEXEC.BAT file:
config=c:\windows\oracle.ini
I also had to include c:\windows\system in my path.
This worked for Q+E.
I also discovered that if I use the word 'ORACLE' as the data source in the ODBC setup, I would get connection error. Finally I just used another word for the data source. That's how I got ODBC to work.
For some reason the initial connection from ODBC to Oracle seem to take forever! Received on Fri Dec 10 1993 - 17:25:18 CET