Le Kevin dot com

photographic-poetic-musical horizon

Browsing Posts in Database

Git Basic

No comments

What is git? Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency.     Basic Commands Clone a branch locally $ git clone -l -s -n . ../copy $ cd ../copy $ git show-branch Checkout a brach git checkout […]

Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle. ISVs and Partners benefit greatly from packaging […]

Finally, we can use oracle managed driver for independently developing application app.config sample < ?xml version="1.0" encoding="utf-8"?> <configuration> <configsections> <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess"></section> </configsections> <oracle .manageddataaccess.client> <version number="*"> <settings> <setting name="TNS_ADMIN" value="C:\Oracle\product\11.2.0\client_1\network\admin"></setting> </settings> </version> </oracle> </configuration>   via: http://www.oracle.com/technetwork/database/windows/downloads/odpmbetainstall-1696475.html#Configuration http://blog.vijay.name/2012/11/oracle-managed-odp-net/  

7 down vote accepted There is commonly no problem to connect to an older Oracle database with a newer client driver, e.g. to connect to a 10g or 11g database with a 12g Client. The rest of the answer belongs to technical problems which can occur in your .Net program in the case that an […]

Turns off substitution variables. set define off;