To get SSIS working for a SQL Server 2005 environment
Acquire SQL Server 2005 (x86 or 64 bit) images.
Mount the second disk and launch the installation wizard
"Next" your way through the dialogs until you see see this screen.
Under Client Components, ensure Business Intelligence De...
Since there is no STRING_SPLIT function we need to use XML hack to split the string into rows:
Example:
SELECT split.a.value('.', 'VARCHAR(100)') AS Value
FROM (SELECT Cast ('<M>' + Replace('A|B|C', '|', '</M><M>')+ '</M>' AS XML) AS Data) AS A
CROSS apply data...
Check for a Firewall issue blocking port 3306.
Some possible diagnostics and/or solutions
Is the server actually running?
"service firewalld stop" and "systemctl disable firewalld"
telnet master 3306
Check the bind-address
check skip-name-resolve
check the socket.
This shows how to create the demo database used in big parts of Progress documentation: sports2000.
This assumes you have installed the Progress products with at least one type of database license.
Run proenv script/bat-file that will give you a prompt with all environment variables set.
Create ...
All images are from UK versions of Outlook. I know that some names are translated into the local language for other versions and I assume that most of the names for the tabs are translated. Probably the sequence of tabs is unchanged in non-English versions. Alternatively, you will need to look at yo...
All images in this section are from the UK version of Outlook 2016. I know that some names are translated into the local language for other versions and I assume that most of the names for the tabs are translated. Probably the sequence of tabs is unchanged in non-English versions. Alternatively, you...
Once the sports2000 database has been installed it's time to run it as a standalone server (and not connect to it as a file).
Start proenv (proenv in the startmeny on Windows or /usr/install-directory/bin/proenv on Linux/Unix).
This example is from Windows. Linux is the same but you need to change...
The following features added in SQL Server 2000 from its previous version:
New data types were added (BIGINT, SQL_VARIANT, TABLE)
Instead of and for Triggers were introduced as advancement to the DDL.
Cascading referential integrity.
XML support
User defined functions and partition views.
In...
