Tuesday, March 27, 2012

Data Source Problem in SQL server mobile edition

Hi,

I am using SQLCE and VS 2005 to create a database named "student.sdf" (inside my projects folder, of course). When click on the button, it will test for connection of database.
Everytimes I run the program, it will pop up an error message "The database file cannot be found. Check the path to the database. [File name = .\student.sdf]". How do I fix it?


Code Snippet

Imports System.Data.SqlServerCe

Public Class loginForm

Private _conn As SqlCeConnection


Private Sub ButtonLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonLogin.Click

_conn = New SqlCeConnection("Data Source =.\student.sdf")


Try
_conn.Open()

MessageBox.Show("Correct")

Catch ex As SqlCeException

MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1)
Finally

_conn.Close()

End Try

End Sub

End Class







Did you try changing the current directory in debug settings?

No comments:

Post a Comment