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
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |