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