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

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

ODBC using Microsoft driver version 2.573.4202

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 6 Sep 2000 04:41:01 -0000
Message-Id: <10610.116267@fatcity.com> 





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, 


SP4, 


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 
		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 
		HDBC                0x00cf1890
		HWND                0x000a01aa
		WCHAR *             0x1f72e06c [      -3] "******\ 0"
		SWORD                       -3 
		WCHAR *             0x1f72e06c 
		SWORD                        8 
		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 
		WCHAR *             0x1f72e06c 
		SWORD                        8 
		SWORD *             0x00000000
		UWORD                        1 <SQL_DRIVER_COMPLETE>

		DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle] (0)


ODBCTST         170:15c	ENTER SQLErrorW 
		HENV                0x00000000
		HDBC                0x00cf1890
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
		HENV                0x00000000
		HDBC                0x00cf1890
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630 (0)
		WCHAR *             0x0012ed88 [      43] "[Microsoft][ODBC
driv"
		SWORD                      511 
		SWORD *             0x0012f634 (43)

ODBCTST         170:15c	ENTER SQLErrorW 
		HENV                0x00000000
		HDBC                0x00cf1890
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	EXIT  SQLErrorW  with return code 100


(SQL_NO_DATA_FOUND)

		HENV                0x00000000
		HDBC                0x00cf1890
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	ENTER SQLAllocConnect 
		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 
		HDBC                0x00cf2428
		HWND                0x000a01aa
		WCHAR *             0x1f72e06c [      -3] "******\ 0"
		SWORD                       -3 
		WCHAR *             0x1f72e06c 
		SWORD                        8 
		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 
		WCHAR *             0x1f72e06c 
		SWORD                        8 
		SWORD *             0x00000000
		UWORD                        1 <SQL_DRIVER_COMPLETE>

		DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle] (0)


ODBCTST         170:15c	ENTER SQLErrorW 
		HENV                0x00000000
		HDBC                0x00cf2428
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
		HENV                0x00000000
		HDBC                0x00cf2428
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630 (0)
		WCHAR *             0x0012ed88 [      43] "[Microsoft][ODBC
driv"
		SWORD                      511 
		SWORD *             0x0012f634 (43)

ODBCTST         170:15c	ENTER SQLErrorW 
		HENV                0x00000000
		HDBC                0x00cf2428
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	EXIT  SQLErrorW  with return code 100


(SQL_NO_DATA_FOUND)

		HENV                0x00000000
		HDBC                0x00cf2428
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	ENTER SQLAllocConnect 
		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 
		HDBC                0x00cf26e0
		HWND                0x000a01aa
		WCHAR *             0x1f72e06c [      -3] "******\ 0"
		SWORD                       -3 
		WCHAR *             0x1f72e06c 
		SWORD                        8 
		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 
		WCHAR *             0x1f72e06c 
		SWORD                        8 
		SWORD *             0x00000000
		UWORD                        1 <SQL_DRIVER_COMPLETE>

		DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle] (0)


ODBCTST         170:15c	ENTER SQLErrorW 
		HENV                0x00000000
		HDBC                0x00cf26e0
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
		HENV                0x00000000
		HDBC                0x00cf26e0
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630 (0)
		WCHAR *             0x0012ed88 [      43] "[Microsoft][ODBC
driv"
		SWORD                      511 
		SWORD *             0x0012f634 (43)

ODBCTST         170:15c	ENTER SQLErrorW 
		HENV                0x00000000
		HDBC                0x00cf26e0
		HSTMT               0x00000000
		WCHAR *             0x0012f188 (NYI) 
 		SDWORD *            0x0012f630
		WCHAR *             0x0012ed88 
		SWORD                      511 
		SWORD *             0x0012f634

ODBCTST         170:15c	EXIT  SQLErrorW  with return code 100


(SQL_NO_DATA_FOUND)

		HENV                0x00000000


Received on Tue Sep 05 2000 - 23:41:01 CDT












Original text of this message













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