Sylvain Cyr

Dev blog

  • DBF viewing

    It happens as programmers that we have to deal with older database formats. If you are in need of a dbf viewer, DBFPlus at http://www.alexnolan.net/software/dbf.htm does the trick. It saved me a lot of time today.

  • MySQL – Reminders

    Get the list of users SELECT User FROM mysql.user; Add new user CREATE USER ‘user’@’host’ IDENTIFIED BY ‘password’; Create a database CREATE DATABASE databaseName CHARACTER SET utf8 COLLATE utf8_general_ci; * specify the character set and also the collation. Remember that stored procedure are created with the collation the database has and it will remain the…

  • .Net C# Crystal Report / MySQL ODBC

    Like many out there, I use Crystal Report for invoices and other kinds of report. What I like doing is exporting the result as a pdf on disk. I just got a new laptop so I installed visual studio, mysql drivers,crystal report, etc… If you have used Crystal Report for a while, you might have…

  • Migrating from MSSQL Express to MySQL

    I’ve been busy this last 2 weeks working on a big enough migration from MSSQL Express to MySQL. It’s been long and somewhat complicated process if you consider the pitfalls. Here is part 1 on the migration process. Part 2 will be on the reasons you should think it through before actually doing it. Just…

  • Crystal Report – maximum report processing jobs limit

    If you encounter the following error… CrystalDecisions.Shared.CrystalReportsException: Load report failed. —> System.Runtime.InteropServices.COMException: The maximum report processing jobs limit configured by your system administrator has been reached. Make sure you do the following after you are done with the report object…. report.Close(); report.Dispose(); It will probably save you some time.

  • C# Add excel export feature to app.

    Either it’s a web or desktop application, users have tools that they use and as developers we should make working with these tools easier. Most users use Excel in their daily life when working with data. I think when the option to actually generate an excel file is available we should make use of it…

  • I was annoyed with passwords ? I’m not anymore.

    Hi everyone, Couple of months ago I got really fed up with passwords. If you deal with many websites, it can get to dozens of different passwords. Off course, If you actually have different passwords for each of them. Let’s be honest, I was actually guilty of using the same one over and over. I…

  • Linux Mint 17 – Dell Inspiron 17 7737 – Trackpad

    Hi everyone, If, like me, you have a Dell Inspiron and have Linux Mint installed (Or Ubuntu) and have problems with your track pad when scrolling or dragging windows,  consult this page : http://www.penguintutor.com/news/linux/dell-trackpad-ubuntu. It will save you from going insane. In short, just go in the terminal and type the following: 1) sudo mkdir…

  • Windows server SBS2011 – Backup problems

    If you are having issues with Acronis Backup and Recovery 11.5 and Windows SBS 2011 or Windows 2008 (including R2), it might be related to your hard drive. Take a look at this page for the support hard drive on Windows : http://support.microsoft.com/kb/2510009 First thing you realize is that 4K (4096 bytes)  per sector is…

  • Utilities and tools

    I’ve been looking for inspiration for days now. I have some domains and haven’t done anything with them. It just bugs me. I accomplish a lot at work but this is my own personal stuff and I feel kind of guilty about it. And tonight it came to me. What I have been doing lately…

Got any book recommendations?

Get In Touch