Soepermen si "Super Hero"

Solution: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine Today, after I uploaded one of my ETL data integration components (written in C#) from local 32-bit Windows System to our server environment which is running on Windows 2008 R2 64-bit system, my application blew up with the following error message: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. The reason for this error is, I used Jet database engine in my ETL component to read Excel file, but the Jet library was not designed for 64-bit system. The community has been suggesting to compile the code to target to x86 platform in order to cope with this issue, which is something I was reluctant to do for the obvious reasons. It's also the primary motivation that I am blogging about this issue. Further Google search indicates that Microsoft has released a 64-bit compatible Jet database engine last year. The following is the procedure that you may...

  Microsoft Windows [Version 10.0.15063] (c) 2017 Microsoft Corporation. All rights reserved. C:\Users\PSI011>cd C:\xampp\mysql\bin C:\xampp\mysql\bin> mysqld 2017-08-22 14:24:49 15428 [Note] mysqld (mysqld 10.1.25-MariaDB) starting as process 16352 ... C:\xampp\mysql\bin> mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.1.25-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use pkh; Database changed MariaDB [pkh]> LOAD DATA LOCAL INFILE 'D:/2017/PKH_FOR_BPKP/PKH_FOR_BPKP_01.csv' -> INTO TABLE pkh_bpkp -> FIELDS TERMINATED BY ',' -> OPTIONALLY ENCLOSED BY '"' -> ESCAPED BY '"' -> LINES TERMINATED BY '\n...

http://pentaho-bi-suite.blogspot.co.id/2015/03/kettle-etl-basics-5-command-line.html In this post we will see the basics of how to schedule a Job in Windows environment using "Windows Task scheduler". Prior to scheduling jobs or transformations either in linux or windows one should know how to execute jobs/transformations from command line by passing arguments or parameters or variables. 1) Design & develop transformation or job. 2) Make transformation or job dynamic using parameters or variables. 3) Execute the transformation or job from command line by passing parameter or variables. 4) Prepare a list of commands in a batch file. 5) Schedule the .bat file in windows using "Task Scheduler" Tool. http://wiki.pentaho.com/display/EAI/Kitchen+User+Documentation#KitchenUserDocumentation-Scheduling

Gegara alter table, mengubah lebar kolom pada tabel mysql, karena ukuran data lumayan besar jadinya luamaaaa buangeeettt processnya. Ya sudah akhinya di interrupt saja (cancel) querynya. Caranya gimana? Berikut stepnya ya... 1. Access the MySQL Server from the shell prompt using the following command: mysql -u <user> -h <server> -p <password> Replace "<user>," "<server>" and "<password>" with the appropriate credentials. 2. Execute the command "show processlist;" (without quotes) to see the threads active for each user or those running under your own account. 3. Refer to the Time field to determine how long the thread has been active. Execute the following command to kill the long-running query: kill <#>; Replace "<#>" with the ID associated with the applicable thread. Microsoft Windows [Version 10.0.15063] (c) 2017 Microsoft Corporation. All rights r...