DeveloperBarn

richyrich · #1 November 25th, 2008, 10:28 AM

I have just uploaded a new page to my app, but when I try and navigate to it, I get a "Cannot find server" error.

All the other pages in the app seem to be working fine.

I presume that there is a problem in my code, but it's not throwing an exception.

Any ideas what might be causing this error to occur?

richyrich · #2 November 25th, 2008, 11:45 AM

OK. I think I have located the source of the problem.

Have a problem with a couple of functions in my DAL. Just need to isolate what the problem is now.

richyrich · #3 November 25th, 2008, 12:48 PM

OK, I just cannot see what the problem is with this code. If I run it, it causes a "Cannot find server" error. It's absolutely doing my head in.

.aspx.vb

asp Code:

Sub build_marital_status()
     ddl_marital1.DataSource = SiteBLL.GetMaritalStatusList()
     ddl_marital1.DataValueField = "ref"
     ddl_marital1.DataTextField = "type"
     ddl_marital1.DataBind()
End Sub

BOL

asp Code:

Public Class MaritalList
     Inherits List(Of MaritalType)
     Public Sub New()
     End Sub
 
     Private _page_error As String = String.Empty
     Public Property page_error() As String
        Get
           Return _page_error
        End Get
        Set(ByVal value As String)
           _page_error = value
        End Set
      End Property
End Class
 
Public Class MaritalType
      Public Sub New(ByVal p_ref As String, ByVal p_type As String)
           ref = p_ref
           type = p_type
      End Sub
 
      Private _ref As String = String.Empty
      Public Property ref() As String
          Get
              Return _ref
          End Get
          Set(ByVal value As String)
              _ref = value
          End Set
      End Property
 
      Private _type As String = String.Empty
      Public Property type() As String
          Get
             Return _type
          End Get
          Set(ByVal value As String)
            _type = value
          End Set
      End Property
End Class

BLL Code

asp Code:

Public Shared Function GetMaritalStatusList() As MaritalList
 
       Return GetMaritalStatusList()
 
End Function

DAL Code

asp Code:

Public Shared Function GetMaritalStatusList() As MaritalList
Dim MaritalList As New MaritalList
Dim conn As New MySqlConnection(ConnDAL.connString)
Dim mycommand As New MySqlCommand("SELECT statusref,marital_status FROM marital_status", conn)
Dim rsgr As MySqlDataReader
   Using conn
      Using mycommand
          Try
             conn.Open()
             rsgr = mycommand.ExecuteReader
               If rsgr.HasRows Then
                   Do While rsgr.Read
                      MaritalList.Add(New MaritalType(rsgr("statusref"), rsgr("marital_status")))
                   Loop
               End If
               rsgr.Close()
          Catch ex As Exception
               MaritalList.page_error = ex.ToString
          Finally
               mycommand.Dispose()
               conn.Close()
               conn.Dispose()
          End Try
       End Using
  End Using
 
  Return MaritalList
 
End Function

I have run the query directly in the db and it works fine. I use exactly the same code on another ddl that I populate from the db and that works fine.

I just cannot see why this causes this error.

Any ideas?

jmurrayhead · #4 November 25th, 2008, 12:52 PM

Your posted code is hard to read..so it's hard to tell...however, I'm sure the real error is being hidden. If using IE, do you have script debugging enabled in the Internet Options? If not, you won't see the real error message. It could be a server 500 error. Make sure everything is all right with your database connection and such.

richyrich · #5 November 25th, 2008, 01:00 PM

Quote:

Originally Posted by jmurrayhead

Your posted code is hard to read..so it's hard to tell...however, I'm sure the real error is being hidden. If using IE, do you have script debugging enabled in the Internet Options? If not, you won't see the real error message. It could be a server 500 error. Make sure everything is all right with your database connection and such.

Sorry, when I cut and post it loses all the formatting...Have reformatted it now...

I'm not sure about the script debugging...What I'd normally do when I get problems is debug by catching the errors and then writing them to the screen.

However, I've not come across this issue before where it gives a Cannot find server error, so I can't even get to try and catch any error.

richyrich · #6 November 25th, 2008, 01:04 PM

OK. I unticked Disable Script Debugging (Internet Explorer) and (Other) and just get a blank screen when I try and load the page.

If there is an error, I don't understand why it isn't throwing an exception...

richyrich · #7 November 25th, 2008, 01:28 PM

OK. Found the problem
This

asp Code:

Public Shared Function GetMaritalStatusList() As MaritalList
Return GetMaritalStatusList()
End Function

Should have been

asp Code:

Public Shared Function GetMaritalStatusList() As MaritalList
Return SiteDAL.GetMaritalStatusList()
End Function

I knew it must have been something easy.

Thank the lord for that....

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disabling a field after the Find command	kl99ny	Microsoft Access	11	October 7th, 2008 06:35 PM
Server Side Includes .stm file error	peebman2000	HTML & CSS Help	6	August 4th, 2008 10:29 AM
Error Type:Active Server Pages, ASP 0113 (0x80004005)	guddu	ASP Development	20	July 11th, 2008 09:44 AM
find words and change	todd2006	JavaScript Programming	4	July 2nd, 2008 09:58 AM

DeveloperBarn

Cannot find server error

[Error] Cannot find server error

Similar Threads