ASP Built-in Objects

This applies to Linux Hosting accounts only.

Built-in objects are functions that do not need to be created before they are used. They simplify programming tasks by managing aspects of interactivity between Web server and browser, such as tracking the location of users throughout their visits to the Web site. Sun ONE Active Server Pages provides five built-in objects for the ASP framework: Request, Response, Application, Server, and Session. The information below describes their functions:

Request – Sends user request to server

Response – Returns server request to user

Application – Stores information needed for all users of a particular application. Information stored here remains for the lifetime of the application.

Server – Provides access to methods and properties on the server. These methods and properties typically serve as utility functions.

Session – Stores information needed for a particular user session. Information stored in the Session object is not lost when the user jumps between pages in the application; instead, information remains for the entire user session.

Database connections from ASP fail with ‘Client does not support authentication protocol requested by server’

This applies to Linux Hosting accounts only.

Sun ONE ASP does not support the default authentication method used by MySQL 5. Instead it is necessary to make MySQL use the ‘old-style’ authentication.

To do that, first log in to MySQL via phpMyAdmin or another MySQL administration program and then use the ‘old_password’ function to change the authentication style by running the SQL query:

set password = old_password(‘password’);

How do I connect to MySQL with ASP?

This applies to Windows Hosting accounts only.

You will need to use a DSNless connection which can be achieved by using code with the following VBscript:

set rsEvents = Server.CreateObject(“ADODB.Recordset”)
rsEvents.ActiveConnection = “Driver={MySQL ODBC 5.1 Driver}; DATABASE=databasename;USER=username; PASSWORD=password; Server=127.0.0.1”

…or the following JScript:

var rsEvents = Server.CreateObject(“ADODB.Recordset”);
rsEvents.ActiveConnection = “Driver={MySQL ODBC 5.1 Driver}; DATABASE=databasename;USER=username; PASSWORD=password; Server=127.0.0.1”;

What is ASP?

ASP is a server-side scripting language developed by Microsoft, and originally designed to run on Windows hosting platforms. We have deployed Chilisoft ASP (Java System Active Server Pages – an emulated ASP provided by Sun One) on our Linux platform to allow ASP code to run on our Linux servers.

ASP is not the same as ASP.NET – they are very different technologies.