Community discussion forum

how to solve this error?

• • Reply

  1 year ago

  by sathyan_8294

  sathyan_8294

  , India

  Joined 2 years ago

  i am using .net 2005.i am doing my project in vb.net 2005.In my project,in crystal report,if i set parameter is number means succesfully execute,but if i set parameter is character means the following error is display.
  if i give value as bri means,the following error will shown
  failed to open a rowset.
  Details:ADO Error code:0x
  source:microsoft OLE DB provider for SQL Server
  Desription:Invalid Column Name 'bri'.
  SQL State:42S22
  Native Error:
  failed to open a rowset.
  Error in fileC:\DOCUME~1\WELCOME\LOCALS~1\Temp\temp_be37e2d6-f284-4eaf-8f96-30f6261f3023{58B7B619-8e98-4EAB-941F-B85471A5CEA8}.rpt:
  failed to open a rowset.
  
  if i give value as cbe means,the following error will shown
  
  failed to open a rowset.
  Details:ADO Error code:0x
  source:microsoft OLE DB provider for SQL Server
  Desription:Invalid Column Name 'cbe'.
  SQL State:42S22
  Native Error:
  failed to open a rowset.
  Error in fileC:\DOCUME~1\WELCOME\LOCALS~1\Temp\temp_be37e2d6-f284-4eaf-8f96-30f6261f3023{58B7B619-8e98-4EAB-941F-B85471A5CEA8}.rpt:
  failed to open a rowset.
  
  if i give number instead of characters means,successfully execute.so how to set parameter as characters and how solve this problem?
  

  Report abuse
• • Reply

  1 year ago

  by BCullenward

  BCullenward

  , United States

  Joined 4 years ago

  You really haven't given a lot of information to go on.  What data type is the parameter?  How is the parameter used in the stored procedure?  If you read the error message it says that there is no column named 'bri' and there is no column name 'cbe'.

   What happens if you use a number greater than the number of fields in the rowset?

   

  Are you able to run the stored procedure in the database environment (SQL Server, Oracle, etc.) and pass in the same parameter value and get the data you want?
   

  Report abuse