ADO & SQLServer Provider December 8, 1999 Question: When opening an ADO connection, how do I specify that it use the SQL Server OLEDB provider with a DSN? Answer: Here’s the connection string you should use. Be