Purchase and Register InfoCaptor Enterprise Dashboard

Once you purchased the license and have installed the software you need to register the license information. The license information contains two pieces as below ‘38292EeueweuQwee’ , ‘myorderemail@somedomain.com’ The first piece is the internal order number and the second is the email address you purchased the license with. Login to InfoCaptor as admin and then … Read more

Excel ODBC DSN connection string with PHP

When using Excel ODBC with PHP please use the following settings All settings are done in the connection_methods.php Windows 7 and Excel 2007 (support for .xls, .xlsx, .xlsm, .xlsb)   $db_url=”DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};FIL=Excel 12.0;DriverID=1046;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text”;   Windows XP and older Excel (just .xls)   $db_url=”Driver={Microsoft Excel Driver (*.{$fileinfo[‘extension’]})} ;DriverId=790;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text”;

Excel Cell Ranges using SQL – Named – Unnamed – ODBC – JDBC

How to query Excel files using ODBC – JDBC? Summary : Why use square brackets for SQL against Excel? How to access range of cells from Excel? How to use un-named range of cells? This topic is covered in various tutorial for InfoCaptor. These following snippets are taken directly from Microsoft website as easy reference … Read more

JDBC with SQLserver – Connection refused: connect

If you are trying to use SQLserver with InfoCaptor and are using the SQL Studio Express 2005 then you might encounter connection refused error Please try the following setup before attempting to connect open the Configuration Manager Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager 2. Then at the … Read more