SQL XOP

SQL XOP has shipped with Igor Pro since version 6.10 beta. You should no longer download this version. Instead, use the version of the XOP installed by the Igor Pro installer.

SQL XOP provides access to relational databases from IGOR procedures. It uses ODBC (Open Database Connectivity) libraries and drivers on Mac OS X and Windows to provide this access.

SQL XOP (file name SQL.xop) was created by WaveMetrics in 2007 and first released in 2008. It is unrelated to SQLXOP (file name SQLXOP.xop) which was created by Bruxton Corporation in the 1990's and which runs on Windows only.
 

Project Details

Current Project Release

SQL XOP IGOR.6.03.x-1.00-B02

Release File: SQL_XOP_100B02.zip (458.7 KB)
Version: IGOR.6.03.x-1.00-B02
Version Date:
Version Major: 1
Version Extra: B02
Version Patch Level: 0
OS Compatibility: Windows Mac-Intel
Release Notes:

Beta release. This is the same as what will ship with Igor Pro 6.10B01 so if you have that or later, you already have the necessary files.

Changes in this release:

Changed the default behavior of /PWAV and /PVAR to treat a NaN value as a NULL value. This was done because neither MySQL or MS SQL Server handle NaNs well. MySQL treats NaN as zero. MS SQL Server returns an error: "not a valid instance of data type". You can override this, to treat a NaN as a NaN, by specifying /OPTS=2.

Fixed a crash that occurred if the server returned SQL_SUCCESS_ WITH_INFO instead of SQL_SUCCESS when fetching data into waves.

Fixed SQLHighLevelOp to treat SQL_SUCCESS_WITH_INFO as a success rather than a failure.

Added a workaround for Actual Technologies driver which does not support SQL_ATTR_ROWS_FETCHED_PTR. However Actual Technologies says they will add support for it in the near future.

 
View All Releases
Windows Mac-Intel Utilities

Forum

Support

Gallery

Igor Pro 10

Learn More

Igor XOP Toolkit

Learn More

Igor NIDAQ Tools MX

Learn More