vb.net database connection error

Replies

• 

  PraveenKumar Purushothaman

  #-Link-Snipped-# What is the version of MS SQL Server you are running in your system?
• 

  PraveenKumar Purushothaman

  WARNING!!! Be sure to back up your ASPNETDB.MDF data before doing this.
  
  I had the same problem and solved it by deleting the ASPNETDB.MDF and aspnetdb_log.ldf files from the App_Data folder. They get recreated the next time you run your application.
  
  I was doing this on a proof of concept website and did not have any valuable information saved in the ASPNETDB.MDF database.
• 

  tmonicrow

  Dim connetionString As String
  Dim cnn As SqlConnection
  connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
  cnn = New SqlConnection(connetionString)
  Try
  cnn.Open()
  MsgBox("Connection Open ! ")
  cnn.Close()
  Catch ex As Exception
  MsgBox("Can not open connection ! " & ex)
  End Try
  #-Link-Snipped-#
  
  try the above code first, then you can anlyse if it is connected or not . If it is not connected then exception will throw. You can learn from exception what happend.
  
  crow.