How to connect using dsn, ado.net and odbc?

[iamtat]

I used the ODBC in the Administrative Tools of the Control Panel to set the data surce and path. Do I need to type the data source again within the code?

I named the path that I set up as "database", so, now what should I type about the code? Should I typed "database" or "database.dsn"??

I want to connect the database by using ADO.net. So, I should use ADODB.ConnectionClass or just ADODB.Connection is okay? Is there any reference coding?

Thanks!!

Totti.