Re: ODBC in Windows 95 and NT

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1997/02/23
Message-ID: <xhA6gBAmXAEzEwwK@jimsmith.demon.co.uk>#1/1

In article <330c664a.6558892_at_news.cww.de>, Tim Madel <tmadel_at_leg.state.va.us> writes
>I'm trying vainly to attach to an Oracle database from a Windows 95
>client via ODBC. My connect string is t:senate3. When I attempt to
>use the ODBC connection tester, I receive the error:
>
>SQLSTATE: S1000
>Native Error Code: 3121
>Driver Message:[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-03121: no
>interface driver connected - function not performed
>
>
>The strange thing is that I am successful attaching to the database
>using Enterprise manager or SQL*Plus etc.
>
>Am I missing something?
>

t:senate3 does not look like a valid connect string.

For SQLNet V1 it should be t:<hostname>:<oracle_sid> For SQLNet V2 it should be tns:<alias> or possibly just <alias>

-- 
Jim Smith

Received on Sun Feb 23 1997 - 00:00:00 CST