Microsoft Word - J doc

Transcription

1 Oracle Objects for OLE for Windows : J : : Oracle Windows Windows NT 4.0 Windows 2000 Windows 95 Windows 98 Windows NT Windows NT 4.0 Windows 2000 Oracle Objects for OLE R Net8 R8.1.6 Net8 R8.1.5 Oracle Oracle Oracle Corporation Oracle7 Oracle8i PL/SQL Oracle Objects for OLE Oracle Corporation Copyright 2000, Oracle Corporation All Right Reserved

2 Document CD-ROM... 5 README Windows Windows 95 TCP/IP... 9 Windows Terminal Server Oracle Universal Installer FAT NTFS Oracle Objects for OLE OO4O R Long/Long Raw BLOB CLOB BFILE Oracle Objects for OLE for Windows

3 C empedt Oracle In-Process Server Oracle Oracle IIS/ASP Oracle Objects for OLE CreateSQL NonBlockingState Cancel Oracle Provider for OLE DB R Microsoft Visual Basic Microsoft Visual C

4 8.1.6 Windows 2000 Windows 95 TCP/IP Windows Terminal Server 4 Oracle Objects for OLE for Windows

5 Oracle8i Release 2 Release R8.1.6 Oracle8i URL Document CD-ROM Oracle8i for Windows NT E CD-ROM README %ORACLE_HOME% relnotes README README README README CD 5

6 8.1.6 Oracle8i Client Net8 Products Net8 Client Oracle Protocol Support Oracle TCP/IP Protocol Support Oracle Named Pipes Protocol Support Oracle SPX/IPX Protocol Support Oracle LU6.2 Protocol Support *(1) Oracle Utilities Oracle Performance Monitor for Windows NT *(3) Oracle Database Utilities SQL*Plus Oracle Java Products Oracle JDBC drivers Oracle JDBC/OCI Driver for JDK Oracle JDBC/OCI Driver for JDK Oracle JDBC/Thin Driver for JDK Oracle JDBC/Thin Driver for JDK Oracle SQLJ Oracle Java Tools Oracle Programmer Development Tools Oracle Call Interface (OCI) Object Type Translator Oracle Objects for OLE Oracle Objects for OLE *(6) Oracle ODBC Driver Oracle Provider for OLE DB Pro*C/C Pro*COBOL Pro*COBOL Oracle Objects for OLE for Windows

7 Oracle Enterprise Manager Products Oracle Enterprise Manager Client Oracle Enterprise Manager Console Oracle Enterprise Manager Integrated Applications Oracle intermedia Text Manager Oracle Enterprise Security Manager Oracle Developer Server Forms Manager Net8 Integration *(4) Oracle Application Server Manager *(4) Oracle Parallel Server Manager Oracle Replication Manager Oracle Spatial Index Advisor Beta *(2) Oracle Directory Server Manager Oracle Applications Manager Oracle Enterprise Manager Migration Assistant Oracle DBA Management Pack Oracle Schema Manager Oracle Storage Manager Oracle Security Manager Oracle Instance Manager SQL*Plus Worksheet Oracle DBA Studio Oracle Enterprise Manager Quick Tours Oracle DBA Management Pack Quick Tour Oracle Enterprise Manager Quick Tour Oracle Installation Products Oracle Universal Installer Oracle AppWizards for Microsoft Visual Studio Oracle AppWizard for Microsoft Visual C *(5) Oracle Migration Workbench *(1) MS Access Plugin *(1) MS SQL Server 6.5 Plugin *(1) MS SQL Server 7.0 Plugin *(1) Sybase Adaptive Server 11 Plugin *(1) 7

8 Oracle Services for Microsoft Transaction Server *(3) Oracle Advanced Security Oracle intermedia Client Option Oracle Visual Information Retrieval Client *(1) Oracle Internet Directory Client : *(1) *(2) *(3) Oracle8i Client Windows NT/2000 *(4) Oracle8i Client Windows NT *(5) Microsoft Visual C *(6) Oracle Objects for OLE Oracle Objects for OLE for Windows

