因緣際會,
安裝好VS 2022 Community之後,
想要使用C#連接Oracle Database,
發現居然是一件超級複雜的事情.
先使用Oracle SQL Developer確定連線一切正常,
也能下SQL Scripts撈出Data.
然後依照Oracle官方的教學說明文件,
https://reurl.cc/QZy0eq
每個步驟都弄好後,
得到以下錯誤訊息:
at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString
csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria,
String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString
csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria,
String affinityInstanceName, Boolean bForceMatch)
at
OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString
cs, PM conPM, ConnectionString pmCS, SecureString securedPassword,
SecureString securedProxyPassword, OracleConnection connRefForCriteria)
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
在程式碼異常拋出的偵錯顯示為:
Connection request timed out
看了VS 2019的安裝教學,
(確定是使用VS 2022,但是微軟官方是連接到VS 2019的安裝步驟)
https://www.youtube.com/watch?v=PCBUk4ZivnM
安裝完微軟官方VS 2022的安裝包,
Oracle.VsDevTools.17.0.vsix
沒用.
下載完微軟官方說的VS 2019 zip壓縮包,
卻怕裝錯,
不太敢安裝.
想請問VS 2022 Community + Oracle Cloud Infrastructure,
正常安裝方式?
請問有相關的教學連接嗎?