Lost the plot on connection string

[pachjo]

Hi, I am trying to learn how to create database applications in VS.NET 2005 using VB.NET

I used the project options to create an SQL database and have created the following code:

[SIZE=2][COLOR=#0000ff]Public[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Class[/COLOR][/SIZE][SIZE=2] frmMain[/SIZE]
[SIZE=2][COLOR=#0000ff]Private[/COLOR][/SIZE][SIZE=2] m_cnADONetConnection [/SIZE][SIZE=2][COLOR=#0000ff]As [/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][SIZE=2] SqlClient.SqlConnection[/SIZE]
[SIZE=2][COLOR=#0000ff]Private[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE][SIZE=2] frmMain_Load([/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] sender [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.Object, [/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] e [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.EventArgs) [/SIZE][SIZE=2][COLOR=#0000ff]Handles [/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]MyBase[/COLOR][/SIZE][SIZE=2].Load[/SIZE]
[SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] strDatabasePath [/SIZE][SIZE=2][COLOR=#0000ff]As [/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]String[/COLOR][/SIZE][SIZE=2] = [/SIZE][SIZE=2][COLOR=#800000]"C:\Documents and Settings\pachjo\My Documents\Visual Studio 2005\Projects\DataBase Example\DataBase Example\Database1.mdf"[/COLOR][/SIZE]
[SIZE=2]m_cnADONetConnection.ConnectionString = [/SIZE][SIZE=2][COLOR=#800000]"Data Source=(local);Initial Catalog="[/COLOR][/SIZE][SIZE=2] & strDatabasePath & [/SIZE][SIZE=2][COLOR=#800000]";Integrated Security=SSPI"[/COLOR][/SIZE]
[SIZE=2][COLOR=#0000ff]Try[/COLOR][/SIZE]
[SIZE=2]m_cnADONetConnection.Open()[/SIZE]
[SIZE=2]MessageBox.Show([/SIZE][SIZE=2][COLOR=#800000]"Connection is open"[/COLOR][/SIZE][SIZE=2])[/SIZE]
[SIZE=2][COLOR=#0000ff]Catch[/COLOR][/SIZE][SIZE=2] ex [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] Exception[/SIZE]
[SIZE=2]MessageBox.Show(ex.Message)[/SIZE]
[SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Try[/COLOR][/SIZE]
[SIZE=2]m_cnADONetConnection.Close()[/SIZE]
[SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE]
[SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Class[/COLOR][/SIZE]

When I run my app I get an error saying it failed to open connection due to login failed for user 'my works domain name\pachjo'

Could someone point me in the right direction please?

Thanks

 

[lingsn]

For your reference

http://www.connectionstrings.com/

 

[pachjo]

Hi, thanks I had a look at your link which is handy, but I found the string I needed within VB.NET!

By looking at the database properties under server explorer the connection string is supplied as shown below.

It works a treat and am now navigating through my sample table

"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\pachjo\My Documents\Visual Studio 2005\Projects\DataBase Example\DataBase Example\Database1.mdf;Integrated Security=True;User Instance=True"