Data blog — Manual RSS




Activation of Cherry City Software OLEDB Provider for MySQL

If you read my previous post, How to install MySQL Connection Provider, you know that installation of the provider is just the first step. Yes, you can test the connection, but any attempt to run a query against your MySQL database will result with error saying "MySQL OLE DB provider has not been activated".  I was stuck for a while with this error - it doesn't direct exactly to a resolution of the issue. I analyzed the code of SelectCompare and found nothing wrong with it. I googled for some information pertaining to the error message. I found some old pages that referenced the message, but no solutions.  This made me thinking - after all, if Google doesn't show relevant results, there must...

Continue reading



How to install MySQL Connection Provider

SelectCompare can connect to virtually any OleDB or ODBC data source. Once you have the connection provider installed, you can use SelectCompare to connect to respective database and compare its data with any other data set you wish. Data provider installation There is a number of different providers for MySQL. I used in this example one older, but still popular provider implemented by Cherry City Software. You can download the MySQL data provider from the download page. After you download the archive, extract its contents to a folder and run the setup. This is a pretty standard installation wizard. Follow the installation wizard until the installation is complete. You will have to have administrative rights on your machine to install...

Continue reading



Compare Excel Spreadsheets

Comparing Excel Spreadsheets - Why? Business and Data analysts, Developers and QA testers often have to verify their data is correct. Microsoft Excel is used to create a snapshot of "good data". Reports are captured and copied into Excel, data is exported and distributed as the model to use. SelectCompare allows you to compare Excel spreadsheets in the same way as other data sources. This post is going to show you the process of creating data connections to Excel workbooks and comparing data between two spreadsheets. Where do I start? First, you have to install appropriate driver to connect to the Excel workbooks. It is an easy step to get you up and running. Install drivers First thing is to install the...

Continue reading



SQL Data Comparison - User Manual

You visit this page because you know how to write a SQL query. Learn how you can use your expertise to do your work better and save your time! The Idea The SelectCompare idea is very simple: write an SQL query to extract data to compare on each data source. With SelectCompare, you create comparison projects that define data connections to each of the data sources and you write SQL queries for these data connections. You can create data connections separately from comparison projects, and reuse data connections in multiple projects. This is a quick manual that will show you how to compare data using SelectCompare. Step by step When you launch the program, you are presented with the page containing all defined comparison projects. Initially...

Continue reading