Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I link a4gl with Informix CLI ODBC driver, without using any ODBC managers?

April 26, 2017CLI driver Informix link managers ODBC

0

Posted

How do I link a4gl with Informix CLI ODBC driver, without using any ODBC managers?

1 Answer

0

Posted

This allows for specifying the data required to use the Informix CLI (I’m using Informix Foundation 2000). The .a4glrc file then has these entries : ODBC_LIB_NAME=ifcli ODBC_LIB_DIR=$INFORMIXDIR/lib/cli export ODBC_LIB_NAME ODBC_LIB_DIR Informix still needs a .odbc.ini file – so it should be possible to connect to any datasource from the Informix CLI and vice versa (making previous discussions about ODBC managers pretty irrelevant!) my .odbc.ini file: [ODBC Data Sources] Informix7=Informix 7.x ODBC Driver ; ; Define ODBC Database Driver’s Below – Driver Configuration Section ; [Informix7] Driver=/disks/disk1/informix/lib/cli/iclis09a.so Description=Informix 7.x ODBC Driver Database=stores7 HostName=dax LogonID=informix pwd=informix Service=sqids7 Protocol=onsoctcp Servername=ids7 So, you can link a4gl to CLI, and connect to PostgreSQL, just by defining a section in .odbc.ini, although I have not tested this.