From connecting to a database to troubleshooting issues, here is assistance in making sure your ASP works properly.

Basic MySQL CommandsIf you´re just getting started with MySQL, here are the basic commands to work with your database.

Coding for Fast Database ConnectionsIf you´re a database developer, one of your most important tasks is to write your code properly, so pages load as quickly as possible. If your pages load slowly, your visitors are likely to go elsewhere!

MDAC and Database ConnectionsEvery time you make a connection to your database, you are burning 7mb of memory. Learn to manage this well, to keep your system running smoothly.

Troubleshooting an ASP Database ConnectionIf you´re writing ASP code, it´s common to get stuck with issues when you are trying to do a database select, insert or update based on a form. Here is how to troubleshoot the issue.

Using ASP with a Dedicated DatabaseWhen you truly begin to base your website on database content, it´s time to get yourself a dedicated MS-SQL or MySQL database system. This helps guarantee you proper response time and performance.

Using ASP with a Shared DatabaseIf you´re ramping up your website´s database usage, you often go with a hosting plan that lets you have shared access to a MySQL or MS-SQL database.

Using ASP with Microsoft AccessOne of the most basic ways to use ASP with a database is to connect to a Microsoft Access database file. This requires little technical knowledge but has limited scope.

Using Microsoft Access with SQL ServerIf you´re designing ASP pages to work with a SQL database, you need some way to create and maintain the tables of data. Microsoft Access lets you do that easily.