Hi, All
We have ODBC drivers defined for SQL Server 2012 database and driver select as ‘Sql Server’. There are other drivers like Sql server native client 11.0 and other drivers are present.
Will there be any performance improvement if we change drivers from ‘SQL Server’ to ‘SQL server native client 11.0’ for reports(Crystal reports 2013,Crystal reports for Enterprise).
Thank you for the help!
MIUSA (BOB member since 2011-05-01)
The only thing I have heard over the years is that OLE drivers are more efficient than ODBC drivers. That being said. For the most part our organization has used ODBC drivers (‘SQL server native client 11.0’ for MS-SQL databases). A lot of our reports use fairly small databases, so we do not see any performance hit. I am not sure where to find out about the performance of a particular driver.
kevlray 
(BOB member since 2010-06-23)
The “SQL Server” driver is an older version of the SQL Server drivers. I think it corresponds to SQL Server 2005. If you are using SQL Server 2012 for your databases, SQL Native Client 11.0 is the equivalent driver version. I always try to use the driver files that match the version of the database is it being used to connect to. In your case, having SQL Server 2012 databases, I would use the SQL Native Client 11.0 drivers.
Thank you for your inputs. I changed the drivers to Sql server native client.
Don’t see performance improvement when running CRE reports with subreports against universe (Processing nearly 200k records in each of the query) after changing drivers and taking 10+mins to populate all data.
when same report(with subreports) run in Crystal reports 2013, getting all data in less than couple of mins.
MIUSA (BOB member since 2011-05-01)