Ado

[qassim]

I want to know about dsn and provider
if i make dsn i need to write
service provider in code or not
and i use data source then i need to
write service provider and why we
use dsn

[Clunietp]

People use DSNs so they can change the database properties after the app has already been compiled (like the database name, extra properties and possibly user/password).

DSNs are useful when you don't know the name of the production server that will be used while you are developing your app.