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 […]

I’ve just upgraded to InDesign CC and my ODBC data source isn’t working

InDesign CC is a 64bit application, whereas previous versions were 32bit. As such a 64bit ODBC driver is required, which needs to be configured in the ODBC Administrator. 32bit only drivers will not work in a 64bit application.

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:

SELECT * FROM customers WHERE name LIKE '%{{Name}}%' LIMIT {{No Of Records}}

1	SELECT * FROM customers WHERE name LIKE '%{{Name}}%' LIMIT {{No Of Records}}

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 […]