 | MS
Access to MS SQL 2000 Database Upsize
|
|
Sample chapter from Wrox on what ASP is.
"In the dim and distant past, web developers wishing
to create more than just static displays of
information for the web turned to CGI (Common Gateway
Interface) and Perl to introduce some sort of
interaction to their pages. While this approach worked
and indeed many sites still use it today, CGI was not
by any means fast and the quest for an alternative
means to create a page dynamically continued. Then
finally came web scripting languages and with them
Microsoft's Active Server Pages: a server-side
scripting technology for building web pages that are
both dynamic and interactive."
"An active server page itself is simply a text file
script with the extension .asp containing HTML,
client- and server-side script. The implementation
behind it meanwhile was created by Microsoft and
intended as an open technology server-side framework,
giving web developers the freedom to develop dynamic
web sites using information accessed from the many
COM-compliant data sources available to them."
|
|
Performance Tuning
ASP Pages Connecting to SQL Server
|
|
Access Database
Connection - ASP Source Code
(for FWHN hosting
customers)
|
|
SQL Database
Connection - ASP Source Code
(for FWHN hosting
customers)
|
| SQL Support
- Structured Query Language (SQL) and MS SQL 2000
|
| Also See Support for
FrontPage 2002
or FrontPage
98/2000
|
| Setting
Up Personal Web Server
|
|
ODBC/DSN
At a
customers request, and a hosting plan supporting ODBC/DSN, FWHN sets up an ODBC
System DSN (data source name) which points to a
Microsoft Access database within their site.
The data source name is a
textual string that is used to reference the data
source by application programs, such as Microsoft
Access. A unique identifier
must be provided for each data source, such as
xyzdatabase noted below.
In other words, the data source name allows you to
interface with a Microsoft Access database using ASP.
The database is placed in a data directory outside of
the content directory for security purposes. If
visitors to the site will be allowed to make
modifications to the database, our FWHN technicians
need to know so they can assign write permissions on
that folder where the database resides.
For example, you have a database called
mydatabase1.mdb and it is located in a folder called
mydatafolder. You select any name for the DSN, such as
xyzdatabase, and contact our tech department and tell
them: "I would like a DSN of xyzdatabase for
mydatabase1.mdb located in mydatafolder." Also, be
sure to inform our tech department if you need write
permissions for people to modify the database.
You will then use the DSN as part of your connection
string when creating ASP pages that need to connect to
the database. See our listing of
ASP Web Sites.
Need more ODBC/DSN's than your hosting plan provides?
Purchase more.
|
| IIS
4.0 Recommended Installation Procedure
|
|
AspMail 4.x User Manual
|
|
AspUpload 2.1 User Manual
|
| Microsoft's Windows
Scripting Technologies
VBScript, Script Debugger, JScript and more.
|
| Microsoft's
Online Newsgroups
|
| Microsoft's
Knowledge Base Search
|
| Microsoft's
Active Server Pages Support Center
|
