Database For Asp
This tutorial, by Faisal Khan, assumes no prior experience with MySQL, though basic knowledge of SQL syntax will be useful. It is assumed that you have a working ASP.NET/IIS installation on your system and you know how to create and view an ASP.NET page. For some beginner ASP.NET articles, have a look at our ASP.NET section.
Accessing MySQL Database
Popular Internet Links directory focused mainly on Computers and Programming but also covers humor, entertainment, news, Medical, Real Estate and Property, Travel, Timeshare and Cruises, Fitness and Bodybuilding, Music and Graphics. Links are updated daily.
SoMuch.com
Beginners ASP.NET Overview
In this step by step tutorial we will learn how to obtain, install, configure and run MySQL database on Windows. We will then move on to create a table in MySQL database, populate this table with some records and then display those records in the browser using an ASP.NET page.
In this article we're going to take a look at using the MyODBC driver to talk to a MySQL database in ASP. We will look at two different ways to connect to a MySQL database using the MyODBC driver: via a DSN, and via a connection string. We will use some standard SQL (ANSI) queries to work with tables by adding, updating and deleting records for an address book database. Lastly, MySQL comes with some very handy SQL commands that allow us to view information about databases and tables; we'll take a look at those too.
Devarticles Index:
Using MyODBC To Access Your MySQL Database Via ASPInstalling MyODBC
Setting up a system DSN
Using a connection string
Querying our MySQL database
Conclusion
MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. In this article Annette takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script .Active Server Pages are a Microsoft technology that allows developers proficient with either Visual Basic or VBScript to easily adapt their skills and knowledge to the web with very little effort at all. ASP uses ActiveX Data Object (ADO) to connect to several popular database management systems including Microsoft Access and SQL Server, Oracle, dBase and Visual Fox Pro.
Did you know that you can also talk to MySQL databases using ODBC through ASP? The MySQL database can either be on the same server, or on the other side of the world; running Windows, Linux, Solaris, FreeBSD, MacOS X, or any other one of the several operating systems that MySQL supports.
Next: Installing MyODBC >>
All examples assume a working installation of IIS 5.0/6.0 and ASP.NET 1.1 on Windows 2000 or above (Windows XP, Windows Server 2003). To obtain information on installing IIS 5.0 and ASP.NET 1.1 move over to ASP.NET web site. The techniques discussed in this article for obtaining, installing, configuring and running MySQL will work the same across almost all versions of Windows (including Windows 98), but installing it as a service and running the ASP.NET page will require NT based Windows systems.
Topics covered in this article:
1. Why use MySQL on Windows?
2. Obtaining and Installing MySQL.
3. Configuring and Running MySQL.
4. Setting root password and removing ghost account.
5. Installing, Uninstalling MySQL as a Windows service.
6. Creating a new table in MySQL database and populating it with some records.
7. Creating the ASP.NET page to display those records.
Why use MySQL on Windows?
MySQL is the most popular free and opensource database used across all major operating systems from UNIX to Windows. It provides ease of installation, simplicity and fast data access to an array of clients from Java based systems to .NET applications.
ASP Resource Indexa directory of ASP tutorials, applications, scripts, components and articles for the novice to professional developer.
Using it on Windows has several advantages:
If you've never worked with an open source database management system such as MySQL before, then you're truly missing out. MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. Huge companies such as Yahoo! Finance, MP3.com and Motorola all use MySQL in their mission-critical application and they swear by it. Best of all, you can use MySQL for free in most circumstances!
The full benefits of this article
You should have either a Windows NT/2000 machine running IIS and an intermediate knowledge of ASP, ADO and the standard ANSI-compliant SQL syntax.
* Comes for free! - Unlike other production level database systems for Windows like SQL Server and Oracle, MySQL comes for free. Looking at the huge license fees of these commercial RDBMS, it is virtually impossible for a single person or small groups of users to afford their license fees. MySQL comes to rescue!
* Very fast data access! - Not like SQL Server, but still very fast. Access database is no match for MySQL. You'll know it's speed when you use it.
* Very stable and used by large number of organizations! - Although it offers no real support (besides the ones by some free online forums and usenet sites), it mostly doesn't need any. You can though obtain commercial support from the MySQL AB company itself if you want to. MySQL is used by large number of organizations Worldwide from small Gigabyte databases to huge storage systems in Terabytes.
* Very popular among developers! - Developers simply love it. Why? use it and you'll know.
Cross platform Usage!
Use it on Windows, or get a dedicated box running Linux/FreeBSD (which are again free Operating Systems), choice is yours.
