2023-01-26

connect from PowerShell to Oracle DB in a simple way

 How to read data from Oracle Database via PowerShell without using ODBC or installing Oracle Client (and import it to SQL Server too) - T-SQL Tech (tsql.tech)

  1. Go to the lib\netstandard2.1\ folder and get the precious Oracle.ManagedDataAccess.dll file, that’s all we need
  2. Now that you have the magic DLL, put it in the same folder as the script you’re going to write, and follow this example:
  3. $OracleDLLPath = ".\Oracle.ManagedDataAccess.dll"
  4. Add-Type -Path $OracleDLLPath
Publicat de la

Niciun comentariu:

Trimiteți un comentariu

Abonați-vă la: Postare comentarii (Atom)