Installation: tar xvzf apache-tomcat-7.0.2.tar.gz -C /usr/tomcat7 cd /usr/tomcat7 mv * .. cd .. rm -rf apache-tomcat-7.0.2.tar.gz edit tomcat-users.xml and put: <role rolename="manager-gui"/> <user name="nista" password="kookoo" roles="admin,manager,manager-gui" /> Optional Step: change…
Create 2 files: GetMP3.BAT and getMP3.DAT. In GetMP3.BAT: ftp -n -i -s:getMP3.DAT and in getMP3.DAT: OPEN 192.168.131.50 1212USER NISTA11111BINARYHASHCD files\INLCD C:\incomingFTPMGET Products.txtbyeFTP switches:FTP [-v] [-d] [-i] [-n] [-g] [-s:filename] [-a]…
How to modify the registry: Attribute VB_Name = "modRegistryChange"Option ExplicitPublic Declare Function RegOpenKeyEx Lib "Coredll" _ Alias "RegOpenKeyExW" _ (ByVal hKey As Long, _ ByVal lpSubKey As String, _ ByVal…
How to open a program using its default application: Private Declare Function ShellExecuteAny Lib "shell32.dll" Alias "ShellExecuteA" _(ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _ByVal…
Using SQL Server connection: Dim cn As New ADODB.ConnectionDim rs As New ADODB.RecordsetPrivate Sub Command1_Click() cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; pwd=sales;Initial Catalog=Sellout;Data Source=ATLAS-LAPTOP\NISTA" cn.Open Dim TheString As String TheString…
At the bottom of the database you will find a sample MS Access Database for training in SQL.It is supposed to be a food company. It has 5 salesmen.The invoices…
The following code produces a sample function in MySQL: CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTICRETURN CONCAT('Hello, ',s,'!');
VI Editor commands: Use [escape] key after completion of every input task! [ctrl]-F Move forward one screen.[ctrl]-B Move backward one screen.$ Move cursor to end of line.^ Move cursor to…
Linux: To find files like *.rdf in the path /oracle/erptd/appl: find /oracle/erptd/appl -type f -name *.rdf -print 2>/dev/null Note1: .rdf is the extension for Oracle Reports, Note2: 2>/dev/null to drive…
