OLE DB Vs DSN | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


There are two ways to connect to database OLE DB Provider and DSN. I know that OLE DB is faster than DSN. But when running the application I cant find any diffences as far as speed is concerned. Can anybody explain on how OLE DB is faster than DSN? Madhivanan
When using DSN, the application has to look up the values int he DSN before it can make the connection. In OLE DB, the information is part of the string that is passed, and no lookup has to occur. There are other benefits as well. But the actual difference is very small. You probably won’t notice it much unless your application opens and closes thousands of connections within short time periods. —————————–
Brad M. McGehee, MVP

Thanks bradmcgehee for your valuable reply Madhivanan