none
Exception Details: System.ArgumentException: Keyword not supported: 'unicode'.

    Question

  • VB: Oracle

    Exception Details: System.ArgumentException: Keyword not supported: 'unicode'.

    Source Error: 

    Line 12:     Inherits DBConnection
    Line 13:     Public Sub ses_test_insert(ByVal p_userid As Integer, ByVal p_username As String, ByVal p_createdby As String, ByVal p_date As String)
    Line 14:         SqlHelper.ExecuteNonQuery(mcpConnectionString, "insertDBUSER", p_userid, p_username, p_createdby, p_date)
    Line 15:     End Sub
    Line 16: End Class

    my web config is:

    <add name="con1" connectionString="Data Source=xe;User ID=system;Password=sesu;Unicode=True" providerName="System.Data.OracleClient" />

    DBConnection:

     Implements IDisposable
        Public Shared ReadOnly mcpConnectionString As String = System.Configuration.ConfigurationManager.ConnectionStrings("con1").ConnectionString
        Private _McpConnection As OracleConnection

    After removing unicode it says:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    • Edited by Sesuraj Wednesday, February 12, 2014 6:30 PM
    Wednesday, February 12, 2014 6:11 PM

Answers

All replies