9 Windows 2000 Oracle Objects for OLE for Windows Windows 2000 Windows 95 TCP/IP Oracle TCP/IP Protocol Support for Windows 95/98 Windows Sockets 2 Windows 95 Oracle Objects for OLE for Windows Windows Socket 2 Update for Windows 95 Microsoft Web Windows Socket 2 Update for Windows 95 CD-ROM WINSOCK2 WS2SETUP.EXE Windows Socket 2 Update for Windows 95 TCP/IP Web Windows 95 Windows Socket 2 Update for Windows 95 TCP/IP 1.3 Oracle Oracle TCP/IP Protocol Adapter Windows Sockets /8.0.4 Windows Socket 2 Update for Windows Windows Terminal Server Windows NT Terminal Server Edition Windows 2000 Server 9

10 Oracle Universal Installer PATH 1024 Oracle PATH PATH PATH OK [Ctrl]+[Alt]+[Delete] EXPLORER.EXE CONTROL.EXE PATH OS Loader Last Known Good Menu Windows NT Last Known Good Menu Oracle Oracle Universal Installer (OUI) 1.7.x Windows NT NetWare CD-ROM Windows NT Oracle Universal Installer Java Runtime Environment <location> Oracle Universal Installer Novell JRE_LOCATION 8 10 Oracle Objects for OLE for Windows

11 CD-ROM Windows NT Oracle Universal Installer Windows NT 4.0 SP5 ATI Oracle Universal Installer Windows NT Oracle Universal Installer 2 Oracle8i 1. Oracle8i Oracle Universal Installer 2 Java Runtime Environment JRE Oracle8i JRE Oracle8i JRE Oracle8i Oracle Enterprise Manager 2.0 Oracle8i Oracle Enterprise Manager 2.1 JRE Oracle Universal Installer Oracle8i Oracle Enterprise Manager 2.1 JRE JRE Oracle8i 11

12 8.1.6 CD-ROM Oracle Provider for OLE DB COM Oracle 1 Oracle Provider for OLE DB 1 Oracle Provider for OLE DB Oracle Universal Installer Microsoft <filename>.dll.old Oracle Universal Installer <filename>.dll.old <filename>.old msvcrt.dll msvcirt.dll msvcrt40.dll oleaut32.dll olepro32.dll mfc40.dll mfc42u.dll mfc42.dll Novell Client for Windows NT Oracle Universal Installer Windows 95/98 autoexec.bat path Bug# path 12 Oracle Objects for OLE for Windows

13 2. autoexec.bat.old0 %ORACLE_HOME% bin path FAT NTFS FAT NTFS FAT Oracle Universal Installer FAT 32K NTFS 2K Oracle8i Client RAM FAT NTFS 64MB 678MB 236MB 19MB 32MB 164MB 102MB 16MB 32MB 93MB 48MB 16MB 13

14 Oracle Objects for OLE OO4O R Windows NT 4.0 Windows 95 Windows 98 Intel PC MHz Pentium 3. 8 MB 16 MB 4. OO4O 10 MB 5. 10MB 6. OLE 32 Visual Basic 4.0/5.0/6.0 Excel 95/97 C++ 32 Microsoft Visual C++ 6.x 7. Net8 Client Oracle CD-ROM Oracle Objects for OLE 2. Oracle Installation Products Universal Installer Oracle Universal Installer 3. Oracle8i Oracle 14 Oracle Objects for OLE for Windows

15 <CD-ROM ROOT>: oo4o81637 products.jar Oracle Objects for OLE ORACLE 1 1 Windows 95 Oracle Objects for OLE MFC MFC42.DLL OUI Oracle Objects for OLE MFC42.DLL Oracle Objects for OLE REGSVR32 %ORACLE_HOME% BIN ORADC.OCX %ORACLE_HOME% Oracle Objects for OLE Oracle <CD-ROM ROOT>: oo4o_help %ORACLE_HOME% MSHELP Oracle Objects for OLE Windows NT Windows 95 Windows 98 Microsoft Visual C++ 6.x C++ Oracle Oracle Objects for OLE OO4O R

16 Windows NT Windows 95 Windows OLE Automation Server Microsoft MFC 6.x 32 Windows NT Windows 95 Windows Oracle.OCX SQL PL/SQL OraDynaset GetRows Iterator OraCollection C++ OraDatabase OAQ OAQAgent OAQMsg OMetaData OMDAttribute Microsoft Transaction Server MTS OLE Oracle8i OBlob OClob OBFile 16 Oracle Objects for OLE for Windows

