Please help with connection string

[jasonwucinski]

Hi everyone. im trying to connect to an .sdf database but when i try to connect i get an error. this is the code i have on the onclick event:

        Dim someName As String = Me.TextBox1.Text

Using connection As New SqlConnection("Data Source=D:\Visual Studio\Projects\Work_Link_New_Applicant\Work_Link_New_Applicant\MyDatabase#1.sdf")

            Using command As New SqlCommand("INSERT INTO tblWorkLink_ID(WorkLinkID) VALUES (@Name)", connection)

                command.Parameters.AddWithValue("@Name", someName)
                connection.Open()
                command.ExecuteNonQuery()

            End Using

        End Using

and i get this error:

5 A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)


Whats going on? how do i connect to the db?
thanks
jason

 

[jmcilhinney]

The SqlClient ADO.NET provider is only for SQL Server. SQL Server CE has its own ADO.NET provider: SqlServerCe.

 

[jasonwucinski]

ok, i set a reference to the SqlServerCE assembly. Please see my next post for a follow up question