I use Crystal Reports with SQL Server 2005. Which driver (ODBC or OLEDB) should be used when connecting Crystal Reports to SQL Server 2005. Business Object support forum has an article (which is old) says to use ODBC. That it is faster than OLEDB. They have a more recent article which state to also use ODBC when upgrading Crystal Reports 8.5 to XI and connecting to SQL Server.
But then I read the OLEDB is the new interface and should be used instead of ODBC which is going away.
Which is preferred for Crystal Reports XI?
ODBC is not going away.
In general, there is no preferred interface - though 3rd party suppliers may have their own good reasons for making recommendations for users of their applications. Both APIs have their strong points. ODBC is the most widely used, but there are places where OLE DB can be a better choice. The choice depends on the needs of the application
No comments:
Post a Comment