Best way to connect to SQL Server 2008
-
Currently I am connecting to an Access database via ODBC and a CRecordSet. I know I can create an ODBC entry for SQL Server and continue to use CRecordSet. All I have to do is change the connection string. I have used ADO in the past to connect to SQL Server but I am tempted to continue to use CRecordSet. What is the best way to connect to SQL Server? If I continue to use CRecordSets will I have problems later. Will the connection be slower. Any past experience advice would be apprecated. Thanks
-
Currently I am connecting to an Access database via ODBC and a CRecordSet. I know I can create an ODBC entry for SQL Server and continue to use CRecordSet. All I have to do is change the connection string. I have used ADO in the past to connect to SQL Server but I am tempted to continue to use CRecordSet. What is the best way to connect to SQL Server? If I continue to use CRecordSets will I have problems later. Will the connection be slower. Any past experience advice would be apprecated. Thanks
I would not use ODBC as it is another layer of abstraction on your DAL. I have not used it in a very long time. The question to me is ALO or OLEDB[^] having done some research I decided to stick with OLEDB.
Never underestimate the power of human stupidity RAH
-
Currently I am connecting to an Access database via ODBC and a CRecordSet. I know I can create an ODBC entry for SQL Server and continue to use CRecordSet. All I have to do is change the connection string. I have used ADO in the past to connect to SQL Server but I am tempted to continue to use CRecordSet. What is the best way to connect to SQL Server? If I continue to use CRecordSets will I have problems later. Will the connection be slower. Any past experience advice would be apprecated. Thanks
Ado.NET is Cool for that :) see this http://www.dotnetfunda.com/articles/article103.aspx[^]
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za