Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ODBC using Microsoft driver version 2.573.4202

RE: ODBC using Microsoft driver version 2.573.4202

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 6 Sep 2000 23:57:16 -0000
Message-Id: <10611.116359@fatcity.com>


Thanks for the help.

What versions of Oracle do you have on your Windows 2000 client? eg do you have just 816 installed or do you have a forms client = installed as
well?

Thanks,
Bruce

-----Original Message-----
From: Schoen Volker [mailto:v.schoen_at_inplan.de] Sent: Wednesday, 6 September 2000 20:05
To: Multiple recipients of list ORACLE-L Subject: AW: ODBC using Microsoft driver version 2.573.4202

I tested it with following ODBC-Version on Windows 2000, works fine:

odbc32.dll 3.520.4403.2
msorcl32.dll 2.573.4403.00

Maybe you can download this ODBC-Version from Microsoft Homepage.

I can't understand why you can't use Oracle ODBC-driver. If you Disable = MTS
Support in ODBC-driver config, you can call stored procedures without problems.

Hope this will help

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Reardon, Bruce (CALBBAY)
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au] Gesendet: Mittwoch, 6. September 2000 07:54 An: Multiple recipients of list ORACLE-L Betreff: ODBC using Microsoft driver version 2.573.4202

Hi,

I am trying to use the Microsoft ODBC driver against Oracle.

On one NT machine it works, and on the other it doesn't

They are both using the same versions of most things (these are the = versions
from MDAC 2.1)
driver 2.573.4202,=20
SP4,=20
odbc32.dll 3.510.4202
msorcl32.dll 2.573.4202

One PC has Oracle 815, Oracle 816, OEM 204 installed and has had 805 in = the
past

The other one has just Oracle 816.

The one with just Oracle 816 can not connect to the database at all Using the ODBC test program from Oracle I get an error that says

SQLSTATE: NA00
Native Error Code:0
Driver Message:[Microsoft][ODBC driver for Oracle][Oracle]

Using ODBC Tracing via the control panel gives the rather long output = below.

What should I try next?

Unfortunately I can't use the Oracle ODBC driver for Oracle because the Applications calls stored procedures in a way that is not compatible.

Thanks,
Bruce Reardon
Analyst / Programmer
Comalco Aluminium (Bell Bay)
mailto:bruce.reardon_at_comalco.riotinto.com.au

ODBCTST         170:15c	ENTER SQLAllocConnect=20
		HENV                0x00cf11a8
		HDBC *              0x00df3058

ODBCTST         170:15c	EXIT  SQLAllocConnect  with return code 0

(SQL_SUCCESS)
HENV 0x00cf11a8 HDBC * 0x00df3058 ( 0x00cf1890) ODBCTST 170:15c ENTER SQLDriverConnectW=20 HDBC 0x00cf1890 HWND 0x000a01aa WCHAR * 0x1f72e06c [ -3] "******\ 0" SWORD -3=20 WCHAR * 0x1f72e06c=20 SWORD 8=20 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> ODBCTST 170:15c EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 0x00cf1890 HWND 0x000a01aa WCHAR * 0x1f72e06c [ -3] "******\ 0" SWORD -3=20 WCHAR * 0x1f72e06c=20 SWORD 8=20 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle] (0) ODBCTST 170:15c ENTER SQLErrorW=20 HENV 0x00000000 HDBC 0x00cf1890 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c EXIT SQLErrorW with return code 0 =
(SQL_SUCCESS)
HENV 0x00000000 HDBC 0x00cf1890 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 (0) WCHAR * 0x0012ed88 [ 43] "[Microsoft][ODBC driv" SWORD 511=20 SWORD * 0x0012f634 (43) ODBCTST 170:15c ENTER SQLErrorW=20 HENV 0x00000000 HDBC 0x00cf1890 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 0x00000000 HDBC 0x00cf1890 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c ENTER SQLAllocConnect=20 HENV 0x00cf11a8 HDBC * 0x00df3058 ODBCTST 170:15c EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 0x00cf11a8 HDBC * 0x00df3058 ( 0x00cf2428) ODBCTST 170:15c ENTER SQLDriverConnectW=20 HDBC 0x00cf2428 HWND 0x000a01aa WCHAR * 0x1f72e06c [ -3] "******\ 0" SWORD -3=20 WCHAR * 0x1f72e06c=20 SWORD 8=20 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> ODBCTST 170:15c EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 0x00cf2428 HWND 0x000a01aa WCHAR * 0x1f72e06c [ -3] "******\ 0" SWORD -3=20 WCHAR * 0x1f72e06c=20 SWORD 8=20 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle] (0) ODBCTST 170:15c ENTER SQLErrorW=20 HENV 0x00000000 HDBC 0x00cf2428 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c EXIT SQLErrorW with return code 0 =
(SQL_SUCCESS)
HENV 0x00000000 HDBC 0x00cf2428 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 (0) WCHAR * 0x0012ed88 [ 43] "[Microsoft][ODBC driv" SWORD 511=20 SWORD * 0x0012f634 (43) ODBCTST 170:15c ENTER SQLErrorW=20 HENV 0x00000000 HDBC 0x00cf2428 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 0x00000000 HDBC 0x00cf2428 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c ENTER SQLAllocConnect=20 HENV 0x00cf11a8 HDBC * 0x00df3058 ODBCTST 170:15c EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 0x00cf11a8 HDBC * 0x00df3058 ( 0x00cf26e0) ODBCTST 170:15c ENTER SQLDriverConnectW=20 HDBC 0x00cf26e0 HWND 0x000a01aa WCHAR * 0x1f72e06c [ -3] "******\ 0" SWORD -3=20 WCHAR * 0x1f72e06c=20 SWORD 8=20 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> ODBCTST 170:15c EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 0x00cf26e0 HWND 0x000a01aa WCHAR * 0x1f72e06c [ -3] "******\ 0" SWORD -3=20 WCHAR * 0x1f72e06c=20 SWORD 8=20 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle] (0) ODBCTST 170:15c ENTER SQLErrorW=20 HENV 0x00000000 HDBC 0x00cf26e0 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c EXIT SQLErrorW with return code 0 =
(SQL_SUCCESS)
HENV 0x00000000 HDBC 0x00cf26e0 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 (0) WCHAR * 0x0012ed88 [ 43] "[Microsoft][ODBC driv" SWORD 511=20 SWORD * 0x0012f634 (43) ODBCTST 170:15c ENTER SQLErrorW=20 HENV 0x00000000 HDBC 0x00cf26e0 HSTMT 0x00000000 WCHAR * 0x0012f188 (NYI)=20 SDWORD * 0x0012f630 WCHAR * 0x0012ed88=20 SWORD 511=20 SWORD * 0x0012f634 ODBCTST 170:15c EXIT SQLErrorW with return code 100

(SQL_NO_DATA_FOUND)
Received on Wed Sep 06 2000 - 18:57:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US