ADO.NET OLEDB Parameter is Missing ?

N S S

I Get the following Error
================ Error ===============================
Procedure 'GetCetgoriesOrProducts' expects parameter '@CategoryID', which
was not supplied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Procedure
'GetCetgoriesOrProducts' expects parameter '@CategoryID', which was not
supplied.

Source Error:
Line 52: MyCmd.Parameters.Add(Par_ResultType)
Line 53:
Line 54: Dim Dr As System.Data.OleDb.OleDbDataReader =
MyCmd.ExecuteReader
Line 55:
Line 56: If Dr.HasRows Then
================================================== ==

================== code ==============================
Dim Cn As New System.Data.OleDb.OleDbConnection
Cn.ConnectionString = " Provider=SQLOLEDB;server=172.17.20.2;Initial
Catalog=Sfbulbs;uid=sa;pwd=homer27;"
'ConfigurationSettings.AppSettings("ErrorLogConnSt ring")
Cn.Open()

Dim MyCmd As New System.Data.OleDb.OleDbCommand
MyCmd.Connection = Cn
MyCmd.CommandText = "GetCetgoriesOrProducts"
MyCmd.CommandType = CommandType.StoredProcedure

Dim Par_CategoryID As New System.Data.OleDb.OleDbParameter
Par_CategoryID.ParameterName = "@CategoryID"
Par_CategoryID.DbType = DbType.Int32
Par_CategoryID.Value = Request("CategoryID")
Par_CategoryID.Direction = ParameterDirection.Input

Dim Par_ResultType As New System.Data.OleDb.OleDbParameter
Par_ResultType.DbType = DbType.String
Par_ResultType.ParameterName = "@SearchResultType"
Par_ResultType.Direction = ParameterDirection.Output
Par_ResultType.Size = 50

'Dim sampParm As New System.Data.OleDb.OleDbParameter
'sampParm.ParameterName = "RETURN_VALUE"
'sampParm.OleDbType = OleDb.OleDbType.BigInt
'sampParm.Direction = ParameterDirection.ReturnValue

'MyCmd.Parameters.Add(sampParm)
MyCmd.Parameters.Add(Par_CategoryID)
MyCmd.Parameters.Add(Par_ResultType)

Dim Dr As System.Data.OleDb.OleDbDataReader = MyCmd.ExecuteReader

If Dr.HasRows Then
Do While Dr.Read
Response.Write(Dr(0) & "---" & Dr(1))
Loop
Dr.Close()
End If

================================================== ==

Nov 22 '05 #1

Subscribe Post Reply

5265

N S S

I found the Problem
the error was due to Null being passed to the Value of Paramter "@CetgoryID"
I would suggest other facing such problems to check for the Null Values to
the parameters
================================================== ===

"N S S" wrote:

I Get the following Error
================ Error ===============================
Procedure 'GetCetgoriesOrProducts' expects parameter '@CategoryID', which
was not supplied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Procedure
'GetCetgoriesOrProducts' expects parameter '@CategoryID', which was not
supplied.

Source Error:
Line 52: MyCmd.Parameters.Add(Par_ResultType)
Line 53:
Line 54: Dim Dr As System.Data.OleDb.OleDbDataReader =
MyCmd.ExecuteReader
Line 55:
Line 56: If Dr.HasRows Then
================================================== ==

================== code ==============================
Dim Cn As New System.Data.OleDb.OleDbConnection
Cn.ConnectionString = " Provider=SQLOLEDB;server=172.17.20.2;Initial
Catalog=Sfbulbs;uid=sa;pwd=homer27;"
'ConfigurationSettings.AppSettings("ErrorLogConnSt ring")
Cn.Open()

Dim MyCmd As New System.Data.OleDb.OleDbCommand
MyCmd.Connection = Cn
MyCmd.CommandText = "GetCetgoriesOrProducts"
MyCmd.CommandType = CommandType.StoredProcedure

Dim Par_CategoryID As New System.Data.OleDb.OleDbParameter
Par_CategoryID.ParameterName = "@CategoryID"
Par_CategoryID.DbType = DbType.Int32
Par_CategoryID.Value = Request("CategoryID")
Par_CategoryID.Direction = ParameterDirection.Input

