Hi,
New to Visual Studio and .NET and I'm just trying to create a connection in Visual Studio that uses Windows integrated authentication. In Server Explorer, I right-click "Data Connections" and then click "Add Connection". I check "Use Windows integrated authentication" and use a TNS connection type and select my alias (FG01DEV).
I have Oracle Developer Tools for Visual Studio 2013 installed in C:\OracleDevToolsVS2013 and my tnsnames.ora is in: C:\OracleDevToolsVS2013\network\admin. My sqlnet.ora is also in this location. It contains the following:
SQLNET.AUTHENTICATION_SERVICES = (KERBEROS5)
SQLNET.AUTHENTICATION_KERBEROS5_SERVICE = oracle
SQLNET.KERBEROS5_REALMS = C:\krb5\krb5.realms
SQLNET.KERBEROS5_CONF = C:\krb5\krb5.conf
SQLNET.KERBEROS5_CONF_MIT = TRUE
SQLNET.KERBEROS5_CC_NAME = OSMSFT://
When I click the "Test Connection" button, I'm getting the following:
NA Kerberos5: Authentication handshake failure at stage: Could not load file or assembly
'Oracle.ManagedDataAccessIOP.dll or one of its dependencies. The specified module could not be found.
Word doc with screen shot is attached.
Even when I don't check "Use Windows integrated authentication" and enter a user and password, I get the same error.
From SQL Plus I can connect fine with the user and password and also using /@FG01DEV
I have also done the following:
- cd "C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools"
gacutil /i C:\OracleDevToolsVS2013\odp.net\managed\x86\Oracle.ManagedDataAccessIOP.dll
- I created an x86 folder in the root of the site and added Oracle.ManagedDataAccessIOP.dll
- Used NuGet Packager Manager to install ODP.NET Managed Driver and this added the appropriate sections in web.config
- I also tried adding this in web.config:
<settings>
<setting name="sqlnet.kerberos5_conf" value="C:\krb5\krb5.conf" />
<setting name="TNS_ADMIN" value="C:\OracleDevToolsVS2013\network\admin"/>
</settings>
Any ideas?
Thanks!