I am trying to change oracle client in my vb.net application from System.Data.OracleClient to System.Data.Oledb & getting Invalid Cast Exception (Conversion from string to type Double is not valid), it used to work fine when provider was System.Data.Oracleclient instead of System.Data.Oledb
Application is using SQLDatasource to connect to DB & it is failing during update operation. Value for parameter is coming from dropdown & we are storing ID instead of actual text from the dropdown. Debugged the code by adding updated event & looked at parameter values & it does have decimal value. Is there a different way to handle decimals in System.Data.OleDB provider??
Parameter in question is defined as in my code <asp:Parameter Name="ROLE_ID" Type="Decimal" />
P.S: All sql code is written in aspx page