Hi,
I have this code

 Dim cnn As New SqlClient.SqlConnection(strConnection)
            cnn.Open()
            Dim Cmd As New SqlCommand()
            Cmd.Connection = cnn
            With Cmd
                .Connection = cnn
                .CommandType = CommandType.StoredProcedure
                .CommandText = "K1SP_Stats"
            End With

            With Cmd.Parameters

                Dim strURL As Uri = Request.Url

                Cmd.Parameters.Add("@pageName", SqlDbType.NVarChar, 100)
                Cmd.Parameters("@pageName").Value = strURL

                Cmd.Parameters.Add("@DateTime", SqlDbType.SmallDateTime)
                Cmd.Parameters("@DateTime").Value = Today.Date()


                Cmd.Parameters.Add("@UserHost", SqlDbType.VarChar, 100)
                Cmd.Parameters("@UserHost").Value = Request.UserHostAddress

                Cmd.Parameters.Add("@UserAgent", SqlDbType.VarChar, 100)
                Cmd.Parameters("@UserAgent").Value = Request.UserAgent

                Cmd.Parameters.Add("@Referrer", SqlDbType.NText)
                Cmd.Parameters("@Referrer").Value = Request.UrlReferrer

            End With

            Cmd.ExecuteNonQuery()

            cnn.Close()

i get this error when request.url or request.referrer is null

Object must implement IConvertible


my stored proc:

CREATE PROCEDURE K1SP_Stats
  @pageName nvarchar(100) = NULL,
  @DateTime smallDateTime = NULL,
  @UserHost varchar(100)= Null,
  @UserAgent varchar(100)= Null,
  @referrer ntext
AS
  Insert into k1_pageViews (PageName,Date_Time,UserHost,UserAgent,Referrer) values ( @pageName,@DateTime,@UserHost,@UserAgent,@Referrer )

GO

I really can't understand your problem.. but i suggest that u convert your null values to empty strings.. just to make sure.

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

Not really a solution to your particular problem but...

It looks like you are logging request information. You can configure IIS to log to a SQL server database. All this information (plus a whole lot more) would be automatically collected for you.

-Peter