17 ORef Oracle8i - REF OObject OCollection VARRAY NESTED TABLE C++ Internet Information Server OO4O C++ %ORACLE_HOME% OO4O CPP WORKBOOK IIS %ORACLE_HOME% OO4O IIS Visual Basic %ORACLE_HOME% OO4O VB %ORACLE_HOME% OO4O CPP WORKBOOK CPP AQ LOB Metadata OBJECTS VARRAY Long/Long Raw BLOB CLOB BFILE Oracle8i BLOB CLOB BFILE Oracle Objects for OLE Long Long Raw Long Raw BLOB CLOB BFILE Long Raw BLOB CLOB BFILE Long Long Raw BLOB CLOB BFILE AppendChunk AppendChunkByte GetChunk GetChunkByte GetChunkByteEx ReadChunk Oracle Objects for OLE OO4O R

18 NULL BLOB CLOB Empty Chunk BLOB/CLOB/BFILE Read Write OO4O VB Visual Basic 6.0 OO4O OIP8.TLB OO4O ORADC.OCX ASP %ORACLE_HOME% oo4o Iis Samples ASP ConnPool C++ ORACLM32.LIB ORACL.H ORACLM32.LIB empedt32 Visual C omfc50.lib Visual C omfc60.lib 1. Visual C Oracle Objects for OLE for Windows

19 3. omfc50.lib omfc60.lib %ORACLE_HOME% MSHELP - Oracle Objects for OLE %ORACLE_HOME% OO4O - SQL %ORACLE_HOME% OO4O CPP - DLL %ORACLE_HOME% OO4O CPP MFC - MFC Bound %ORACLE_HOME% OO4O EXCEL SAMPLES - Excel %ORACLE_HOME% OO4O VB SAMPLES - Visual Basic %ORACLE_HOME% OO4O VB SAMPLES QT - Visual Basic Quick Tour %ORACLE_HOME% OO4O IIS SAMPLES - IIS Oracle Objects for OLE Oracle ORADC.OCX DOS regsvr32.exe oradc.ocx OCX Oracle In-Process Server Oracle Objects for OLE OO4O R

20 Oracle Oracle IIS/ASP Oracle In-Process Server OraParameter OraParamArray RAW ORATYPE_RAW RAW 16 ORATYPE_RAW_BIN IN NULL OUT OUT 128 OraParameter MinimunSize OraParameters.AddTable OraParamArray ElementSize ORATYPE_RAW_BIN KB OraParamArray OraParamArray ORATYPE_RAW ORATYPE_RAW_BIN %ORACLE_HOME% OO4O VB SAMPLES RAW OraAQ MonitorStart DCOM Win95 Win95 DCOM OLE32.DLL MFC42.dll regsvr32.exe %ORACLE_HOME% bin oip8.dll oradc.ocx 20 Oracle Objects for OLE for Windows

21 NCHAR NVARCHAR2 ORA NCHAR NVARCHAR2 OO4O 2.3.x OO4O 2.3.x ORADYN_ORAMODE LOB ORADYN_ORAMODE LOB Lob Object REF OIP-4119: BLOB CLOB Object REF Visual Basic 6.0 : '5': VB 6.0 < > = & Visual Basic 6.0 Visual Basic 5.0 MsgBox "Ename:"& OraDynaset.Fields!ENAME MsgBox "Ename:"& OraDynaset.Fields("ENAME") If OraDynaset.Fields!EMPNO = 7222 Then Msgbox "Hello World" If OraDynaset.Fields("EMPNO") = 7222 Then Msgbox "Hello World" Value "!" Oracle Objects for OLE OO4O R

22 < > = & Msgbox VB5 VB6 MsgBox OraDynaset.Fields!ENAME MsgBox OraDynaset.Fields("ENAME") int_var = OraDynaset.Fields("EMPNO") Msgbox "Empno:"& int_var MS Knowledge Base Q194368:Operators Do Not Recursively Call Object Default Properties Windows 95 Windows 95 OO4O InProcServer32 ThreadingModel = "Both" NT OpenDatabase ORADB_NOWAIT 2.3 OraDynaset OraSqlStmt ExecuteSQL 2.3 OO4O R BeginTrans CommitTrans ExecuteSQL CreateSQL select... for update NOWAIT select... for update LONG LONG RAW ChunkSize ChunkSize K GetChunk GetChunkByte GetChunkByte GetChunkByteEx ReadChunk 22 Oracle Objects for OLE for Windows

