COMPOSE Programming
Modified on Saturday, 14 September 2024 16:15 by blarke@energianalyse.dk — Categorized as: Uncategorized
Recreation 2024 710q:
Delphi 2010 Architect
JEDI Debug
GExperts
Programming infrastructure:
Delphi 2010 Architect
MS SQL 2008 R2 for remote data
SQL 2008 Native Client
Microsoft Access 2007 File Format ACCDB for local data
Microsoft Access Database Engine 2007 Redistributable
Filezilla FTP Server Remotely
Optimax.dll
- license required for non-academic users
Open Source Solvers:
CoinMP.dll
,
LPSOLVE.dll
,
GLPK
- integration with CPLEX and GUROBI with custom parameters.
Mathwave SDK for statistical analysis and risk distributions
Woll2Woll InfoPower
Raize Components
ScrewTurn integrated WIKI
TMS Flexcel for non-OLE spreadsheet handling
TMS Diagram Studio
JEDI Debug
TurboPower Abbrevia
for compressed file handling.
DCPCrypt
for password handling.
Supporting infrastructure:
IDE Fix Pack
CnPack IDE Wizards
GExperts
AutomatedAQ's AQTime and Build Studio
InnoSetup Quickstart Pack with ISTool script editor and InnoSetup Preprocessor
RedGate SQL Compare and SQL Data Compare
Camtasia - so far, for COMPOSE TV
Adobe Connect - for webinars
Service Manager on Server
WMware Workstation
for testing on
Windows 8/10
Server Requirements:
Microsoft SQL Server as default instance on port 14016 allowing remote IP (
Setting default instance
).
FTP server on port 21 with write access to c:\ftps\compose
Flowdiagram:
Build CBs
Build Demands
CalcProcesses
Optimize Project
CalcResults
Server Setup
Install SQL server, mixed authentication
Rename sa account
Firewall inbound 14016
Router port forward 14016 to host
Set SQL Server Configuration Manager Login as Network Service
Set SQL Server Configuration Manager TCP/IP protocals port 14016
Copy backups and restore cdb, cdbid, energyinteractive
Run autofix on users on ALL three databases
USE EnergyInteractive
GO
EXEC sp_change_users_login 'Auto_Fix', 'username', NULL, 'password'
GO
Make user bulk admin
Install filezilla server
Copy the two zilla xml files to server folder
Open firewall for filezilla program
create folder ftps/compose
Copy test.dll to ftp folder
Copy networktest.sql to ftp folder
install, source, backup not beskrevet
Copy COMPOSE folder minus cdb? Location important?
Setup webserver EnergyInteractive?
MSSQLSERVER must have read access to bulkfolder, either FTP folder or user temp folder for local operation "c:\Users\pc\AppData\Local\Temp\COMPOSE\"