Basic MySQL Commands
If you´re just getting started with MySQL, here are the basic commands to work with your database.
Coding for Fast Database Connections
If 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 Connections
Every 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.
Temporary volatile Jet DSN for process - Unable to open Registry key
Error codes in ASP can drive you crazy sometimes. How do you fix it if you see the error Temporary volatile Jet DSN for process - Unable to open Registry key ?
Troubleshooting an ASP Database Connection
If 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 Database
When 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 Database
If 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 Access
One 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 Server
If 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.
Top Ten Articles
Content copyright © 2018 by . All rights reserved.
This content was written by . If you wish to use this content in any manner, you need written permission. Contact Lisa Shea for details.