In the last couple of weeks I have been working a lot with different databases which I had to connect to from Java. It is sometime stressful to look up the right format of the connection string to the database. Even though, these strings should, or are meant to be standardized, they are not.
I found this very helpful website ConnectionStrings.com which lists the connection strings for open-source as well as professional commercial databases. This list includes among others, the connection strings for Microsoft SQL Server 2008, MySQL, Oracle, IBM DB2, Informix, Postgre SQL, Caché, SQLite, …
I want to share this information with you, because it can save you a lot of time, looking up those strings in tutorials or in the documentation of the different databases. Continue reading ‘SQL Connection Strings’
Wie versprochen werde ich auch mal auf Deutsch bloggen, also hier mein erster deutscher Blogeintrag: Diese Woche habe ich mir ein neues Spielzeug gegönnt, das Nokia E51. Ich will an dieser Stelle nicht unbedingt über die Vorzüge des Nokia E51 referieren und das Handy im Detail erklären, vielmehr will ich ein kleines Tutorial bereit stellen, wie man einen VPN Client auf dem Nokia E51 installiert und wie man sich mit einem VPN Netz verbindet. Da ich für die Installation und Konfiguration des VPN-Clients keine ordentliche Beschreibung im Internet gefunden habe und einige Zeit investiert hab, dachte ich mir ich schreib dieses Turorial inkl. Screenshots um Ihnen die Installation zu erleichtern.
Continue reading ‘Nokia E51 - VPN Installation Tutorial’
This post contains a downloadable version of my Bachelor Thesis I wrote to complete my studies in computer science at the Technical University Kaiserslautern. The thesis was conducted externally at the Product-Line Engineering Department of the Fraunhofer Institute for Experimental Software Engineering in Kaiserslautern.
Continue reading ‘Evaluating the Architectural Coverage of Runtime Traces’
In this post, I present you a tiny program to send SMS messages through the internet:
SMSing is a simple client/server based application to send SMS text messages through the Internet using Clickatell as service provider. The application supports multiple users, credits, logging aso. In the current version, SMSing should not be used in a productive environment, but shall demonstrate how to use and combine different technologies to send SMS´s. Nevertheless SMSing is really interesting for people sending lots of SMS who are bored to type the text using the keyboard of their mobile phones and pay the high prices of their mobile providers. SMSing even allows you to send anonymous messages, or messages with fake sender-number.
Continue reading ‘SMSing - SMS client and server’
I use this post to present you one very simple but effective program to monitor static web pages and to send you an SMS message in case of changes on the website. I called the tool WebsiteWatcher:
WebsiteWatcher allows you to monitor a specific (static) website for changes. If the page is updated, you immediately get an SMS message as notification. This tool was initially used to monitor university websites where results of exams were published. Please notice that this simple tool only works for static pages. Clickatell is used as SMS provider. It provides a reliable, fast and cheap SMS-gateway for 578 networks in 192 countries.
Continue reading ‘WebsiteWatcher - An easy to use website monitor with SMS notification’
OUTDATED: This software is a PHP class to grab the latest stocks from Yahoo Finance, and to cache them optionally. To gather data regularly, you can use a crownjob. If you are using Linux type crontab -e on the shell. Then insert the following line (adapt the paths) to your crown file
* * * * * /usr/local/bin/php /home/marc/yahoo.stocks.class.php
and the cron-deamon will execute the script every minute, thus collecting the stock data.
To download the class click 
right here (do not forget to rename phps to php).
OUTDATED: PHP-RealtimeStats gives the visitors of your website the possibility to see how many users are online and where they come from, based on an IP to country database. Furthermore you have the possibility to display the ICQ-status of the webmaster and to log the country, host, browser and referrer website of your visitors. The script is designed function-based so that it can be easily integrated into the design and the structure of your website. PHP-RealtimeStats is delivered with many example files and over 200 flags of different countries. Some functions may even be integrated into a remote website using JavaScript.
Continue reading ‘PHP-RealtimeStats 1.0 - Easy and flexible function-based live stats for your website’
