What are you doing with exceptions in your code? It’s likely that you’re capturing and throwing away an exception that occurred. Is there any place that you have a catch(){} block without any code  to rethrow the exception or draw the exception on the screen?

I have Try Catch, and on Catch I have error to be displayed on the label. Like this

Try

cn.Open()

strSql = "select Price from security where ticker  ='" & txtTicker.text.tostring.trim & "'"

................................................................

................................................................................

Catch e As Exception

lblMsg.Text = e.Message

Finally

cn.Close()

End Try


Still no exception, and no data returned. It should be something related to permissions, because it works  for people who are admins on Sharepoint server. By the way database server  (DB2) is on another box

… you’ll want to make sure that the label  actually gets added to the output stream. (this.Controls.Add(lblMsg))

You may also want to make sure that the try/catch encompasses everything in the method. How are you rendering? (RenderWebPart or CreateChildControls())

Are you writing a web  part or a user  control?

Thanks again for your response. label  gets rendered because I see warning inside label that i use to notify user  that needs to provide ticker  if they leave box  empty. Also everything works  fine if I run it or somebody who is admin  on the Sharepoint server(someone with elevated rights). I don't understand why I can run it, and another person can't when we are logging to the database  with the same UserID and Password.