by John Bringol » Fri, 14 Nov 1997 04:00:00
Having trouble getting the Oracle ODBC driver on NT4 to connect. TNSPING
is OK and other Native Driver application connect OK. ODBC Test returns:
SQLSTATE: 08003
Native Error Code: 0
Driver Message:[ORACLE][ODBC Oracle Driver]COnnection not open.
Any hints or thoughs of what to look for.
Thanks JB
by Matthias Gre » Sat, 15 Nov 1997 04:00:00
> Having trouble getting the Oracle ODBC driver on NT4 to connect. TNSPING
> is OK and other Native Driver application connect OK. ODBC Test returns:
> SQLSTATE: 08003
> Native Error Code: 0
> Driver Message:[ORACLE][ODBC Oracle Driver]COnnection not open.
> Any hints or thoughs of what to look for.
> Thanks JB
need some more info about your config.
1. db-alias
2. 16-bit or 32-bit ODBC with config-info (16 bit odbc.ini, 32-bit
registry dump)
3. when do you get this message? example code.
--
Regards
Matthias Gresz :-)
by Billy Verreynn » Tue, 18 Nov 1997 04:00:00
> Having trouble getting the Oracle ODBC driver on NT4 to connect. TNSPING
> is OK and other Native Driver application connect OK. ODBC Test returns:
> SQLSTATE: 08003
> Native Error Code: 0
> Driver Message:[ORACLE][ODBC Oracle Driver]COnnection not open.
regards,
Billy
by Chris Fenstermake » Wed, 19 Nov 1997 04:00:00
I get the same message on SQLDriverConnects in my apps using the Ora73Quote:> Having trouble getting the Oracle ODBC driver on NT4 to connect. TNSPING
> is OK and other Native Driver application connect OK. ODBC Test returns:
> SQLSTATE: 08003
> Native Error Code: 0
> Driver Message:[ORACLE][ODBC Oracle Driver]COnnection not open.
> Any hints or thoughs of what to look for.
> Thanks JB
Regards
Chris
by s » Thu, 20 Nov 1997 04:00:00
That is because you have installed ODBC 3.0 manager but are still
using v1 ODBC driver. v3 Manager requires a v2 or v3 driver...
Download the v2 driver from the oracle website.
-sm
On Thu, 13 Nov 1997 14:13:56 -0500, John Bringolf
>SQLSTATE: 08003
>Native Error Code: 0
>Driver Message:[ORACLE][ODBC Oracle Driver]COnnection not open.
>Any hints or thoughs of what to look for.
>Thanks JB
by Marco Scher » Sat, 22 Nov 1997 04:00:00
--------------37209B5D4C4D02AB6336C7E5
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
> SQLSTATE: 08003
> Native Error Code: 0
> Driver Message:[ORACLE][ODBC Oracle Driver]COnnection not open.
> Any hints or thoughs of what to look for.
> Thanks JB
Ask Oracle for the Download.
Bye,
Marco Scherb
--
------------------------------------------------------------------------
Westf. Wilhelms-Universit?t Mnster | Tel. : (49) 251 8348192
Klinik und Poliklinik fr Neurologie | Fax : (49) 251 8348181
Albert-Schweizer Str. 33 |
D-48129 Mnster |
------------------------------------------------------------------------
--------------37209B5D4C4D02AB6336C7E5
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<HTML>
<BLOCKQUOTE TYPE=CITE>Having trouble getting the Oracle ODBC driver on
NT4 to connect. TNSPING
<BR>is OK and other Native Driver application connect OK. ODBC Test returns:
<P>SQLSTATE: 08003
<BR>Native Error Code: 0
<BR>Driver Message:[ORACLE][ODBC Oracle Driver]COnnection not open.
<P>Any hints or thoughs of what to look for.
<P>Thanks JB</BLOCKQUOTE>
You probably have installed Service Pack 3 for NT4.
<BR>In this case you need a new ODBC Driver from Oracle.
<P>Ask Oracle for the Download.
<P>Bye,
<P>Marco Scherb --------------37209B5D4C4D02AB6336C7E5--
<PRE>--
------------------------------------------------------------------------
Westf. Wilhelms-Universität Münster | Tel. : (49) 251 8348192
Klinik und Poliklinik für Neurologie | Fax : (49) 251 8348181
Albert-Schweizer Str. 33 |
D-48129 Münster &nb
------------------------------------------------------------------------</P
</HTML>
1. ODBC and NT4.0 and Visiual C++ 5.0 and MS-Office 97
I was able to create a System Data Source this when I had NT 4.0
Workstation (no service packs), VC++ 4.2, and MS Office 95.
I have since gotton a new PC with NT 4.0 (no service packs) and I
installed VC++ 5.0 and MS-Office 97 (with drivers and Access and ODBC).
Since then I get a new style (GUI) odbcad32 window. I can't create a
DSN that allows CDatabase.OpenEx() to work.
Is there any know problems using these software components together?
I can't create an ACCESS DSN or an SQL DSN that creates a good
ConnectString for later use to do a programmatic OpenEx on the same
database that the connectstring was created.
Lisa Lombardo
=============================================
Lisa Lombardo Courion Corporation
http://www.courion.com Natick, MA 01760
FAX: 508-650-0001 Phone: 508-650-0330
=============================================
3. Seeking classes: jdbc.odbc.* for NT4.0
4. Testing
5. ODBC on NT4 another Problem
7. Help with ODBC on NT4 running Oracle7
8. DIRECT vs. CONVENTIONAL in Export
9. odbc with nt4.02b2 & paradox70
10. Help needed installing ODBC on NT4 sp4
11. how to reinstall ODBC on NT4
12. Can't access SQL2000 thur ODBC on NT4.0
13. Q:ODBC from NT4.0 to Novell?