搜尋此網誌

2014-08-25

ORACLE client & ODP.Net

設定環境變數
新增:
ORACLE_HOME = C:\Oracle\32\instantclient_12_1
TNS_ADMIN = %ORACLE_HOME%
LD_LIBRARY_PATH = %ORACLE_HOME%

語系設定(視情況)
NLS_LANG = TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
或
NLS_LANG = TRADITIONAL CHINESE_TAIWAN.AL32UTF8

在PATH增加(不是取代)
;%ORACLE_HOME%

設定SQL Developer時間格式:YYYY-MM-DD HH24:MI:SSXFF TZR

查詢DB設定
SELECT name,value$ FROM sys.props$;
select userenv('language') from dual;
[Oracle]處理中文亂碼 -- NLS_LANG設定

tnsnames.ora






Oracle Database Online Documentation 12c Release 1 (12.1)
SQL and PL/SQL
.NET and Windows Application Development
2 Day Developer's Guide

Oracle Database Online Documentation 11g Release 2 (11.2)
SQL and PL/SQL
.NET and Windows Application Development
2 Day Developer's Guide
2 Day + .NET Developer's Guide for Microsoft Windows

Database Data Access Components Documentation 12c Release 2 (12.1.0.1.2)

SQL Developer Documentation
SQL Developer Data Modeler Documentation






Let It Go吧! System.Data.OracleClient *****

Oracle with .NET

安裝ORACLE client
Oracle 10g Client 安裝設定
[轉]OracleClient on Windows 2008 x64

ORA-12154 : TNS Could not resolve the connect Identifier
在64位元環境上利用SSIS存取Oracle資料

Package Load Failure VS 2008 Architect & 11.1.0.6.20
Copy MSVCR71.dll
from %ORACLE_HOME%\oui\lib\win32
to %ORACLE_HOME%






Oracle Database Instant Client Downloads & Installation
Instant Client Downloads

Oracle Database Client Installation Guide 12c Release 1 (12.1) for Microsoft Windows

Oracle 10/11G Instant Client

Oracle Instant Client安裝
安裝Oracle11g Instant Client結果找不到tnsnames.ora

Oracle Instant Client安裝
InstantClient安裝使用

Windows7x64 Toad 簡易安裝啟動使用






ODP.NET - Oracle Data Provider for .NET

Oracle Data Provider for .NET
Oracle .NET Developer Center
Oracle .NET 开发人员中心

An Easy Drive to .NET


Oracle Developer Tools for Visual Studio FAQ
Tech Article: ODP.NET, Managed Driver
ODP.NET, Managed Driver Introduction
Oracle Schema Compare in Visual Studio
Using Multitenant Container Databases in Visual Studio

ODAC 12c Release 2 (12.1.0.1.2) Installation Instructions, Setup, and Notes






[odp.net]
community Oracle .NET Sample Code

nuget






Connecting to Oracle from C# / Winforms / Asp.net without tnsnames.ora
Using generic database providers with C#
Using the new ODP.Net to access Oracle from C# with simple deployment

What is the minimum client footprint required to connect C# to an Oracle database?
How can i deploy a .Net Application that uses ODAC Without installing the Whole Component to the user ??

ODP.NET upgrade 10G to 11G

Using the Easy Connect Naming Method

.NET and Windows Application Development






Instant ODP.NET Deployment
Deploying ODP.NET with Oracle Instant Client
Oracle Instant Client with ODP.NET
C# 连接Oracle(利用ODP.net,不安装oracle客户端)
如何在 64 位元的 Windows 7 中安裝 PLSQL DEVELOPER 8 和 Oracle 11g x64 Client
Instant Oracle Using C#

【茶包射手日記】OracleClient分散式交易問題兩則
Accessing Oracle database without installing Oracle Client
再论使用Oracle Instant Client连接Oracle
【茶包射手日記】OracleDataReader數字型別對應陷阱(ODP.NET)
讓ODP.NET查詢快10倍的小密技-FetchSize


.NET Oracle Developer的福音——ODP.NET Managed正式推出

[SSIS][Oracle]安裝 Oracle Driver 提供 SSIS 使用






Deploying and Configuring ODP.NET to work without installation with Entity Framework
Does ODP.NET require Oracle Client installation



Petapoco 连接oracle11g 自动生成poco时遇到的问题

沒有留言: