I'm making an application with ODP.NET Oracle.ManagedDataAcces.EntitiFramework
this is my connection string:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)));User Id=DB_DIGITAL_204;Password=123456;
When doing the consultations it works well for me. When I change the host to a non-remote server ( HOST=30.3.3.204
) I get the following exception:
System.Data.Entity.Core.ProviderIncompatibleException was unhandled Message=An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.
InnerException:
Message=The provider did not return a ProviderManifestToken string.
Source=EntityFramework
InnerException:
DataSource=Oracle.ManagedDataAccess
Message=Comunicación de Oracle: fallo al conectar al servidor o al analizar la cadena de conexión
Source=Oracle Data Provider for .NET, Managed Driver
InnerException:
Message=Comunicación de Oracle: fallo al conectar al servidor o al analizar la cadena de conexión
Source=Oracle.ManagedDataAccess
InnerException:
Message=No se pudo realizar una llamada a SSPI; consulte la excepción interna.
InnerException:
Message=No hay credenciales disponibles en el paquete de seguridad
I tried connecting to Host
remote% with another client ( SQL Dveloper
) and it works correctly. What is the problem? Thank you very much for your help.