Two Ways To Connect To SQL Server 2000 Via ASP
(Page 1 of 5 )
ASP allows even the newest developer to connect to databases with ease. In fact, the ease with which you can connect to a wide range of databases from within an ASP script is one of the reasons why ASP has become so popular. In this article Joe teaches us how to connect to SQL Server 2000 using system DSN's and an OLEDB connection string.ASP is well known for having an easy to remember language syntax, while still having enough power to allow even the newest developer to connect to databases with ease. In fact, the ease with which you can connect to a wide range of databases from within an ASP script is one of the reasons why ASP has become so popular.
In this article I'm going to show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. I will explain the positives and negatives of each method, and I will also provide you with some examples to get you started.
This article is targeted specifically at ASP newbies looking to integrate databasing technologies into their ASP pages. You should have access to a Windows NT/2000 web server and an SQL Server 2000 database. I will assume that SQL Server 2000 is on the same machine as the web server.
Next: Using system DSN's >>
More ASP Articles
More By Joe O'Donnell
/ 170 
