Connecting to SQL Server thru ODBC File DSN | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Connecting to SQL Server thru ODBC File DSN

Currently, 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?

http://www.sql-server-performance.com/odbc_oledb.asp
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.
MohammedU.
Moderator
SQL-Server-Performance.com
]]>