新增: 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时遇到的问题
沒有留言:
張貼留言