目前正在實作把台銀公告匯率的資料抓下來然後分析後存入資料庫,
使用資料庫連接時出現下列錯誤訊息
sqlexecutor:431 Error: DPI-1047: Cannot locate a 64-bit Oracle Client library: “C:\oracle\product\10.2.0\client_1\bin\oci.dll is not the correct architecture”. See Installing node-oracledb Version 5.5.0 | node-oracledb for help
Node-oracledb installation instructions: Installing node-oracledb Version 5.5.0 | node-oracledb
You must have 64-bit Oracle Client libraries in your PATH environment variable.
If you do not have Oracle Database on this computer, then install the Instant Client Basic or Basic Light package from
Instant Client for Microsoft Windows (x64) 64-bit
A Microsoft Visual Studio Redistributable suitable for your Oracle client library version must be available.
詢問管理資料庫的同仁後得知,現有的資料庫是32bit,不是64,此外由於這隻程式未來是要提供給不同單位同仁使用,不可能每台電腦都安裝oracle。
想詢問是否有jdbc的連結畫面,讓我們可以用其他方式去連,謝謝