Are ODBC DSNs or OLEDB going to slow my site down?

Someone said ODBC DSNs are bad and could slow down my site; how else am I supposed to connect to my Access, SQL server or Excel data content?

We recommend you try getting away from access databases, as it confines you to using older and slower technology that doesn’t handle multiple requests very well. If you can’t possibly use SQL, then here is a solution: 

This is a common and well known issue with Jet/Access databases. Here’s an article on 4 Guys From Rolla that we feel answers this very question and provides references to other articles on the same subject.

Content retrieved from: https://support.appliedi.net/kb/a393/are-odbc-dsns-or-oledb-going-to-slow-my-site-down.aspx.

Updated on November 11, 2019

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT