Prefer Native Provider Over ODBC Providers

You can improve performance of your MDAC application by using native OLEDB providers instead of OLEDB provider for ODBC. MDAC 2.0 contains the native OLEDB providers for three SQL data stores: SQL Server, Access, and Oracle. If you go through the OLE DB Provider for ODBC Data, then it internally uses the appropriate ODBC driver to access the data store. With MDAC 2.0, you can use these native OLE DB providers to access your data faster and with lower disk and memory footprint. Usage of native OLEDB provider improves performance by removing the extra ODBC layer. Native providers connect more quickly to the data stores then the ODBC counterparts. Apart from this you should try to specify details in the connection string instead of just specifying the DSN because specifying DSN results in registry lookups for the connection details.

If you are using native OLEDB provider to connect to a SQL Server then your connection string would like:

 Provider=SQLOLEDB; Data Source=MyDatabaseServer; Initial Catalog=MyDatabase; User Id="sa"; Password="" 

If you are using OLEDB provider for ODBC to connect to a SQL Server then your connection string would like:

 Driver={SQL Server}; Server=MyDatabaseServer; Database=MyDatabase; UID="sa"; PWD="" 

If you are just using the DSN style of connecting string then it would look like:

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS