i have been banging my head against this on and off for days. Time for help from people who know what they are doing!

i have a default installation of SQL Server Express 2008 running with VB6 Pro installed. I am running Windows XP.

I have managed to create 2 tables(Psswrd and GameTable) and can see these through the SQL server management studio.

So far so good!

however, when i run the code i am getting an "Invalid connection string attribute"! through the conConnection.open command.

Here is my connection string.

conConnection.ConnectionString = "Provider=SQLNCLI10;Data Source=CHAD-H8H5UNYBQS\SQLEXPRESS;Initial Catalog=Psswrd;UserId=CHAD-H8H5UNYBQS\Chad;Password="

I am using Windows Authentication to log into the db for the SQL management studio. Do i need a password setup? If so, where do I go for this?

I suspect my issues are legion, but are fairly simple to solve. I am just having issues finding information so I came here to ask!!

I have a feeling the answer is pretty obvious and I am the numbskull!