ExcuteReader error ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I have exeecuting the following code :

Dim m_Cmd As New OleDb.OleDbCommand(sSql, Con)
Con.Open()
Dim m_OldbReader As OleDb.OleDbDataReader
m_OldbReader = m_Cmd.ExecuteReader(CommandBehavior.CloseConnection)

Running this I have an OLDBException error saying :

"No value given for one or more required parameter"

I have check parameter for my cmd object and Oldb object, cannot see what is
wrong
Any idea?

regards
serge
 
=?Utf-8?B?c2VyZ2UgY2FsZGVyYXJh?=
I have exeecuting the following code :

Dim m_Cmd As New OleDb.OleDbCommand(sSql, Con)
Con.Open()
Dim m_OldbReader As OleDb.OleDbDataReader
m_OldbReader = m_Cmd.ExecuteReader(CommandBehavior.CloseConnection)

Running this I have an OLDBException error saying :

"No value given for one or more required parameter"

I have check parameter for my cmd object and Oldb object, cannot see
what is wrong
Click to expand...

What does sSQL look like?
 
I found it out, I smal mistype in SQL querry string
thanks anyway

Miha Markic said:
Are you providing parameters at all? :-)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

William (Bill) Vaughn said:
Where are you providing the parameters?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Click to expand...
Click to expand...
 
Back
Top