SQL login error

[IneedaSmoke]

Hey again, I'm getting login errors running this code :

strConn = "Data Source=.\SQLExpress;Initial Catalog=_UFE_DataSet;Integrated Security=True;"

Dim cn As New SqlConnection(strConn)

cn.Open()


I've written other programs with the exact same syntax that work. I'm using SQL express on my local machine. Oddly enough I can preview data in the tables in this database. The error is :

"Cannot open database"_UFE)DataSet" requeste by teh login. The login failed. Login failed for user 'domain\Ineedasmoke'.

Any ideas? This sql stuff seems pretty tricky.

 

[JuggaloBrotha]

I deleted the other two threads, please don't double post

 

[IneedaSmoke]

Oh sorry, I wasn't sure where it was supposed to be. The first thread had a sticky to ado and I wasn't sure if it was supposed to be there. Then I found this section and thought it was more accurate. All this stuff is so inceptuous I get confused.


Anywho, I pointed the connection to a dataset instead of a database. I corrected that and it works!