Re: HELP!! oracle ODBC can not connect to server ..

Hi -

I added the following SET statements to my autoexec.bat to fix the problem:

SET RDBMS71=C:\ORAWIN\RDBMS71
SET RDBMS71_CONTROL=C:\ORAWIN\RDBMS71\CONTROL SET RDBMS71_ARCHIVE=C:\ORAWIN\RDBMS71\ARCHIVE  (assuming that this is where they live on your computer)

You don't need to have CONTROL to start off, but ARCHIVE is essential and there are a couple of files you need to have, too:

WDBSYS.ORA
WDBUSER.ORA
WDBTEMP.ORA
WDBRBS.ORA
WDBLOG1.LOG WDBLOG2.LOG
CTL1.ORA
          (this last one is critical, one friend of mine had to re-build it!)

Maybe this will help.

Rich Headrick <rheadric_at_macromedia.com> wrote:

>Greetings,
 

>I get the exact same error message, can you copy me on the fix
>and if I get a fix, I'll do the same for you. I am considering
>calling Oracle tech support for a per incident fee of $200 to
>get this problem taken care of. But it would be really nice if
>the user community could help us out here.
 

>Best regards,
 

>Rich Headrick
>Oracle_dba
>Macromedia Inc.
>S.F. CA.

>MCC wrote:
>>
>> I has Oracle server 7.2.3 on SUN Solaris 2.5 (Sparc). The Sql*net work
>> correctly from PC to UNIX. I can use sqlplus(pc version) access UNIX
>> Data base. I install ODBC 1.11 (come with personal Oracle). In ODBC
>> admin. I select "oracle7.1" driver and Sql*net connect string
>> "T:unix_add:db" (tcp/ip, unix address and SID). On ODBC test program,
>> after I type in user ID/passwd. I have following error message:
>>
>> sqlstate:s1000
>> native error code: 3121
>> driver message: ... ORA-03121: no interface driver connected -
>> function not performed
>>
>> Can anyone tell me why? Thank you for help.
Received on Fri Apr 26 1996 - 00:00:00 CEST