Blog: Posts from June, 2014

Labels
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)
Archive
Blog
Posts from June, 2014
Monday, June 16, 2014PrintSubscribe
Deployment: Prerequisites for Windows Server 2008 R2

Click on the Start button, and type in the word “features”. Click on “Turn Windows features on or off”.

Searching for the Server Manager.

The Server Manager will open. Right-click on Roles in the tree in the left pane, and press “Add Roles”.

Adding Roles to the server.

The Add Roles Wizard will open. Press Next to continue to the list of roles to add. Check the box next to “Application Server”. Include any required features that may be prompted.

Adding the "Application Server" role.

Press Next twice to continue to the Role Services page. Check the box next to “Web Server (IIS) Support”. Confirm to add the required roles.

Adding Web Server (IIS) Support.

Keep pressing Next until the Confirmation page appears. Select Install to add the roles to the server. This process may take some time.

Completing Installation of ASP.NET 4.5

Microsoft ASP.NET 4.5 is present on the server if all required Windows Updates have been installed. If you are using a Virtual Machine (VM) of Windows Server 2008 R2 SP1 from Windows Azure, these updates will already be installed.

Note that ASP.NET 4.5 is based on ASP.NET 4.0 and includes additional software components. The next steps do apply to ASP.NET 4.5 despite the fact that ASP.NET 4.0 folders are being referenced.

Press Start on the taskbar. Type in “cmd”, and click on the first result.

Starting command prompt.

In the prompt, type in the following for a 64-bit system:

%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i

If you using a 32-bit system, type the following:

%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe –i

Press Enter on the keyboard, and wait for the program to finish executing.

Installing ASP.NET 4.0.

This step will configure IIS to reference ASP.NET 4.5 libraries.

Monday, June 16, 2014PrintSubscribe
Deployment: Copying Application onto Web Server

On your local computer, start Code On Time generator, click on the project name, and select Publish.

In the File Explorer window that will open, select all the files, right-click, and press “Send To | Compressed (zipped) folder”.

Compressing the contents of the web app.

Right-click on the newly created zipped folder and press Copy.

Copying the zipped folder containing the web app.

If you are deploying the app to the same machine, then open Windows Explorer and navigate to “Computer / Local Disk (C:) / inetpub / wwwroot”. Right-click on the folder and press Paste.

Pasting the zipped web app into the inetpub/wwwroot folder.

If you are deploying to a different computer, then use Remote Desktop to login to the computer. Paste the zipped folder into the same location.

Pasting the zipped web app into the inetpub/wwwroot folder.

Right-click on the zipped folder, and press “Extract All…”.

Change the name of the destination folder to match the name of your app, and press Extract to start extraction.

Extracting the contents of the web app folder.

The application files will be located under “C:\inetpub\wwwroot\”.

The extracted contents of the web app.

Monday, June 16, 2014PrintSubscribe
Deployment: Installing Report Viewer 2012

If you have enabled dynamic and static reports for the app, then the Reports menu option is available in the user interface.

Report menu button in the local app.

Selecting any report option will cause the app to produce a PDF, TIFF, Excel, or Microsoft Word document with reporting data.

The various default reporting options.

If Report Viewer is not installed on the machine, any attempt to start the application will display the error message below stating that “Could not load file or assembly Microsoft.ReportViewer.WebForms…”.

Error message displayed when Report Viewer is not installed.

If you do not need reporting or have enabled it by mistake, then select your project in the app generator, choose Settings, select Reporting, and uncheck “Enable dynamic and static reports in my application”. Click Finish to regenerate the app. You may also consider refreshing all controllers to remove the reporting actions from the user interface.

If you do need built-in reporting in your app, then you need to install Microsoft Report Viewer on your deployment machine.

You will need the following files. It is advisable to download them on your personal machine and then copy them onto the server over Remote Desktop Connection (RDC).

  1. Microsoft Report Viewer 2012 Runtime
  2. Microsoft Web Platform Installer

Connect to your server via RDC. Copy the files into the Downloads folder of the server.

Installing SQL Server SQL Types

If SQL Server is not present on the server, then you will need to install Microsoft SQL Server 2012 CLR Types component.

Execute the Web Platform installer file by double-clicking on the “wpilauncher” file.

Executing the Web Platform Installer launcher executable.

When installation is complete, the Web Platform Installer will open. In the search box, type in “CLR” and hit Enter on your keyboard.

Installing MS System CLR types for SQL Server using Web Platform Installer 5.0.

Press Add next to the first item in the list, then press Install. Accept the license terms to proceed.

Installing MS System CLR types for SQL Server using Web Platform Installer 5.0.

Installing Report Viewer

Switch back to the Downloads folder. Double-click on the “ReportViewer” file.

Installing Microsoft Report Viewer 2012 Runtime.

Press Next, then accept the license to install Report Viewer.

This procedure will need to be done on both your development machine and your server.