SQL Server Performance Forum – Threads Archive
Connecting to SQL Server thru ODBC File DSNCurrently, I’m using ODBC System DSN to connect to SQL Server 2000/2005.
I’m thinking about using ODBC File DSN instead since it does not write to
registry which is protected by UAC in Vista. I only know that ODBC File DSN
simply means the connection information is stored in a text file. Where can
I find more information about it? Is there any known issues in using ODBC
File DSN to connect to SQL Server?
When making your connection to SQL Server, choose DSN-less connections for the fastest connection. If you do need to use a DSN, select System DSNs over File DSNs, because they are faster when making connections.