Support Manual

Active Server Pages (ASP)

Version 3.6.0 Chilisoft

We are pleased to offer Sun ONE Active Server Pages (formerly Sun Chili!Soft ASP) support in most of our hosting packages.

If you plan to use ASP on your site just login to your control panel, click the ASP icon, and ASP will be installed on your site within 10 minutes.

Sun ONE Active Server Pages software is a secure, enterprise-class Active Server Pages (ASP) engine for the Sun ONE and Apache Web servers. Sun ONE Active Server Pages (ASP) is designed to help organizations deploy new or existing ASP applications within a secure and reliable Web infrastructure.

What is ASP?

ASP stands for Active Server Pages. Active Server Pages are HTML pages with embedded ASP scripts that are processed on the server before the page is sent to the user. ASP allows you to create dynamic database driven pages, a user can access data in a database and interact with page objects such as Active X or Java components.

If you want a dynamic data-driven web site you may wish to embed ASP code into your web site’s HTML Pages. When a user is viewing a web site that is developed using ASP, the pages can change depending on the actions of the user.

You can also create database-drive site with PHP and MySQL, support for which are included in all our hosting packages at no extra charge.

Spice Pack

Spice pack is included with all hosting packages with ASP Support. Spice Pack is a collection of server side ActiveX controls that implement and provide many functions common to Active Server Page applications. The Chili!Soft ASP Spice Pack includes the following server side ActiveX components:

Chili!Mail (SMTP Component): The Chili!Soft Mail 1.0 ActiveX Control enables
users to create and send email messages via SMTP from ASP scripts. The Chili!Soft Mail control is designed to be closely compatible with the NewMail object that is included with the Microsoft IIS CDONTS component.

Chili!Upload (File Upload Component) :The Chili!Upload 1.0 ActiveX Control enables users to save files uploaded by site visitors to the server.

Chili!POP3 (POP3 Component) :The Chili!Pop3 1.0 Control enables users retrieve
messages from a POP3 server using ASP scripts

 

ASP Info Downloads:

ChiliSoft ASP User's Guide

SUN Chili!Soft ASP Scalability and Performance Guide

 

ODBC interactions from Access to MySQL

See the following link:

http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html


How do I connect to Microsoft databases?

You need a Windows-OS machine to access Microsoft databases. This is not a Sun Chili!Soft ASP requirement; no Microsoft application runs on Linux, and databases are no exception.

For Microsoft SQL Server 7.0, there is a direct driver. For SQL Server 6.5 and Access, connectivity is available through the use of DataDirect's (formerly MERANT's) SequeLink product. This is an ODBC driver in two parts; the UNIX portion ships as part of the Sun Chili!Soft ASP installation, and the Windows portion is available from our FTP site at ftp://ftp.chilisoft.com/pub . Log in anonymously and download the slkntsrv.zip file. Use "EVAL" as the serial number and leave the license key request blank. Detailed configuration instructions can be found in the Sun Chili!Soft ASP product documentation. Contact Sun Chili!Soft Customer Support for a utility that converts the EVAL license to a permanent one.

 

Some points to keep in mind:

You need to create a local Windows account on the Windows machine to permit access. A database username and password are also required.

After installing the SequeLink software on the Windows machine, use the SequeLink Server Administrator to run the services.

The setsqlnk utility located in /opt/casp/asp-apache-XXXX is used to create and test connections to your Windows machine. The username and password entered in setsqlnk correlate to the Windows user account.

Use the IP address of the db machine in setsqlnk.

When prompted for a Name [SLSocket] in the setsqlnk utility, enter SLSocket (or whatever name you used during the Windows software installation), or enter the port number of the service running on the Windows machine.

The odbc.ini entries use the database username and password.

The Linux driver for SQL Server 7.0 doesn't support the SQL API calls that are required to perform the ADO Recordset method of Update. You need to use the straight SQL code in an SQL statement and not the RS.AddNew and RS.Update methods. This is a driver limitation and we are waiting for new drivers from another company for full functionality.

Here is an example using Microsoft Access:

A DSN called "access1" is made via setsqlnk and has been tested to work. It is now referred to as SqlnkDSN.

Make a DSN in odbc.ini that uses SqlnkDSN:
[ODBC Data Sources]
access_db=example access database
[access_db]
Driver=/opt/casp/lib/YYslk13.so
Description=Sqlnk Driver for Access
SqlnkDSN=access1
LogonID=username
Password=passwd
Database=c:testdbdb.mdb
UidPwdMapping=0
EnableScrollableCursors=1

The connection string in ASP would look like:

db.Open "DSN=access_db"

Adding more parameters in the ASP connection string will override the odbc.ini settings:

db.Open "DSN=access_db;Database=c:accessaccess.mdb;UID=user2;PWD=passwd2"

 

 

Copyright © 2003-2007 Hosting Connecticut, LLC.
Resellers of Hosting Connecticut, LLC. may reproduce this manual on their sites.