Category Archives: Uncategorized

Database Server hosted on a Raspberry Pi!?

This is crazy stuff here, but it’s an interesting concept: http://www.mysqlperformanceblog.com/2013/02/25/percona-server-on-the-raspberry-pi-your-own-database-server-for-under-80/ I can see many low-cost industrial uses for this.  As a data historian for example on a manufacturing line, or collecting data from scientific instruments.  Perhaps running a cluster … Continue reading

Posted in Uncategorized | Leave a comment

Using ODBC

In my experience, one of the most frequent data-related helpdesk calls is for ODBC errors. ODBC is a way to connect Microsoft Access and other Office products to a database such as SQL Server.  You can set your ODBC connections … Continue reading

Posted in Uncategorized | 1 Comment

ODBC Errors in Access 2007 32-bit running on Windows 7 64-bit

Found a fantastic article explaining and fixing a problem I have seen many times as of late: http://www.networksteve.com/enterprise/topic.php/On_Windows_7_%2864-bit%29:_How_to_use_MS_Access_2007_to_link_to_Orac/?TopicId=24924&Posts=0 here’s a link to a MSDN question on the same subject: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/ab662d63-6385-4f73-b27f-d526048f601f/  

Posted in Uncategorized | 1 Comment

Free resources for the web and other media

Over the years I have accumulated a number of resources for creating new websites.  These are a few of my most-used: This is a collection of public domain photographs covering numerous subjects http://pdphoto.org/ For icons I use several resources, but … Continue reading

Posted in Uncategorized | 1 Comment

Need to convert .NET data types into SQL data types? Here ya go..

I was conversing today with Patrick about a project he’s working on that involves data quality checks on CSV files.  He’s working on a component to determine SQL data types of the imported columns and I suggested maybe somebody already … Continue reading

Posted in Uncategorized | Leave a comment