Oct 30 2013
Bit of a narrow topic but thought I would share given that I couldn’t find a solution on the web. I use Crystal Reports as part of my work in conjunction with databases and Business Objects Enterprise and usually everything works without hiccups. However, I’ve built a couple of reports recently that ended up with …
Apr 01 2013
If you’ve been following the blog then you might remember that I have had a couple of failed attempts (first article and second article) at getting connectivity going between an Oracle database as a source and a Microsoft SQL Server database as a destination. Not to be dissuaded from finding a solution I have found something that I have …
Feb 07 2013
Here’s another quick tip for Microsoft Office – this time for Microsoft Access for you budding database experts. If you lock down your database and prevent users from navigating its objects then by default nothing will show up when the database is loaded. Similarly, if your users are using the Microsoft Access Runtime (a cutdown …
Sep 29 2012
Earlier this week, I shared my intention to try and use Attunity to satisfy my requirement to get MS SQL Server to connect to Oracle to facilitate the transfer of data from various databases. Unforuntately for me this idea was stopped in its tracks because the Attunity connectors are designed to be used with MS …
Sep 27 2012
For a little while now I have been trying to get MS SQL Server 2008 R2 on Windows Server 2008 R2 64-bit to connect to an Oracle 10g database but have run into some issues doing so with some other more complicated solutions. My approaches to date have involved extra Oracle client software and working …
May 27 2012
A slightly more technical article for today but something worth mentioning. At work, I am attempting to get a direct connection between MS SQL Server 2008 and an Oracle database. Some might say that such connectivity would bring about the end of the world or a hole might open in the ground and swallow me …
Aug 02 2010
Just a quick blog before I hop on a flight back to Helsinki. One thing I noticed in Denmark was how they labelled floors in buildings, particularly when it came to labels in elevators and around escalators. Unlike what www expect in Australia, the ground floor is marked as “zero” with floor above it incrementing …
Follow Us!