CodeCharge Studio

Setting up the work environment

Considering that there are several different programming languages that CodeCharge Studio generates, plus upwards of a dozen possible databases, there are obviously many configurations that could be used. Each combination of language and database has its own unique merits. In each of the following tables, we examine some of the more typical setups for each language. Note that this is not to say that you cannot use setups beyond those stipulated here.

ASP Setup

A common configuration for the development of ASP applications is as follows:

Development Environment (for the development and testing of applications):

Server Environment (for hosting the final application):

For ASP and Templates, the following table provides a list of applicable operating system, web server, database, and language version options.

ASP Setup

Server Operating System Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP
Web Server Internet Information Services (IIS) 4.0 or 5.0, Personal Web Server
Scripting Engine/Language

ASP 3.0 with VBScript 5.5+

Database Server Microsoft Access, MS SQL Server, Oracle, MySQL, PostgreSQL, DB2, FoxPro, or other database via ODBC

The following is a list of steps that should be performed to setup and test the environment where the ASP pages will be published. These steps don't have to be followed strictly in the order in which they are presented here.

Install and configure the web server software

Some versions of Windows such as Windows NT Server, Windows 2000 Server and Windows XP Professional have the option of installing IIS server during the operating system installation process. Alternatively, the server can be installed later from the operating system setup CD. If your version of Windows does not allow the installation of IIS (e.g. Windows 98), you can install Personal Web Server (PWS) which is a scaled down version of IIS Server. The CodeCharge website carries a tutorial which contains more information about installing and configuring PWS.

Test the Web Server

After installing the web server software, you should run a test to make sure that the server is functioning properly. For a server that has been installed on the local machine, the URL http://localhost/ or http://127.0.0.1/ can be used to test the server. When you type in this address, you should be able to see the default page in the root directory of the server. In particular, you should test a .asp page since this is the language you will be generating pages in. By default, the IIS server will bring up the .asp page (http://localhost/localstart.asp). Both IIS and PWS come with extensive documentation which you should consult for detailed setup, configuration and testing instructions.

Setup the Database

Once you confirm that you have a fully functional web server, you should then make sure that you have a suitable database to use. In the case of ASP, the easiest database to use would be Access. In order for the web pages to be able to use the Access database, the security settings for the database have to be setup correctly. Make sure that the database file is not opened in exclusive mode by any other user. Using Windows Explorer, right-click on the database file and open the properties dialog. Under the security tab, make sure everyone has access to the file or at the least the IUSR_MachineName account should have Read and Write Permissions on the file. The IUSR_MachineName account is the account which is used by the web server to access the database.

If you are using a different database such as MS SQL server or Oracle, make sure that you have an account in the database with which you can access the required tables.

Create and Test a CodeCharge Project

CodeCharge Studio comes with a number of example projects which you can easily generate and publish as a way of testing that you have a functional setup. Each of these examples comes with an Access database as well as a database script file which you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the Quick Start section within the documentation for step by step instructions on how to create and publish your first web application as well as the section on deploying ASP projects.

Troubleshoot Errors

If you encounter errors when you attempt to view the published pages, there are a number of things you can do to troubleshoot the problem. To begin with, you should make sure that you have a detailed error message. If you are using the Internet Explorer browser, make sure that the Show Friendly HTTP error messages option is disabled under the Advanced tab of the Internet Options dialog window. Once you have the error message, you can check the knowledgebase at http://support.codecharge.com/kb_search.asp to see if the matter is addressed there. If you are not able to find a solution for the problem, you can open a support request at http://support.codecharge.com/support_new.asp.

.NET Setup

A common configuration for the development of ASP.NET applications is as follows:

Development Environment : (for the development and testing of applications):

Server Environment (for hosting the final application):

