Connecting to SQL Server thru ODBC System DSN vs ODBC File DSN

Connecting to SQL Server thru ODBC System DSN vs ODBC File DSN

Post by UGV0ZX » Thu, 01 Mar 2007 02:25:27


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?