Answered by:
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 OracleConnectionAfter 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
-
Can you try Oracle Data Provider for .NET?
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html
Satheesh
My Blog | How to ask questions in technical forum
- Proposed as answer by Fanny Liu Wednesday, February 19, 2014 12:20 PM
- Marked as answer by Kalman Toth Sunday, February 23, 2014 10:37 PM
Thursday, February 13, 2014 5:49 AM -
I think you need to use Oracle classes to access Oracle data. SqlHelper sounds like it's designed for SQL Server only, although I am not familiar with the class.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles- Marked as answer by Kalman Toth Sunday, February 23, 2014 10:37 PM
Thursday, February 13, 2014 4:55 PM
All replies
-
The error is very strange. It seems like you're trying to establish connection to the Oracle, so why you're getting an error from the SQL Server? What does the procedure insertDBUser do?
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articlesWednesday, February 12, 2014 8:20 PM -
@Naomi N... I am using SqlHelper class here. I think that's y it shows this error. May i use SqlHelper if oracle as a database.?
- Edited by Sesuraj Thursday, February 13, 2014 5:27 AM
- Proposed as answer by Satheesh Variath Thursday, February 13, 2014 5:43 AM
- Unproposed as answer by Satheesh Variath Thursday, February 13, 2014 5:43 AM
Thursday, February 13, 2014 5:26 AM -
Can you try Oracle Data Provider for .NET?
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html
Satheesh
My Blog | How to ask questions in technical forum
- Proposed as answer by Fanny Liu Wednesday, February 19, 2014 12:20 PM
- Marked as answer by Kalman Toth Sunday, February 23, 2014 10:37 PM
Thursday, February 13, 2014 5:49 AM -
I think you need to use Oracle classes to access Oracle data. SqlHelper sounds like it's designed for SQL Server only, although I am not familiar with the class.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles- Marked as answer by Kalman Toth Sunday, February 23, 2014 10:37 PM
Thursday, February 13, 2014 4:55 PM