Dim Par_ResultType As New System.Data.OleDb.OleDbParameter
Par_ResultType.DbType = DbType.String
Par_ResultType.ParameterName = "@SearchResultType"
Par_ResultType.Direction = ParameterDirection.Output
Par_ResultType.Size = 50

'Dim sampParm As New System.Data.OleDb.OleDbParameter
'sampParm.ParameterName = "RETURN_VALUE"
'sampParm.OleDbType = OleDb.OleDbType.BigInt
'sampParm.Direction = ParameterDirection.ReturnValue

'MyCmd.Parameters.Add(sampParm)
MyCmd.Parameters.Add(Par_CategoryID)
MyCmd.Parameters.Add(Par_ResultType)

Dim Dr As System.Data.OleDb.OleDbDataReader = MyCmd.ExecuteReader

If Dr.HasRows Then
Do While Dr.Read
Response.Write(Dr(0) & "---" & Dr(1))
Loop
Dr.Close()
End If

================================================== ==

Nov 22 '05 #2

N S S

I Get the following Error
================ Error ===============================
Procedure 'GetCetgoriesOrProducts' expects parameter '@CategoryID', which
was not supplied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Procedure
'GetCetgoriesOrProducts' expects parameter '@CategoryID', which was not
supplied.

Source Error:
Line 52: MyCmd.Parameters.Add(Par_ResultType)
Line 53:
Line 54: Dim Dr As System.Data.OleDb.OleDbDataReader =
MyCmd.ExecuteReader
Line 55:
Line 56: If Dr.HasRows Then
================================================== ==

================== code ==============================
Dim Cn As New System.Data.OleDb.OleDbConnection
Cn.ConnectionString = " Provider=SQLOLEDB;server=172.17.20.2;Initial
Catalog=Sfbulbs;uid=sa;pwd=homer27;"
'ConfigurationSettings.AppSettings("ErrorLogConnSt ring")
Cn.Open()

Dim MyCmd As New System.Data.OleDb.OleDbCommand
MyCmd.Connection = Cn
MyCmd.CommandText = "GetCetgoriesOrProducts"
MyCmd.CommandType = CommandType.StoredProcedure

Dim Par_CategoryID As New System.Data.OleDb.OleDbParameter
Par_CategoryID.ParameterName = "@CategoryID"
Par_CategoryID.DbType = DbType.Int32
Par_CategoryID.Value = Request("CategoryID")
Par_CategoryID.Direction = ParameterDirection.Input

Dim Par_ResultType As New System.Data.OleDb.OleDbParameter
Par_ResultType.DbType = DbType.String
Par_ResultType.ParameterName = "@SearchResultType"
Par_ResultType.Direction = ParameterDirection.Output
Par_ResultType.Size = 50

'Dim sampParm As New System.Data.OleDb.OleDbParameter
'sampParm.ParameterName = "RETURN_VALUE"
'sampParm.OleDbType = OleDb.OleDbType.BigInt
'sampParm.Direction = ParameterDirection.ReturnValue

'MyCmd.Parameters.Add(sampParm)
MyCmd.Parameters.Add(Par_CategoryID)
MyCmd.Parameters.Add(Par_ResultType)

Dim Dr As System.Data.OleDb.OleDbDataReader = MyCmd.ExecuteReader

If Dr.HasRows Then
Do While Dr.Read
Response.Write(Dr(0) & "---" & Dr(1))
Loop
Dr.Close()
End If

================================================== ==

Nov 22 '05 #3

Similar topics

OLEDB Connection with Oracle

by: Prabhakar Chola | last post by:

I got this error on production and I rebooted the server and the problem went away. It happens at random. Please help. Environment W2K with Oracle 9.2 client connected to oracle using...

.NET Framework

OleDb Parameters BUG or BAD DESIGN

by: | last post by:

Hi, I was performing SQL UPDATE queries and I notice that they SUCCEED on the ExecuteNonQuery() call with NO exceptions raised BUT they fail at the Database. They say they succeed in the code...

.NET Framework

Using OLEDB in a VB.NET Application

by: John Dougherty | last post by:

I am following some code examples referring to using system.data.oledb - however, I do not have "oledb" available as an item to select. I type system.data., and I can see SQLClient, but not oledb. ...