Re: Connect ODBC to Oracle
Date: 1996/10/21
Message-ID: <54fqp5$i9g_at_news1.pld.com>#1/1
In article <cblanock-1710961537540001_at_maccntrl.slip.lm.com>, cblanock_at_bup.lm.com (Craig Blanock) wrote:
>In article <326214EC.6694_at_ksc-17.ksc.co.th>, nissd_at_ksc-17.ksc.co.th wrote:
>
>> I'm try to use ODBC to connect to my Oracle (7.3).
>> But I alway get message
>>
>> Driver Message:[Microsoft][ODBC Driver Manager] Specified
>> driver colud not be loaded
>>
>> But when I use SQL*Plus to connect pass ODBC, and use same
>> ODBC Alias (Connect string = ODBC:<Alias name>).
>> It can connect to Oracle with no error.
>>
>> Any suggestions?
>>
>> Kraiwut.
>
I was having a problem connecting until I checked the tnsnames.ora file and
found that the oraclle installer inserted the wrong port number (1521)
instead of 1526. (this is our port yours could be different) I edited it an It
works fine now.
Steve Mann
System Administrator
IHP INDUSTRIAL INC
Received on Mon Oct 21 1996 - 00:00:00 CEST