try_it
try_it
Branch Unspecified
05 May 2012

vb.net database connection error

"i'm a new user so please don't delete my post if i posted it in wrong community"
i am using visual studio 2010 professional .while running my project ,splash screen run normally but when i tried to login it gives error as follows

"the database g:\.....feemgt.mdf cannot be opened because it is version 655.this server supports 612 and earlier.a downgrade path is not supported.
could not open g:\.....feemgt.mdf.CREATE DATABASE is aborted.
an attempt to attach an auto named database for file g:\.....feemgt.mdf failed. a database with same name exists, or specified file cannot beopened, or it is located on UNC share"

please helppppp as my practical exam is so near ...
05 May 2012
try_it What is the version of MS SQL Server you are running in your system?
05 May 2012
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

tmonicrow

Branch Unspecified
02 Jun 2012
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
https://vb.net-informations.com/ado.net-dataproviders/ado.net-sqlconnection.htm

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.

Share this content on your social channels -

Only logged in users can reply.