This section has been set up in response to a request for information about such utilities, freeware, shareware and expensiveware as TOAD, SQL*XL, Patrol, Spotlight, etc. The pages referenced will follow a standard format, allowing users to make their personal comments about the good, bad, or indifferent points about such tools. No anonymous postings will be accepted.

Answer: There are two ways you can connect to an Oracle database. The first way is to go through ODBC (see TechNote 8167 for details on how to create a datasource). The second way is a direct connection to Oracle. Connections to Oracle 8.0.4 and Oracle 8.1.6 (or 7) are supported. Oracle 9i is supported with the updated MicroStation Oracle server files available from Web Downloads. See FAQ 6228 for more information.

We are using the type 4 JDBC driver from Oracle. You can download this driver from the Oracle website at technet.oracle.com or get it from the Oracle installation CD. Follow the instructions that come with the JDBC driver. It is fairly straight forward. We assume that the Oracle Host Server is 7.3.2 and above.

A database is a large, organized collection of information used for storage and retrieval. Maricopa strategically chose to move, prior to implementation, from an SQL database to the Oracle database. There are significant technical advantages in making this move, most of which will be invisible to the end user.

JDBC allows you to write SQL queries as Java Strings, pass them to the database, and get back results that you can parse. To access database from your servlet, make sure JDBC driver for the database you are accessing is accessible to Web Server (Tomcat). For example, in Tomcat to access Oracle database through JDBC driver for Oracle, you need to place classes111.zip (renamed to classess111.jar) or classes12.jar in /WEB-INF/lib directory of the application or /common/lib directory of Tomcat.

Oracle provides two connectivity solutions to address the needs of disparate data access: Oracle Transparent Gateways and Oracle Generic Connectivity. Oracle Transparent Gateways provides access to many non-Oracle data stores, including Microsoft SQL Server, Informix, Ingres, and Sybase from an Oracle environment. Oracle Generic Connectivity provides access to many data stores for which Oracle does not have a gateway solution. This feature enables transparent connectivity using ODBC and OLE DB.

It is necessary to include the following line before first connect: SrvApiDLLs[stOracle] := 'ORA73.DLL'; // for Oracle 7.3.x or SrvApiDLLs[stOracle] := 'ORA72.DLL'; // for Oracle 7.2.x After that you can use a connect string '2:ORCL' for TSDDatabase.RemoteDatabase property for login without TNS.

The most common cause is the move towards UTF-8 as the database character set. This is a good idea but unfortunately there appear to be implementation issues which need to be resolved. Basically, if the character set on the client is set to the same as the character set on the server then Oracle does not validate that the character data passed to it is actually valid.

There are currently several ways to access the Oracle database remotely. You can use SQL Plus or any other third party database administrative tool that does not require DBA access.

Use the ALTER TABLESPACE command to change the MINIMUM EXTENT value or the DEFAULT STORAGE parameters for a tablespace.

This is the free version of the Oracle 10g Database. Express Edition is free to download, develop and deploy with any application. In our case, we can bundle ALCiE Complimentary Edition with this free Oracle Database to deliver a zero-cost accounting solution! Click here to view the Oracle Database Express Edition data sheet. The great thing about ALCiE CE is that it is the identical set of applications as those contained in ALCiE SME (Small and Mid-sized Enterprise) Edition.

The Child Project™ system connects and transfers information via the Web. All that is needed to connect and share data is web connection -- either a dial up or other connection, such as a county local area network. The only difference will be the speed of the network.

DSN-less connections are faster than System DSN connections because DSN-less avoids doing a registry lookup. Furthermore you can receive additional performance benefits by directly using the OLEDB layer.

The JDBC adaptor was designed to allow use with any JDBC driver (hence any database that has a JDBC driver). However, the adaptor has to be certified with the JDBC driver as there can be some minor differences between drivers especially when it comes to the SQL they support and the metadata information they provide. We have certified the adaptor for Oracle, Sybase, JDataStore, MS SQLServer, Interbase and DB2 UDB.

The native driver and a version of the Toolbox for Java, which includes the type 4 driver, comes with OS/400. One can also purchase or get an evaluation...

The Oracle RDBMS on Windows web site describes how the Oracle database operates on Windows, as well as provides tips on performance tuning. Oracle offers a variety of data access methods for COM-based, .NET-based, and Win32/64-based programming languages. Oracle developers can use any one of the following data access drivers based on the Windows programming language employed: NET: Oracle Data Provider for .NET, OLE DB.NET via Oracle Provider for OLE DB, ODBC.

Author: John Zukowski (http://www.jguru.com/guru/viewbio.jsp?EID=7) Oracle basically has two JDBC drivers: an OCI driver which includes native code and a Thin driver which is 100% Pure Java. Since the OCI driver includes native code, it cannot be used in applets. You must use thin driver. You can get all Oracle JDBC drivers from http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm.

TOMCAT throws the following exception when i try to connect to Oracle DB from JSP. javax.servlet.ServletException : oracle.jdbc.driver.OracleDriver Root Cause : java.lang.ClassNotFoundException: oracle:jdbc:driver:OracleDriver But, the Oracle JDBC driver ZIP file (classes111.zip)is available in the system classpath.