|
|
1-18 of 18 ASP Databases > Beginners Guide sites are shown.
|
|
This manuscript is an abridged version of a chapter from the Wrox Press book Professional Active Server Pages 3.0. Connections, Commands And Procedures examines the different ways in which ADO can access data.
|
|
|
|
|
|
|
The code to connect
to a database is actually pretty easy, when you have figured out how your connection string should
look like.
|
|
|
|
|
|
|
Some ISP:s setup a
datasource name for you and if that's the case it is easy. You have
probably specified for your ISP where your actual database file is
located ( maybe under a /odbc ) directory. Then he sets up for you a
sort of shortcut for you where you only have to specify the datasource
name to access the specific database file.
|
|
|
|
|
|
|
This way could be
very difficult, since you have a lot of options you could specify in
the connection string. However, the simple connection string I present
to you here is actually all you need for adequate performance in most
cases.
|
|
|
|
|
|
|
most
It is important is to put the connection string generation into a
separate file, which is then included from all other ASP files needing
a database connection.
|
|
|
|
|
|
|
The Connectstring you
specify when you call oConnection.Open is no doubt pretty hard to deal
with. It is also critical, since if you make a mistake you might
not be able to connect to your database.
|
|
|
|
|
|
|
Tip on how to reduce number of database calls with the Session variable
I have tried to make ASPCode.net as dynamic as possible. I store all
resources in a
SQL Server database and dynamically builds up the pages, menu etc
|
|
|
|
|
|
|
This page provides some different ways of connecting to a database than the usual Data Source Name route.
|
|
|
|
|
|
|
In this document we will discuss the ability to access SQL Server databases through Visual Basic commands, both in Visual Basic programs and Visual Basic Script
|
|
|
|
|
|
|
This lesson focuses on connecting Access with PWS 4.0 on a Win95 machine. You can use the same procedure on Win98. You will also learn how to create a database table in Access and how to retrieve it's content and display it through ASP.
|
|
|
|
|
|
|
In this document we will discuss the ability to access SQL Server databases through Visual Basic commands, both in Visual Basic programs and Visual Basic Script
|
|
|
|
|
|
|
Probably the most popular use for ASP scripting is connections to databases. It's incredibly useful and surprisingly easy to do. Here we show you how.
|
|
|
|
|
|
|
Answers some common questions amongst database newbies
|
|
|
|
|
|
|
Since ASP is especially good at reading and writing to databases, let's start with a very simple database and scripts that we'll eventually build into a guestbook.
|
|
|
|
|
|
|
This article will get you started on using Visual Basic with a Microsoft Access database. It will teach you how to connect to a database, do a simple query and display the results of the query.
|
|
|
|
|
|
|
This article will take you through the steps to get data from a database and present it on the screen in a nice and orderly fashion (table).
|
|
|
|
|
|
|
Developing web pages that present information from a database is easier than you might think when using a technology such as ASP. This article will help you get started with pulling data from a database and presenting it on a web page using Active Server Pages.
|
|
|
|
|
|
|
Article provides in depth info on connecting to SQL Server,
Oracle, Access and MySQL Server Databases, retrieving records and
displaying them to the user using plain ASP pages. Everything has been
explained in detail.
|
|
|
|
|
|
Votes:178
Hits:3001
