advantages of DSN less connections?

[sriky]

I'm using data source names to access the database from vb. I understand that clients also need to have the same DSN's to access the database. Now how can I use DSN less connections? what else are the advantages of using DNSless connection?

Thanks

[ufo]

It's new fashion and MS prefer to use native OLEDB connection instead DSN. DSN is ODBC style. With connection string without DSN you need to know some information such as server name, database, user and so on but if you have it you will be able to connect and you don't need to have DSN setting on client computer. When you are using DSN you need to call bridge(OLEDB provider for ODBC) and then ODBC provider call your particular data driver.

[ufo]