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!