Database Problems

[jay2502]

When I try to add a database to my project I get a msg saying no user instence how do I fix This

 

[cjelec]

What database are you adding? (sql,access...)

 

[jay2502]

It is a sql Database.

 

[cjelec]

Can you write the code to connect to the database manually?

For example:

Imports System.Data.SqlClient

'Normal form code

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim con As New SqlConnection([i]ConnectionString[/i])

    con.Open
    con.Close
  End Sub

If you need help writing the ConnectionString, then have a look at

http://www.connectionstrings.com/

You may need to add ";User Instance=true" (or false) to the end of the connection string, which could be your problem with the wizard for connecting to the database not adding this to the connection string.