The new utility makes it easy to activate an old version of Code On Time.

AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Thursday, December 7, 2023PrintSubscribe
Activation of Legacy Versions

Customers with the expired product activation codes can activate the legacy versions of Code On Time on the new devices with the help of the Activator Utility. This may be necessary on the newer Windows devices that are incompatible with the previous versions of our product.

This is the typical output of the Activator Utility. The utility downloads the prerequisites and the licensed code generation library files. The process is complete when the “Done” message is displayed. You can begin using Code On Time when the product activation has been completed.
Learn about the Activator Utility if you are planning to use the legacy version of Code On Time on the new device.
Tuesday, February 5, 2013PrintSubscribe
DB2 Sample Web Application

The database server DB2 Express-C, provided by IBM, comes with a database called “SAMPLE”. Let’s use Code On Time web application generator to create a web app straight from this database.

Installing and Configuring DB2

The first step is to download the  DB2 Express-C 10.1.2 for Windows 64-bit from the IBM website.

When the download is complete, run the executable. Follow the steps to install DB2 on your computer.

Creating a Web Application

Start the web app generator and click on the Create a new web application link on the start page. On the New Project screen, select Web Site Factory.

Creating a new Web Site Factory application.

Assign a name of “DB2Sample”, select your preferred programming language, and press Create.

Creating a new project called 'DB2Sample'.

Preserve the default Namespace and Framework, and press Next.

Namespace and Framework page of Code On Time project wizard.

From the Data Provider dropdown, select IBM DB2 .NET Data Provider.

Creating a DB2 database connection string.

To the right of the Connection String field, click on the “…” button to activate the Connection String Assistant.

If you are using a locally installed database, use the following configuration:

Database: SAMPLE

If you want to connect to a local database as a different user, use Server of “” or “localhost”. If you are using a remote database, model your configuration after the one below:

Server: [IP Address]:[Port]
Database: SAMPLE
User name: [User name]
Password: [Password]

Press Test to confirm that the settings are configured correctly.

The connection succeeds when tested.

Press OK to insert the connection string into the field.

Configured connection string inserted into the 'Connection String' field.

Press Next twice to reach the Reporting page. Check the box to enable reporting.

Enabling reporting for the Web Site Factory web application.

The next page allows configuration of Custom Membership and Role Providers. Leave the default settings and press Next until you reach the Theme page. Select “Summer” from the list box.

Selecting the 'Summer' theme in the Project Wizard.

Hold down Shift key and press Next to skip to the Summary page. Press Generate to create the web application.

The Summary screen of the Project Wizard.

When generation is complete, the web application will open in the default browser.

Default Employee page of a generated web application from SAMPLE DB2 database.

Saturday, December 8, 2012PrintSubscribe
HR Sample App (Oracle)

Sample database HR (Human Resources) comes standard with Oracle database server. Let’s create a web application straight from this database.

Getting Oracle on Your Computer

First, download the Oracle Database Express Edition 11g Release 2 installation files.

When the download is complete, extract the zip folder. Run the file at DISK1\setup.exe. Follow the steps to install Oracle Express Edition 11g on your computer.

When the database server has been installed, log in to the management website. The link to the page is available at C:\oraclexe\app\oracle\product\11.2.0\server\Get_Started.url. In the web browser, click on the Application Express tab, and create a workspace in order to access the database.

Native vs. Managed Data Provider

Code On Time web application generator creates web apps based on Microsoft ASP.NET, a component of Microsoft.NET technology. Database vendors offer middleware that allows ASP.NET applications to communicate with their servers. Oracle offers two providers:

The ODP.NET (Oracle Data Provider) is included in the Oracle Data Access Components (ODAC) for Windows package. The provider is a managed .NET wrapper that “speaks” to unmanaged native API of Oracle database server.

Because of this mix of managed and unmanaged code, there is a need to install both 32-bit and 64-bit versions of ODP.NET when working with Windows 7 and 8. Some components of development tools for Windows support only 32-bit architecture. Each version of ODP is around 230 MB in size.

The ODP.NET, Managed Driver is less than 2 MB in size and written purely in .NET. It has better performance and is easier to configure. This is the recommended .NET provider for ASP.NET web applications.

Click on one of the links above and install one of the providers for Oracle.

Creating a Web Application

Start the code generator, and click on the Create a new web application link on the start page. Select Web Site Factory to create the project.

Creating a 'Web Site Factory' project on the New Project screen.

Assign the project a name of “HR”, select the programming language of your choice (C# or Visual Basic), and press Create.

Assigning a name of 'HR' to the project.

Leave the default Namespace and Framework values and press Next.

Select the desired ODP provider in the Data Provider dropdown, and click on the “…” button next to Connection String field to access the Oracle Connection screen.

Selecting the 'Oracle Data Provider for .NET, Managed Driver' for the Data provider dropdown on the Database Connection screen.

'Oracle Data Provider for .NET' data provider selected. The '...' button next to Connection String field will activate the 'Oracle Connection' screen.

Enter your Server name, User name, and Password in the appropriate fields.

If you are working with Oracle Express Edition and using ODP.NET Managed Driver, leave the Server name blank. If you are using ODP.NET , then enter “” in the Server name.

Press the Test button to test the connection string.

Alert showing that test connection succeeded for the Oracle connection string.

Press OK to dismiss the Connection Status window, and press OK to insert the configured connection string into the field.

Press Next twice to reach the Reporting page. Check the box to enable reporting.

Enabling reporting for the web application.

Press Next to reach the Themes page. Select Social from the list box.

Selecting a theme for the web application.

Hold down Shift, and press Next to skip to the Summary screen.

Activating the 'Generate' button on the Summary screen.

Press Generate to start the code generation. A window will open in your default web browser with the web app when complete.

Generated web application loaded in the default web browser.

Learn how to configure Custom Membership and Role Provider for your Oracle database.

Continue to Installation Issues