Search notes:

.env.default.local |work| 🎯 Recommended

ODP.NET is part of Oracle Data Access Components (ODAC). ODAC can be downloaded from OTN.
An ODP.NET driver has two components:

Locating OCI DLLs

ODP.NET tries to locate the native OCI DLLs with the value under the registry key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET\version (version being something like 2.122.18.1 or 4.122.18.1).
This value is supposed to store a path, typically %ORACLE_HOME%\bin.

.env.default.local |work| 🎯 Recommended

Even though it's committed, never put real API keys, passwords, or tokens in .env.default . Use placeholder values like changeme or your_key_here .

Common patterns are:

The .env.default.local file fills a specific gap. While .env.local is generally used to override the "production-ready" .env file, .env.default.local allows a developer to customize the "development defaults" found in .env.default . .env.default.local

// 1. Load the committed defaults dotenv.config( path: path.resolve(process.cwd(), '.env.default') ); Even though it's committed, never put real API

: Local overrides. Always gitignored. This is where your personal secrets go. Even though it's committed

Misc

ODP.NET and Microsoft .NET Framework Data Provider for Oracle are not the same thing. The former is developed by Oracle, the latter by Microsft.
ODP.NET requires an installed Oracle Client to be installed when used to establish connections to an Oracle server.

See also

The .NET namespace Oracle.DataAccess.Client
The set of ODP.NET classes is contained in the following assemblies: Oracle.ManagedDataAccess.dll, Oracle.DataAccess.dll
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET

Links

Oracle's .NET code samples on github.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1778280183, '185.104.194.44', 'Mozilla/5.0 (co...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/ODP_NET/index(123): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78