ODBC Data Provider
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}} This will create two parameters that user can change: “Name” and “No Of Records”. Up […]
Exporting a CSV file from an ODBC Data Source in EasyCatalog
A CSV file can be exported from an EasyCatalog Panel that is using an ODBC Connection by holding down Shift + Alt and selecting…
ODBC Data Provider not loading on Macintosh
The following only applies to versions CS5.5 and below…
ODBC Driver architecture mismatch
InDesign CC installs as a 32bit and 64bit version on Windows, so a 32 or 64bit ODBC data source needs…
Setting up a FileMaker datasource
Open the ODBC Administrator found in ‘Applications > Utilities’ and select ‘Add’, this will bring up a dialog listing…
Setting up EasyCatalog to use an ODBC data source
Setting up EasyCatalog to use an ODBC Data Source is a straight forward process aslong as the data source has been configured correctly…
Which ODBC Driver should I get?
There are many ODBC Drivers out there on the market both free and commercial; here is a list…