23 MoveTo MoveRel Movexxxxn MoveTo: Row ID MoveFirst MoveTo ID MoveRel Movexxxxn: MoveNext MovePrev Find like DUAL VB VB Oracle DD-MON- YYYY 1 Oracle OO4O SQL TO_CHAR(date, fmt) SQL TO_DATE OIP VB NO_CACHE FindPrevious FindLast NoMatch TRUE Oracle Objects for OLE OO4O R

24 ADD ADDTABLE ORAPARM_INPUT OUTPUT BOTH IOTYPE ORAPARM_INPUT IN ORAPARM_OUT OUT ORAPARM_BOTH IN OUT IN ORAPARM_BOTH ORAPARM_BOTH IN OUT IN OUT 2 Oracle Oracle Visual Basic OCX Microsoft VB OCX Oracle Microsoft VB Oracle Microsoft Visual Basic Sheridan Data Widgets FarPoint Data Bound Grid Control VC++ Microsoft Visual Basic VB Edit 24 Oracle Objects for OLE for Windows

25 Picture Image Oracle Long Raw Long Raw AppendChunk Long Raw BLOB BLOB Microsoft OLE OLE VB 4.0 VB Microsoft Data Bound ORADC.UpdateRecord MoveNext MovePrevious Microsoft Data Bound ORADC.UpdateRecord MoveNext MovePrevious Microsoft Data Bound Data Control Recordset EOF BOF ORADC1.Recordset BOF EOF BOF EOF TRUE EOF MoveFirst MoveLast BOF MoveLast MoveFirst Scroll DBGRID.Scroll Refresh DBGRID.Refresh ORADC.Recordset.Refresh Oracle Objects for OLE OO4O R

26 [Del] 1 2 ORADC.Recordset.Delete MSGRID DBGRID.Bookmark Oracle Objects ORADC.Recordset.Bookmark DBGRID.Bookmark ORADC.Recordset.Bookmark OIP-4121 ORADC.Recordset.Bookmarks SelBookmarks Oracle MSGrid DBGrid1.Bookmark DBGrid1.Bookmark ORADC.Recordset.Bookmark ORADC.Recordset.Bookmark DBGrid1.Bookmark = DBGRID.SelBookmarks(0) ORADC.Recordset.Bookmark = DBGRID.SelBookmarks(0) MSGRID SelBookmarks ORADC.Recordset.Bookmark DBGRID.Bookmark ORADC.Recordset.Bookmark OIP-4121 SelBookmarks ORADC.Recordset.Bookmarks Oracle MSGrid DBGrid1.Bookmark = DBGRID.SelBookmarks(0) (ORADC.Recordset.Bookmark =DBGRID.SelBookmarks(0) ) Sheridan Data Widgets Sheridan Data Bound 26 Oracle Objects for OLE for Windows

27 OIP NULL Sheridan Sheridan Data Bound Sheridan Data Bound Recordset EOF BOF ORADC1.Recordset BOF EOF BOF EOF TRUE EOF MoveLast BOF MoveFirst 1 ORADC.Recordset.Delete 1 MovePrevious MoveNext Sheridan 1 1 ORADC.Recordset.AddNew AddNew OIP-4118 MoveLast AddNew Sheridan 1 MoveLast Grid.MoveLast MoveLast ORADC.Recordset.MoveLast MoveRecords Oracle Objects for OLE OO4O R

28 Refresh SSDBGRID1.Refresh ORADC.Recordset.Refresh Sheridan Enhanced FarPoint Data Bound : Long Raw K Long Raw Farpoint Spread Farpoint Farpoint MovePrevious MoveNext Oracle RAW RAW C++ ODynaset: oresult GetFieldValue(int index, char *val, unsigned short maxlen, unsigned short *outlen) const; oresult GetFieldValue(const char *fieldname, char *val, unsigned short maxlen, unsigned short *outlen) const; oresult SetFieldValue(int index, const char *val, int len); oresult SetFieldValue(const char *fieldname, const char *val, int len); OField: oresult GetValue(const char **val, int *len) const; oresult SetValue(const char *val, int len); OParamArray: oresult GetValue(const char **val, int *len, int index) const; oresult SetValue(const char *val, int len, int index); 28 Oracle Objects for OLE for Windows

