Message-Id: <10611.116359@fatcity.com> From: "Reardon, Bruce (CALBBAY)" Date: Wed, 6 Sep 2000 23:57:16 -0000 Subject: RE: ODBC using Microsoft driver version 2.573.4202 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@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@inplan.de http://www.inplan.de -----Urspr=FCngliche Nachricht----- Von: Reardon, Bruce (CALBBAY) [mailto:Bruce.Reardon@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@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 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 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 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 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 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 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)