Showing posts with label Move. Show all posts
Showing posts with label Move. Show all posts

08 April 2024

How to move in insert mode in vim?

https://vi.stackexchange.com/questions/10296/navigation-in-insert-mode


If you just need to modify a small amount of text or a word, you can use <Ctrl-O>h/j/k/l.

<Ctrl-O> takes you back to Normal mode just for that command, and then drops you back into insert mode, so it saves you some amount of key presses, if you need to go into normal mode for a small movement.

24 March 2016

Instructions on how to download and connect your server with ms sql database

1) please download the migrated database from the provided link.
2) In the zip folder you will find MDF and LDF files. Please attach it to your mssql server.
2) On the SysAid server, please go to servics.msc and stop the sysaid server service.
3) Go to SysAidServer\root\WEB-INF\conf folder,locate the file called "serverconf.xml" and edit it with notepad.
4) Find the following lines:

<dbConf>
<dbDriver>org.apache.derby.jdbc.EmbeddedDriver</dbDriver>
<dbUrl>jdbc:derby:default</dbUrl>
<dbUser>sysdba</dbUser>
<dbPassword>masterkey</dbPassword>
<dbType>derby</dbType>
<dbEncoding>utf-8</dbEncoding>
<dbMultiply>false</dbMultiply>
<dbMainName>ilient</dbMainName>
</dbConf>

And replace them with these lines :

<dbConf>
<dbDriver>net.sourceforge.jtds.jdbc.Driver</dbDriver>
<dbUrl>jdbc:jtds:sqlserver://"replace this with your database server's IP:1433/"replace this with the database name"</dbUrl>
<dbUser>"replace this with the database user name"</dbUser>
<dbPassword>"replace this with your database password"</dbPassword>
<dbType>mssql</dbType>
<dbEncoding>utf-8</dbEncoding>
<dbMultiply>false</dbMultiply>
<dbMainName>ilient</dbMainName>
</dbConf>


5) Once you finished to edit this file, save it, and close it.
6) Go to services.msc and start SysAid server service.
7) Make sure that you are able to log into SysAid.

* Please note that it is best to use the "SA" user from the database server, since this user is usally not restricted by any password policies of the organization.
* Also it is best to have the database owned by the "SA" user.