29 OParameter: oresult GetValue(const char **val, int *len) const; oresult SetValue(const char *val, int len); OParameterCollection: OParameter Add(const char *name, const char *value, int len, int iotype, int servertype); %ORACLE_HOME% OO4O CPP WORKBOOK RAW ORACLM32.LIB C++ VC ORACLM32.LIB ApartmentThreaded OStartup C++ OSTARTUP_MULTITHREADED OStartup 2.3 :CoInitializeEx() OLE32.DLL Win95 MultiThreading OStartup() NT 4.0 Windows 95 DCOM VC++ MFC42.DLL VC++ OIP MFC42.DLL IIS/ASP IIS 4.0 IIS 4.0 OO4O <OBJECT> Oracle Objects for OLE OO4O R

30 <OBJECT RUNAT=Server SCOPE=Application ID=OraSession PROGID="OracleInProcServer.XOraSession"></OBJECT> Application("OraSession") OraSession SCOPE=Application global.asa <OBJECT RUNAT=Server SCOPE=Application ID=OraSession PROGID="OracleInProcServer.XOraSession"></OBJECT> <SCRIPT LANGUAGE=VBScript RUNAT=Server> Sub Application_OnStart End Sub Sub Application_OnEnd End Sub </SCRIPT> ASP Long/Long ASP Long/Long Raw OraField GetChunkByteEx LOB Oracle Objects for OLE SQL PL/SQL OraSQLStmt ORASQL_STILL_EXECUTING ORASQL_SUCCESS OraSQLStmt OraSQLStmt Cancel() Cancel() 30 Oracle Objects for OLE for Windows

31 OraSQLStmt NonBlockingMode ORASQL_NONBLK OraDatabase CreateSql() OraSQLStmt OraSQLStmt 'Create the statement in NON-BLOCKING mode OraSQL = Oradb.CreateSQL("delete from emp",orasql_nonblk) OraSQLStmt OraSQLStmt NonBlockingState status = OraSQL.NonBlockingState if status = ORASQL_STILL_EXECUTING MsgBox "Stillin execution else 'Execution completed successfully OraSQLStmt Cancel() Oracle Objects for OLE OO4O R

32 OraSQLStmt OraSQLStmt OraSQLStmt OraSQLStmt CreateSql OraDynaset OraAQ BLOB CLOB BFILE OraSQLStmt OraDatabase Dim OraDatabase as OraDatabase Dim OraStmt as object Dim stat as long 'execute the select statement with NONBLOCKING mode on set OraStmt = OraDatabase.CreateSQL ("update emp set sal = sal ", ORASQL_NONBLK) 'Check if the call has completed stat = OraStmt.NonBlockingState if stat = ORASQL_STILL_EXECUTING then MsgBox "Asynchronous Operation under progress" else MsgBox "Asynchronous Operation completed with success" endif end if Dim OraSess as object Dim OraServ as object Dim OraDb1 as OraDatabase Dim OraDb2 as OraDatabase 32 Oracle Objects for OLE for Windows

33 Dim OraStmtnonblk as object Dim OraStmtblk as object Dim stat as long set OraSess = CreateObject("OracleInProcServer.XOraSession") set OraDb1 = OraSess.OpenDatabase("exampledb","scott/tiger",0&) Set OraServ = CreateObject("OracleInProcServer.XOraServer") set OraDb2 = OraServ.OpenDatabase("exampledb","scott/tiger",0&) 'execute the select statement with NONBLOCKING mode on set OraStmtnonblk = OraDb1.CreateSQL ("update emp set sal = sal ", 4&) 'Check if the call has completed stat = OraStmt.NonBlockingState if stat = ORASQL_STILL_EXECUTING then MsgBox "Asynchronous Operation under progress" else MsgBox "Asynchronous Operation completed with success" endif 'execute on the second connection in BLOCKING mode set OraStmtblk = OraDb2.CreateSQL ("update emp set sal = sal ",0&) 'The second connection can be used to execute SQL in blocking/non-blocking mode while the first 'is executing the nonblocking call CreateSQL OraDatabase SQL SQL OraSQLStmt Set orasqlstmt = oradatabase.createsql(sql_statement, options) Oracle Objects for OLE OO4O R

