Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Cannot find either column "dbo" or the user-defined function

Unanswered Cannot find either column "dbo" or the user-defined function

  • Friday, January 18, 2013 8:49 AM
     
     
    Sign In to Vote
    0

    Hi,

    I am writing a code in custom code to access the sql data.

    Function westsubsum() As decimal
     Dim conn As New System.Data.SqlClient.SqlConnection ("Data Source=asharaf;Initial Catalog=test;Integrated Security=true")
             conn.Open()
             Dim Cmd As New System.Data.SqlClient.SqlCommand
             Cmd.Connection = conn
             Cmd.CommandText = "select dbo.calculatesumwithdate(1000000,2000000,'12/31/2008')"
             Dim totval As Decimal = Cmd.ExecuteScalar()
             conn.Close()
      return totval
     end function

    i calles in expression as =code.westsubsum

    i m getting #error in my expression

    when i run this in reporting server

    i am getting this error

    Cannot find either column "dbo" or the user-defined function

         
     

All Replies