odbc vs direct connection

What are the pros/cons of using odbc vs direct connection to a database (I am using sql server)

Performance?
Maintenance?
Security?

Thanks in advance.

Rajesh