"DatabaseConnectionUI: Fix Server not always being disabled for Oracle
DatabaseConnectionUI & DefaultDatabaseConnectionUI: Ignore case for string compares
FrmMain: Eliminate try/catch for alias"
Add MacroStub.vms to the ClientLoader Project
Macro Stub with 100% error handling. This is needed for the Visual 10 VSCRIPT.dll scenario where the application window crashes on an unhandled exception during lib.ActivateObject() and no error is displayed.
"v1000.1007
- Resolve Invalid or Expired Credentials Key Exception when calling Client ExecuteNonQuery(), ExecuteQuery() or ExecuteScalar() directly from Macro before any other methods
- Server, Client & MacroEditor: ExecuteNonQuery(), ExecuteQuery() or ExecuteScalar() update to SoapHeader(""HeaderKey"") for Direction = SoapHeaderDirection.In Only (aka no ref)"
v462.1101 - Client Loader: ActivateObject handle when MacroVersion did NOT Exist before v908.1106 & return full stack if exception
"v1000.1006
- All: Merge AssemblyInfo.cs
- Client: Add MaxReceivedMessageSize property to override ServerLib Endpoint BasicHttpBinding MaxReceivedMessageSize in bytes (default 65536)
- Server: Update log4net to current latest version 2.0.14
- ConnectionConfig, MacroEditor & TestApp: Update App.config with notes & example:
<!-- Increase maxReceivedMessageSize if needed (default 65536 bytes) -->
<!--binding name=""ServerLibSoap"" maxReceivedMessageSize=""65536""-->"
Web.config - Remove staticContent for pdb (Removed in Client Loader v462.1100)
Add TODO
v462.1100 Client Runtime Loader - Add All Known AppContextSwitchOverrides for TLS & Update Commented Documentation
Notes for future enhancement
"TLS 1.2 Support
--Loader was failing in Job Queue [Synergy v10 Upgrade]
--Switch.System.Net.DontEnableSystemDefaultTlsVersions
Multiple Assembly DLL Loading (inner dependency) [Hunt Valve - Extended CUDF with SBO]
--changed to Assembly.UnsafeLoadFrom [uses the standard .net Cache in the GAC - by version]"
v1000.1005 - Ensure User & Database always .ToUpper() at lowest levels
v1000.1004 - Always Ensure User & Database ToUpper() for Oracle
v1000.1003 - Up both the Server and Client to match - need to tag solution, and have a common version
"v1000.1002
--Logon issue of not having UCASE on User ID
--Security Problem at Cox and Co
DGELLEN has R/O permission in Application
dgellen has full permission
Follow the same logic as VISUAL - ucase the user id - ALWAYS"
Fix the log4net config to default to "INFO", not "DEBUG"
"Include Log4net - Convert EventLogEntry to Log4net
Global.asax.cs - include Application_Error event
Revision bump for patch release"
Remove File.Exists(ConfigPath) - throw internal exception instead
v1000.1001 - Update Client to support No Default config - Set via ServerUrl
v1000.1001 - Update Web.config & Fix SelfInstall
v1000.1001 - Update for https (TLS)
"- Update Web.config: Add <httpRuntime targetFramework=""4.6.2"" /> (Remove Legacy), Handle UnobtrusiveValidationMode & Add Comment for security mode Transport for https
- ReportLoader: Fix Relative Path for Images WrongDB"
ClientLoader v462.1001 - Resolve adding symbolStoreName (pdb) assemblyVersion if passed
Set ServerLib.Endpoint.Address on Connect
"v1000.1000 (Massive Refactor, Reorganization & Clean Up)
- Upgrade to .NET Framework 4.6.2 (Convert Web References to Connected Services)
- Move CredentialCache.Purge to Global ApplicationTimer; Add Caching for ConnectionConfig
- Move InstalledPrinters & PrintServiceSubmitRequest to Launchpad ReportInfo *Break Change*
- Load symbolFile (pdb) if exists in ClientLoader.Managed ActivateObject()
- Add GetGridSelectedLineNumbers to Client lib"
Add VMSRunner ... still some work to do (Running at COX)
v908.1107 - Enhance DB & Add GetDB to ServerLib (Support replacing old DB_Interface)
Fix SqlServer-SqlConnection getting set twice
Ensure Web Path valid with AutoVer URL (if already includes ? then use & instead)
v908.1106 - Add MacroVersion to ServerLib & Update Loader to use for Auto Version DLL
"v908.1105
- Client: Obsolete ActivateObject, GetObject, SetObject (Call VTG.Loader.Managed via lib)
- Client: Add functions AddSqlParameter & AddOracleParameter"
Add Synergy Icon to Client Install 4.5
"v908.1104
- Add UseOleDB property to lib (util) when false it will use SqlCommand / OracleCommand
- Macro Editor: Fix / Enhance DatabaseTypeCheck for Oracle"
"Macro Server Hack - NON Compiled files can be deployed to ANY Macro Server
AppVersion.aspx --> AppVersion.cs
Commmon. MacroVersion Scripts/Common.vbs
Post Build for Release Kit
Note: Macro server should be running under 4.0 framework to avoid any errors related to the ""client DLL"" being built by a newer framework error.
Example:
dim taxInfo, dllPath
'Custom Form - Use the Version in Loader
'Make sure Macro Server has AppVersion.cs & AppVersion.aspx pages
dllPath = ""Synergy.Tax.CAKOrderTotalDialog.dll""
dllPath = dllPath & ""?"" & MacroVersion (dllPath)
loader.ActivateObject ""taxInfo"",dllPath ,""Synergy.Tax.MacroInterface""
set taxInfo = loader.GetObject ( ""taxInfo"" )
'Lookup dll relative to SRIMacroServer folder
'E:\Visual\LocalApps\webservices\SRIMacroServer
'E:\Visual\LocalApps\webservices\SynergyTax\SynergyTax\bin\HttpPostHandler.dll
taxVersion = MacroVersion ( ""../SynergyTax/SynergyTax/bin/HttpPostHandler.dll"" )
taxInfo.AvalaraTaxVersion= ""Avalara: "" + taxVersion"
Release kit was missing the Common VB Script "Scripts"
Add Client Runtime 4.5 Installer & Update Web.config for Integrated Pipeline (Classic Pipeline Commented)
"v908.1103
- MacroScriptDA: Update SAVE_DATE limit DateTime to only 3 milliseconds (Resolve MSOLEDBSQL OleDbException)
- MacroScriptDA: Update SQL Server OleDbCommandBuilder with ConflictOption to OverwriteChanges (Use Primary Key)"
"v908.1102 - Add SqlServerOleDbProvider & OracleOleDbProvider overrides; Update obsolete MSDAORA to OraOLEDB.Oracle
- Remove Sql Base from Connection Config; Update default connection config with DGTEST (Oracle) & creds key"
v908.1101 - Sync updated Blind User Password with SBO v908.1118
"v908.1100 - Upgrade to .NET 4.5 to support TLS 1.2 including OLE SQL Provider update from SQLOLEDB to MSOLEDBSQL
- Removed SQLBase & Resolved Encrypt append typo"
Remove NextNumberGen (Obsolete - Single Site Only); Clean Up: DB, UserCredentials & Client lib
Remove Server LicenseManager
Remove Licensing; Clean Up: ConnectionConfig, CredentialCache & ServerLib
Add GetBlindUser DbVersion override & Fix Comments
Remove Unused Content
v908.1000 - Add Support for SSO (Single Sign On) with VMPWD 2.1
"MacroServer revision bump to 907.1000 (for release)
All projects within solution have post-build events to create ReleaseKit proper.
- Keep a ""Copy"" of ReleaseKit folder or unzip ""Tag"" .zip before building code changes & creating a new tag so full ReleaseKit goes up when tagged using SVN Helper"
"Refactor & Remove SQLBase
Wrap Connection, Command, and DataAdapter in using() to ensure Dispose
Update SaveMacro to proper Insert/Update/Delete (rather than Delete All & Re-Insert)"
Remove Debug/bin from Project Directories
Fix VTGMacroServerInterface Relative Reference Hint Path
Fix Warnings, Auto Connect Dialog on Load, Call ServerLib.DeleteMacro on Delete (instead of Save)
Fix Warning
Fix NewManagedCommand creating unused Connection
Fix Option Explicit key words
This is active in EVERY installation
"Removed DAT File test
v905.1000"
Add Post Build event for VTG.Loader.dll that copies to ReleaseKit
"903.1002 - Menu Password change
--Exclude uint response = 0 on GetModuleFileName
--Illegal characters with zero length"
"Add debugging for Illegal character in path error
--Catch ArugmentException, and show the path in error message"
"Loader built under .net 4.0
Bubble up inner exception
Allow constructor arguments
provision for Assembly version to force reload when DLLs are cached locally."
Tested macro client against 903
"ServerLib.asmx - Remove use of MD5 to when creating Hash. Use Random Number Generator instead - still creates 16 size byte array but doesn't cause issues with FIPS being on or off
- Keeps compatibility with ConnectionConfig & MacroEditor application
lib.cs - Revert Authenticate() method and AuthenticationHash properties and use Dave G's Password retrieval through macro (adding VMPWD.cs)
Misc: Add to VTGMacroClient PostBuild to copy VTG.Macro.Net.dll to VTGMacroServer root directory (for testing)"
removed zip, not needed for source
"MacroServer - Adding ""Loader"" project
--Reconfigured source to use Trusted Key in the project file (not the AssemblyInfo.cs)"
"Commented section for ""hidden button"" - functionality was never fully implemented....the btn is not visible to the end user
Macro Server does not have webmethod named: CreateNamedTrustedKey
--History Look at Revision: ServerLib.asmx.cs changes 154
If we need to revert changes to bring this functionally back create test plan based on data found in version 163"
- ConnectionConfig Project - Update web references in project to point to Serverlib from macro server project
- Move assemblies to new versioning scheme (901.1000.*)
TODO: Find and put VTG.Loader source in"
Final Check-in before Release Kit for MacroServer
SVN cleanup
"--ONTIME INTEGRATION, DO NOT TOUCH!--
[otf:709] [otd:767]
--ONTIME END OF INTEGRATION--
- Ignore logic to validate .dat license if MachineName is null
- #User Password cracked if UserName is longer than 12 characters
Update Repository to latest Tortoise SVN supported version"
Re-commit w/ proper VTG.Macro.Net.Client project
"VTGMacroClient:
• Lib.cs - GetSqlServerInstanceName() – added method to get the instance name from authenticationKey
• Lib.cs - Authenticate() – method authenticates classic way if 700 (because –U,-D, -P are present) or new way if they aren’t
• Lib.cs - GetPassword() – Fix for password not being returned from macro
VTGMacroServer:
• Serverlib.asmx - GetSqlServerInstanceName() – method to return Instance name from key
• DB.cs – DbVersion – property added to get Visual version number (700 and prior or 71x and above)
• DB.cs – GetDBVersion() – Method that queries APPLICATION_GLOBAL for DBVersion and returns to DbVersion property
• DB.cs – BlindCredentials – GetBlindUser(string UserName, string DbVersion) – New constructor which looks at DBVersion. If DBVersion is 710 and above, do not truncate username before adding # symbol"
**Added option to create credentials key without blind user Connection
"Added VQ Support - Connect to VQ, Test for VQ, Re-Connect to VM based on XRef db Name
**Added option to create credentials key without blind user Connection"
"Added config setting for extending the Command Timeout (Default 30 Seconds)
--<add key=""CommandTimeout"" value=""50""/>"
I stink
Remove ConnectionConfigKeys web method
Initial Source Load
"SRIMacroServer Standard SVN Folder Creation
***Entry made with SVNHelper.exe***"