Hi, all
Today I upgraded ODAC 12c client for our product. I always used xcopy version. It's easy to deploy. But I met 2 issues in the newest xcopy version:
1. Dot not support folder with spaces.
My install command: install odp.net4 "C:\Program Files\Common Files\ODP.NET" TestODAC
The exception:
Invalid syntax.
Type "REG ADD/?" for usage.
Invalid syntax.
Type "REG ADD/?" for usage.
Solution:
Open configure.bat file and find
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319\AssemblyFoldersEx\ODP.Net" /ve /t REG_SZ /d %BAT_DIR%odp.net\bin\4 /f >> install.log
------>
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319\AssemblyFoldersEx\ODP.Net" /ve /t REG_SZ /d "%BAT_DIR%odp.net\bin\4" /f >> install.log
2. Can not use ODP.NET, Unmanaged Driver .
This is my provide settings:
<Provider DBType="Oracle"
Invariant="Oracle.DataAccess.Client"
ConnectionStringBuilder="BDNA.DAC.OracleDirectConnectionStringBuilder">
<ConnectionString>
<![CDATA[Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=${HOST})(PORT=${PORT})))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora11g)));
User Id=xxx;
Password="xxx";]]>
</ConnectionString>
</Provider>
The Exception: Application popup: DACTest.exe - System Error : The program can't start because oraons.dll is missing from your computer. Try reinstalling the program to fix this problem.
They are very strange issues. When I using setup version, Everything is ok. Anybody know what should I do? Any suggestion is great help for me. Thanks.