34 sql_statement options Oracle SQL SqlStmt 1 ORASQL_NO_AUTOBIND &H1& ORASQL_FAILEXEC &H2& SQL ORASQL_NONBLK &H4& SQL oraconst.txt SQL 1 ASCII 10 ASCII 13 Oracle NULL PL/SQL OraParameters SQL CreateSQL BeginTrans PL/SQL PL/SQL BEGIN END SQL*Plus SQL*DBA EXECUTE SQL_FAILEXEC SQL SQL SQL 34 Oracle Objects for OLE for Windows

35 : SQL PL/SQL Edit CreateSQL String NonBlockingState OraSQLStmt SQL ORASQL_STILL_EXECUTING status = OraSQL.NonBlockingState if status = ORASQL_STILL_EXECUTING MsgBox "Stillin execution else 'Execution completed successfully ORASQL_STILL_EXECUTING(-3123) ORASQL_SUCCESS(0) Cancel OraSQLStmt SQL Oracle Objects for OLE OO4O R

36 status = OraSQL.NonBlockingState if status = ORASQL_STILL_EXECUTING OraSQL.Cancel ORASQL_SUCCESS(0) ORA-4153 ORA Oracle Objects for OLE for Windows

37 Oracle Provider for OLE DB R : Oracle Provider for OLE DB Windows 95 OraOLEDB COM ORACLE 1 1 OraOLEDB OraOLEDB OraOLEDB Microsoft Visual Basic 6.0 Microsoft ActiveX Data Objects Microsoft ActiveX Data Objects Recordset Microsoft Visual C VC++.cpp OraOLEDB.h.cpp 1 #define DBINTCONSTANTS JOIN ADO ADO Dim objcon As New ADODB.Connection Dim objrst As New ADODB.Recordset objcon.provider = "OraOLEDB.Oracle" objcon.open "db815", "scott", "tiger" Oracle Provider for OLE DB R

38 objrst.cursorlocation = aduseclient 'ADO Client Cursor objrst.open "select ename, dname " & _ "from emp, dept " & _ "where emp.deptno = dept.deptno", _ objcon, adopenstatic, adlockoptimistic, adcmdtext JOIN CursorLocation aduseclient 1.2 CursorLocation aduseclient Client Cursor ADO LOB /LONG aduseserver 1.3 ADO CacheSize ADO FetchSize ConnectionString Oracle Provider for OLE DB CacheSize FetchSize < 1 FetchSize ADO LOB / INSERT/UPDATE SQL LONG LONG RAW ADO AppendChunk ADO AddNew ADO Update LONG LONG RAW 2.2 COMMIT ROLLBACK SAVEPOINT SQL DDL CREATE TABLE ALTER VIEW Oracle DDL DDL 2.3 Oracle EMP emp 2 38 Oracle Objects for OLE for Windows

39 SQL SELECT ename FROM emp EMP SELECT ename FROM "Emp" Emp Oracle 2.4 OraOLEDB /*+... */ LEVEL ROWID ROWNUM SQL SYSDATE UID USER SQL 2.6 BFILE BFILE INSERT INTO topomaps (areanum, topomap) VALUES (158, BFILENAME('mapdir', 'topo158.tps')) 2.8 Oracle8i 2.9 PL/SQL PROCEDURE_PARAMETERS PL/SQL / OLE DB / 2.10 LOB UPDATE SomeTable SET LobCol =?WHERE... Oracle Provider for OLE DB R

40 UPDATE LOB BLOB/CLOB LONG LONG/LONG RAW 2.11 LOB INSERT UPDATE LOB 2.12 Oracle 2.13 ADO GetChunk() ADO LOB LONG rst("lob_column").value ADO 2.14 OLE DB CONNECTIONSTATUS 3. OraOLEDB a. OLE DB HRESULT 3. ID b ID a. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceFileName 40 Oracle Objects for OLE for Windows

41 TraceFileName TraceOption 0 TraceOption 1 ID TraceOption b. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceCategory 0 = 1 = OLEDB 2 = OLEDB 4 = TraceCategory TraceCategory 3 c. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceLevel 0 = 1 = 2 = 4 = 8 = 16 = TraceLevel OLE DB OLE DB 1 OLE DB TraceLevel TraceLevel 12 TraceCategory 3 Oracle Provider for OLE DB R

42 d. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceOption 0 = 1 = TraceOption ID 1 TraceFileName ID 42 Oracle Objects for OLE for Windows