For ASP.Net (C# and VB.Net) projects, the following provides a list of applicable operating system, web server, database, and language version options.

.NET Setup

Server Operating System Windows 2000, Windows XP, Windows .Net Server
Web Server Internet Information Services (IIS) 5.0, (requires installation of the Microsoft .Net SDK 1.0.3705 or later)
Scripting Engine/Language C# or Visual Basic.NET
Database Server Microsoft Access, MS SQL Server, Oracle, MySQL, PostgreSQL, DB2, FoxPro, or other database via ODBC

The following is a list of steps that should be performed to setup and test the environment where the .Net pages will be published. These steps don't have to be followed strictly in the order in which they are presented here.

Install and configure the web server software

In order to publish .Net pages, you need to have an installation of the IIS 5.0 server. The IIS server is available on Windows 2000 and XP Professional operating systems as well as the Windows .Net server which is still in development as of this publishing. In addition to the IIS 5.0 server, you also must download and install the .Net Framework. This can either be the .Net Framework redistributable or the .Net Framework SDK (http://www.asp.net/).

Test the Web Server

After installing the web server software, you should run a test to make sure that the server is functioning properly. For a server that has been installed on the local machine, the URL http://localhost/ or http://127.0.0.1/ can be used to test the server. When you type in this address, you should be able to see the default page in the root directory of the server.

In order to test whether the .Net Framework was successfully installed, you need to test a .aspx page. Please refer to the documentation that accompanies the .Net Framework for information on how to test that the installation was successful.

Setup the Database

Once you confirm that you have a fully functional web server, you should then make sure that you have a suitable database to use. In the case of .Net, the easiest database to use would be Access. In order for the web pages to be able to use the Access database, the security settings for the database have to be setup correctly. Make sure that the database file is not opened in exclusive mode by any other user. Using Windows Explorer, right-click on the database file and open the properties dialog. Under the security tab, make sure everyone has access to the file or at the least the IUSR_MachineName account should have Read and Write Permissions on the file. The IUSR_MachineName account is the account which is used by the web server to access the database.

If you are using a different database such as MS SQL server or Oracle, make sure that you have an account in the database with which you can access the required tables. Also, if you intend to use an ODBC connection, you need to download and install the ODBC.Net managed provider as indicated in the table above.

Create and Test a CodeCharge Project

CodeCharge Studio comes with a number of example projects which you can easily generate and publish as a way of testing that you have a functional setup. Each of these examples comes with an Access database as well as a database script file which you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the quickstart tutorial for step by step instructions on how to create and publish your first web application. Note that .Net projects have special publishing requirements which you can read about in the section on deploying .Net projects.

Troubleshoot Errors

If you encounter errors when you attempt to view the published pages, there are a number of things you can do to troubleshoot the problem. To begin with, you should make sure that you have a detailed error message. If you are using the Internet Explorer browser, make sure that the Show Friendly HTTP error messages option is disabled under the Advanced tab of the Internet Options dialog window. Once you have the error message, you can check the knowledge base at http://support.codecharge.com/kb_search.asp to see if the matter is addressed there. If you are not able to find a solution for the problem, you can open a support request at http://support.codecharge.com/support_new.asp.

ColdFusion Setup

A common configuration for the development of ColdFusion applications is as follows:

Development Environment (for the development and testing of applications):

Server Environment (for hosting the final application):

For ColdFusion, the following table provides a list of applicable operating system, web server, database, and language version options.

ColdFusion Setup

Server Operating System Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Unix/Linux.
Web Server Internet Information Services (IIS) 4.0 or 5.0, Personal Web Server, Apache server.
Scripting Engine/Language ColdFusion 4.0.1, 4.5, ColdFusion 5.x, ColdFusion MX.
Database Server Microsoft Access, MS SQL Server, Oracle, MySQL, PostgreSQL, DB2, FoxPro, or other database via ODBC.

The following is a list of steps that should be performed to setup and test the environment where the ColdFusion pages will be published. These steps don't have to be followed strictly in the order in which they are presented here.

Install and configure the web server software

In order to deploy ColdFusion pages, you need a web server which also has the ColdFusion engine installed. The minimal ColdFusion version you can use is 4.0.1. This means that you can use any version higher than this i.e. 4.5, 5.0 and MX. Each of these different versions can be installed on a varying number of web servers ranging from Microsoft IIS and PWS to Apache and Netscape Server. Please consult the documentation for the version that you intend to use to find out which web servers are supported and how to install and configure the ColdFusion engine on the web server.

Test the Web Server

After installing the web server software and the ColdFusion engine, you should run a test to make sure that the server is functioning properly. Please refer to the ColdFusion server documentation which includes directions on how to test whether the server is working correctly.

Setup Database

Database connections in ColdFusion can be made using ODBC DSN's or data sources that are configured in the ColdFusion Administrator panel.

Create and Test a CodeCharge Project

CodeCharge Studio comes with a number of example projects which you can easily generate and publish as a way of testing that you have a functional setup. Each of these examples comes with an Access database as well as a database script file which you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the quickstart tutorial for step by step instructions on how to create and publish your first web application as well as the section on deploying ColdFusion projects.

Troubleshoot Errors

If you encounter errors when you attempt to view the published pages, there are a number of things you can do to troubleshoot the problem. To begin with, you should make sure that you have a detailed error message. If you are using the Internet Explorer browser, make sure that the Show Friendly HTTP error messages option is disabled under the Advanced tab of the Internet Options dialog window. Once you have the error message, you can check the knowledgebase at http://support.codecharge.com/kb_search.asp to see if the matter is addressed there. If you are not able to find a solution for the problem, you can open a support request at http://support.codecharge.com/support_new.asp.

JSP Setup

A common configuration for the development of Java applications is as follows:

Development Environment (for the development and testing of applications):

Server Environment (for hosting the final application):

For JSP and Java Servlets, the following table provides a list of applicable operating system, web server, database, and language version options.

Java Servlets and JSP Setup

Server Operating System Unix/Linux, Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP
Web Server Tomcat, Resin, BEA Weblogic, IBM Websphere, Macromedia JRun, Apache + Tomcat, Internet Information Services (IIS) + Tomcat, or other Web Server that supports Servlet API version 2.2.
Database Server MySQL, PostgreSQL, Oracle, DB2, MS SQL Server, Informix, or other database via JDBC or JDBC-ODBC Bridgeŝ

The following is a list of steps that should be performed to setup and test the environment where the JSP pages or Java Servlets will be published. These steps don't have to be followed strictly in the order in which they are presented here.

Install and configure the web server software

The Servlet engine is implemented by a variety of web servers including Tomcat, Resin, Sun ONE, Weblogic, and WebSpheher. The procedure for installing the Servlet engine depends on the web server that you are going to use. You can download the free Tomcat web server along with its documentation from http://jakarta.apache.org/tomcat/.

Test the Web Server

After installing the web server software, you should run a test to make sure that the server is functioning properly. For a server that has been installed on the local machine, the root URL http://localhost:8080/ or http://127.0.0.1:8080/ can be used to test the server. Please refer to the documentation for the server you have installed for information on how to confirm that the installation was successful.

Setup the Database

It is common to use the MySQL database when publishing in JSP. You can download MySQL from http://www.mysql.com/ where you will also find documentation for the database as well as a link to download the MyODBC driver which can be used to make an ODBC connection to a MySQL database during design time. The MySQL JDBC driver can be downloaded from http://www.mysql.com/products/connector-j/.

Create and Test a CodeCharge Project

CodeCharge Studio comes with a number of example projects which you can easily generate and publish as a way of testing that you have a functional setup. Each of these examples comes with an Access database as well as a database script file which you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the quickstart tutorial for step by step instructions on how to create and publish your first web application as well as the section on deploying Java projects.

Troubleshoot Errors

If you encounter errors when you attempt to view the published pages, there are a number of things you can do to troubleshoot the problem. To begin with, you should make sure that you have a detailed error message. If you are using the Internet Explorer browser, make sure that the Show Friendly HTTP error messages option is disabled under the Advanced tab of the Internet Options dialog window. Once you have the error message, you can check the knowledgebase at http://support.codecharge.com/kb_search.asp to see if the matter is addressed there. If you are not able to find a solution for the problem, you can open a support request at http://support.codecharge.com/support_new.asp.

PHP Setup

A common configurations for the development of PHP applications is as follows:

Development Environment (for the development and testing of applications):

Server Environment (for hosting the final application):

Note that the MyODBC driver is needed only during the application design stage. The generated code can access the database directly without an ODBC driver. You can obtain the MyODBC driver from www.mysql.com.

For PHP, the following table provides a list of applicable operating system, web server, database, and language version options.

PHP Setup

Server Operating System Unix/Linux, Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP
Web Server Apache, Internet Information Services (IIS) 4.0 or 5.0, Personal Web Server
Scripting Engine/Language PHP 4.0b3 or higher
Database Server MySQL, PostgreSQL, Microsoft Access, MS SQL Server, Oracle, DB2, FoxPro, or other database via ODBC

The following is a list of steps that should be performed to setup and test the environment where the PHP pages will be published. These steps don't have to be followed strictly in the order in which they are presented here.

Install and configure the web server software

The PHP engine can be installed on a wide variety of web servers including IIS, PWS, and Apache. The procedure for installing the PHP engine varies depending on the web server that you are going to use. The PHP engine can be downloaded from http://www.php.net where you will also find information on how to perform the installation. You can also download the free Apache web server along with its documentation from http://www.apache.org.

Test the Web Server

After installing the web server software, you should run a test to make sure that the server is functioning properly. For a server that has been installed on the local machine, the root URL http://localhost/ or http://127.0.0.1/ can be used to test the server. Please refer to the documentation for the server you have installed for information on how to confirm that the installation was successful.

Setup the Database

It is common to use the MySQL database when publishing in PHP. You can download MySQL from http://www.mysql.com where you will also find documentation for the database as well as a link to download the MyODBC driver which can be used to make an ODBC connection to a MySQL database during desgin time.

Create and Test a CodeCharge Project

CodeCharge Studio comes with a number of example projects which you can easily generate and publish as a way of testing that you have a functional setup. Each of these examples comes with an Access database as well as a database script file which you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the quickstart tutorial for step by step instructions on how to create and publish your first web application as well as the section on deploying PHP projects.

Troubleshoot Errors

If you encounter errors when you attempt to view the published pages, there are a number of things you can do to troubleshoot the problem. To begin with, you should make sure that you have a detailed error message. If you are using the Internet Explorer browser, make sure that the Show Friendly HTTP error messages option is disabled under the Advanced tab of the Internet Options dialog window. Once you have the error message, you can check the knowledgebase at http://support.codecharge.com/kb_search.asp to see if the matter is addressed there. If you are not able to find a solution for the problem, you can open a support request at http://support.codecharge.com/support_new.asp.

PERL Setup

A common configuration for the development of Perl applications is as follows:

Development Environment (for the development and testing of applications):

Server Environment (for hosting the final application):

Note that the MyODBC driver is needed only during the application design stage. The generated code can access the database directly without an ODBC driver. You can obtain MyODBC driver from www.mysql.com

For PERL, the following table provides a list of applicable operating system, web server, database, and language version options.

PERL Setup

Server Operating System Unix/Linux, Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP.
Web Server Apache, Internet Information Services (IIS) 4.0 or 5.0, Personal Web Server.
Scripting Engine/Language PERL 5.0 or higher (i.e., some popular distributions of PERL include ActiveState PERL, Mod_PERL for Apache, and Indigo PERL).
Database Server MySQL, PostgreSQL, Microsoft Access, MS SQL Server, Oracle, DB2, FoxPro, or other database via ODBC.

The following is a list of steps that should be performed to setup and test the environment where the Perl pages will be published. These steps don't have to be followed strictly in the order in which they are presented here.

Install and configure and test the web server software

The Perl language comes in many distributions as shown in the table above. Among the most popular are ActivateState Perl and Indigo Perl. You can also find more distributions at http://www.perl.com. Depending on the distribution of Perl you decided to use, the accompanying documentation should contains information on how to install, configure and test the server. Note that the Perl distribution is installed on top of a web server such as Apache or IIS. If you already have a web server, you can examine each of the distributions to see which is compatible with your web server. If you don't have a web server, you can download the free Apache web server from http://www.apache.org. Most Perl distributions are compatible with Apache.

Setup the Database

Database connections in Perl require special modules known as database interfaces.

It is common to use the MySQL database when publishing in Perl. You can download MySQL from http://www.mysql.com where you will also find documentation for the database as well as a link to download the MyODBC driver which can be used to make an ODBC connection to a MySQL database.

Create and Test a CodeCharge Project

CodeCharge Studio comes with a number of example projects which you can easily generate and publish as a way of testing that you have a functional setup. Each of these examples comes with an Access database as well as a database script file which you can use to recreate the database. Please refer to the section on the example solutions for detailed instructions on how to setup and use them.

You can also refer to the quickstart tutorial for step by step instructions on how to create and publish your first web application as well as the section on deploying Perl projects.

Troubleshoot Errors

If you encounter errors when you attempt to view the published pages, there are a number of things you can do to troubleshoot the problem. To begin with, you should make sure that you have a detailed error message. If you are using the Internet Explorer browser, make sure that the Show Friendly HTTP error messages option is disabled under the Advanced tab of the Internet Options dialog window. Once you have the error message, you can check the knowledgebase at http://support.codecharge.com/kb_search.asp to see if the matter is addressed there. If you are not able to find a solution for the problem, you can open a support request at http://support.codecharge.com/support_new.asp.

See next:

Working Environment


On-line, printable versions and updates