ODBC Data Provider

ODBC Data Provider no longer connects after upgrading to macOS X Ventura 13.3

After upgrading to macOS X Ventura 13.3, the ODBC Data Provider will no longer be able to connect to the database, reporting a message such as ‘Driver’s SQLAllocEnv() failed’.  This is due to a change to security permissions in macOS, and should now be fixed in the 18.0.1 version of EasyCatalog for Adobe InDesign 2023.  […]

Adding user defined parameters to an ODBC data source

ODBC data sources normally use a hard-coded query to retrieve data.  However, EasyCatalog allows elements of the query to be user definable or ‘parameter’ based.  These parameters are shown on the ‘info’ dialog box, accessible from the binocular icon on the data panel.  Any changes made are applied the next time the data is synchronized. Parameters are […]

Is there any way to work with smaller sets of ODBC-based data?

ODBC Data Sources can be configured to accept parameters which are included as part of the data-retrieval SQL. Parameters should be placed in {{ braces }} for example:

This will create two parameters that user can change: “Name” and “No Of Records”.  Up to five can be specified. The values for these parameters will be […]