ASP/ColdFusion

What ColdFusion tags do you support?
All ColdFusion tags are supported except the following:

CFCONTENT tag
CFDIRECTORY tag
CFOBJECT tag
CFREGISTRY tag
CFADMINSECURITY tag
CFEXECUTE tag
CFFTP tag
CFLOG tag
CFADMINISTRATION
CFFILE
CFLDAP
Cold Fusion custom tags


How do I enable ASP or ColdFusion on my domain?
To enable ASP or ColdFusion, please perform the following instructions:

  1. Login to the WebsiteOS
  2. Select "Site Builders" from the menu
  3. Click "ASP/CFM Enabler"
  4. Select the "ASP" or "ColdFusion" tab
  5. Check "Standard" or "Secure(SSL)"
  6. Click "OK/Apply"

Please note that the application requires at least one file of the service type (ASP/ColdFusion), to be uploaded to the server before enabling the service.

Can I use ASPEmail Premium Features?
The Premium features of ASPEmail are currently not supported on our platform.

What are the DSN connection strings for ASP?
DSN connection for MS Access:
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=prefix_domain_com"

DSN connection for MySQL:
Set conn = Server.CreateObject("ADODB.Connection")

conn.open "DSN= prefix_domain_com;UID=dbm.domain.com;PWD=password"

DSN connetion for MS-SQL:
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN= prefix_domain_com;UID=dbm.domain.com;PWD=password"

What are the DSN-less connection strings for ASP?
DSNless connection for MS Access:
mdbfile = "/stuff/database.mdb"
connstr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPah( mdbfile ) & ";"

DSNless connection for MySQL:
Driver={MySQL};Server=sqlc1.megasqlservers.com;
DATABASE=prefix_domain_com;
UID=dbm.domainname.com;PWD=password;

DSNless connection for MS-SQL:
DRIVER={SQL Server};SERVER=mssqlc1.megasqlservers.com;
DATABASE= prefix_domain_com;UID=dbm_domain_com;PWD=password;

What are the DSN connection strings for ColdFusion?
**NOTE** DSN connection strings must be on one line, they cannot be split on several lines.

DSN connection for MS Access:
SELECT * FROM TableName

DSN connection for MySQL:
SELECT * FROM TableName

DSN connection for MS-SQL:
UID=dbm.domain.com;PWD=password>
SELECT * FROM TableName

What are the DSN-less connection strings for ColdFusion?
**NOTE** DSN connection strings must be on one line, they cannot be split on several lines.

DSNless connection for MS Access:
SELECT * FROM TableName

DSNless connection for MySQL:
SELECT * FROM TableName

DSNless connection for MS-SQL:
CONNECTSTRING=" Driver={SQL Server};
Server=mssqlc1.megasqlservers.com;Database=prefix_domain_com;
UID=dbm.domainname.com;
PWD=password;">
SELECT * FROM TableName

How do I enable ASP.NET or ColdFusion MX on my domain?
To enable ASP.NET or ColdFusion MX, please perform the following instructions:

  1. Login to the WebsiteOS
  2. Select "Site Builders" from the menu
  3. Click "Windows (TM) Services"
  4. Select the tab you require ("ASP", "ASP.NET" or "ColdFusion 5", ColdFusion MX)
  5. Check "Standard" or "Secure(SSL)"
  6. Click "OK/Apply"

Databases

How many Data Source Names (DSNs) can I have?
Maximum 2

How many databases can I utilize?
Two if DSNs are required, however Access files can be used with a DSNless connection from public directory.

How can I create a DSN for my database connection MS Access?
When creating a DSN, the following will be required:

Domain Name
Database Name
Database Type: MS Access/MySQL
DSN Prefix (the prefix will preceed _yourdomain_extension)
Example: db_yourdomain_com

When using MS Access, we will require the database to reside in a directory named "databases" within the root folder. Once you have created your "databases" directory, please contact us with the above information and we will create the DSN for you.

How can I create a DSN for my database connection using ASP/ASP.NET or ColdFusion/ColdFusion MX?
When creating a DSN, the following will be required:

Domain Name
Database Name
Database Type: MS Access/MySQL
DSN Prefix (the prefix will preceed _yourdomain_extension)
Example: db_yourdomain_com

Please ensure that Windows services is enabled in your WebsiteOS (ASP/ASP.NET or ColdFusion/ColdFusion MX), otherwise DSN cannot be created.

I'm trying to use a Microsoft Access database but I'm getting this error;
"MDAC - Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes or the file may be corrupt."

The latest MDAC (version 2.7), which is currently installed on our system, is not compatible with Access 97 databases. Although your database may have worked initially, once you write data to the database it will throw this error. In our shared
hosting environment, our main focus is security. In order for us to maintain our strict security model, our operating systems must be updated with current service packs and patches. If this is an Access 2000 database, it is likely that it has been
corrupted.

Can I use the LOAD DATA LOCAL for MySQL?
This specific command poses a security issue and has been disabled. To work around the issue, We have a number of options available to you, including:

Work around for phpMyAdmin:
If the file is the result of a MySQL dump then they can cut/copy&paste the contents into the query window

Work around for MySQL-Front:
Using version 2.2, 2.3, or 2.4 (and not 2.5), simply use the "Import Textfile" function to import .CSV files.

REFERENCES FROM http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html:

4.2.4 Security issues with LOAD DATA LOCAL
In MySQL 3.23.49 and MySQL 4.0.2, we added some new options to deal with possible security issues when it comes to LOAD DATA LOCAL.

There are two possible problems with supporting this command:

As the reading of the file is initiated from the server, one could theoretically create a patched MySQL server that could read any file on the client machine that the current user has read access to, when the client issues a query against the table.

In a web environment where the clients are connecting from a web server, a user could use LOAD DATA LOCAL to read any files that the web server process has read access to (assuming a user could run any command against the SQL server).

There are two separate fixes for this:

If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, unless one calls mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0) in the client. See section 8.4.3.163 mysql_options().

For the mysql command-line client, LOAD DATA LOCAL can be enabled by specifying the option --local-infile[=1], or disabled with --local-infile=0.

By default, all MySQL clients and libraries are compiled with --enable-local-infile, to be compatible with MySQL 3.23.48 and before.

One can disable all LOAD DATA LOCAL commands in the MySQL server by starting mysqld with --local-infile=0.

In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148):

The used command is not allowed with this MySQL version.
WEBMAIL  |   ACCOUNT LOGIN  |   WEB DESIGN  |   HOSTING PLANS  |   WEB DEVELOPERS  |   CONTACT
Copyright © 2007 HostHabitat.com. All Rights Reserved