Knowledgebase

Home > Knowledgebase > Databases

Articles

I'm seeing periodic slowdowns in my Microsoft Access driven site

With random website slowdowns the usual culprit is the Microsoft Access database, which was never intended for use on the web.  It works perfectly fine on small sites and has the advantage of being easy to set up and work with, but it...

What SQL database connection string do you recommend?

For Microsoft SQL Server there's a few choices, for Ecommerce Template ASP based sites we'd recommend the following which is the latest from Microsoft: <%DIM sDSNsDSN =...

What should my Microsoft Access database connection string look like?

If your application uses a Microsoft Access database you'll need to use a DSN-less database connection, such as the example that follows for an ecommercetemplates.com store:<%DIM sDSNsDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data...