System.Data.Entity.Core.ProviderIncompatibleException An error occurred while getting information from the database provider

1

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.

    
asked by Carlos Miguel Carranza de la Q 30.11.2016 в 05:31
source

1 answer

0

The name of the instance, user / password will be different in the local remote environment usually.

You can use the tool tnsping of Oracle with Local Naming Parameters ( tnsnames.ora ) to check connectivity with host remote

Instead of using tnsnames.ora , use a connection string of the type:

Data Source=BaseDatosOrable;User Id=usuario;Password=claveAcceso;Integrated Security=no;
    
answered by 27.06.2017 в 17:18