Easy way to check the connection to the MS SQL Server

January 17, 2018 Milan Matejic1 Comment

After the installation of Microsoft SQL Server, to make sure that the instance can be accessed by the other software, like IBM Traveler, a simple “UDL Test” can be done. This is very useful in Windows environments, due to the fact that you do not need to install any extra software like IBM Data Studio or MS Management Studio.

Just create a new file with “.udl” extension. After that, just open the file by double-clicking it.

After that you can enter the server and instance name, or just select it. Then you can test the credentials you intend to use for the application. You can even specify the Database you want to connect to.

There are many more settings to choose, but for a simple test I never needed anything else than described above.

IBM Champion Nominations

October 29, 2017 Milan MatejicLeave a comment

IBM Champion Nominations are open until 13th November, so make sure you nominate all your favorite community members.

More information about the program:

URL for nominations:

https://developer.ibm.com/champions/nominate/

Deleting Port numbers from LotusConnections-config.xml File

August 19, 2015 Milan MatejicLeave a comment

Short after installing Connections I always delete the port numbers or change the URL completely in the “LotusConnections-config.xml” file so that Connections Applications could be accessed without typing the port numbers as a part of an URL.

Doing this manually can consume lot of time.

You can automate this process by using the replace function in “Notepad ++” or “UltraEdit” editors as described in following.

Notepad ++