>Hi all,
>I created an ADO Connection object and tried to open the connection by setting the ConnectionString property, Access Denied error occurred. Then I created a new ODBC DSN and tried to open the connection again by setting the ConnectionString property, everything worked out fine. My question is, does ODBC DSN required to make a ADO connection? TIA.
>
>Wan

You probably just got the connection string wrong. try copying the connection string defined by the DSN into your connectionString property directly.