Hi,

I am starting to get the following error when I try to insert or update into an Oracle 8i database after I upgraded to production version of ASP.Net 2.0! Something with the character set but I am not sure. Same application server works fine with Oracle 10G. How do you force a character set when sending queries to database servers in ASP.Net ?

[OracleException (0x80131938): ORA-12704: character set mismatch
]
   System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) +204
   System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) +1024
   System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor) +447
   System.Data.OracleClient.OracleCommand.ExecuteNonQuery() +108
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +401
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +721
   System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78
   System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1215
   System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +858
   System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +199
   System.Web.UI.WebControls.GridView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Hi,

I have the same problem, though this occurs when adding the WHERE clause to the SqlDataSource.  I've tried various combinatations  with and without quotes, single vs. double quotes, etc.  If I remove the where clause and the SelectParameter, the query returns all rows.  

Thanks,

Don

<asp:SqlDataSource ID="SqlDataSourceUsers" runat="server" ConnectionString="<%$ ConnectionStrings:X %>"
ProviderName="<%$ ConnectionStrings:X.ProviderName %>"
SelectCommand='SELECT "USER_ID", "USER_NAME","LOGIN" FROM "USERS" WHERE ("LOGIN" = :LOGIN)'
CancelSelectOnNullParameter="False" >
<SelectParameters>
<asp:ControlParameter ControlID="TextBoxSearch" Name="LOGIN" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

Hi,

After spending about five hours on microsoft we discovered that you should change the parameter type to "Empty". Some how it does not like the type "String" with Oracle 8i and certain version of Oracle 9i. I hope this helps.

Mo

 Mo,

This suggestion works great!  Thank you very much.

Don

Hi ,

I experienced that error and worked around by choosing the varchar2 type instead of nvarchar2 for the columns queried.

Have a nice weekend,

Dobby

Yeah, your "Empty" suggestion totally helped me too. 

I'm using a full recent copy of VS2005 and I'm getting the same issues when I try to use a Sql DataSource with an Oracle 8i database.

It worked like a magic for me too..  Thanks for the graet help.

But i think changing to "Empty" is illogical as my field is actually text. Hope Microsoft will look into it.

Sreejith C