ASP Accessing SQL

i m writing some ASP to access a SQL database and it doesn't seem to be connecting right, i was wondering if someone could see if I have gone wrong anywhere in the connection code below and explain what i put in the DSN?

Dim VARIABLE
Dim CN
Dim RecordSet
Set CN=Server.CreateObject("ADODB.Connection")
CN.Open "Provider=SQLOLEDB; DSN=whats this?; uid=; password=; Initial Catalog=Table"
Set RecordSet = CN.Execute("SELECT * FROM Table where something ='"&VARIABLE&"'")
%>
<%Connection.Close %>