How to connect to SQL database

[coocoobird]

Ok,
All this sql stuff is driving me nuts. But my question is this.. I use vb2005... I created an mdf sql database in the project. Do i have to connect to it like i would an access db? or does it auto connect when added to the project? If so how do i go about accessing it? Sorry for the noob questions, I come from vb6 and ive always used access db's.. But i need sql for a big project im working on.

 

[cjard]

ensure you have some kind of sql server running on your machine not just installed
add the mdf to your project
edit the structure using the Server Explorer
the databse will be auto attached to the running sql server and conencted to when you pres splay to run your project

Read the DNU link in my signature for avoidance of a common trap