open sql db with dsn

Helllllllo

i've created a user dsn to connect to my sql db!
i've tested the connection and it work!

but i can't use within vb

here's the syntax i use

conn.Open "DSN=landark;UserID=landarkSQL;PWD=myPassword"

is'nt ok!

never mindit's not UserID it's UID

i dunno where i got that from???