ODBC Connection ? 1

[cdlvj]

Have UNIX server with Informix 9.2 IDS, my question is does some sort of service need to be running to handle ODBC connections? Or is that built into the Core DB.

 

[vpshriyan]

Hi,

The threads below points to setting-up the drivers & configuration of ODBC related parameters at Back-end & Front-ends:

thread876-409375
thread179-630445

Regards,
Shriyan

 

[raviaute]

There is no need of a special service to accept ODBC connection request. When the Informix server instance is running, it is ready to accept the client application's connection request.
ODBC should be properly configured (odbc.ini on Unix and ODBC Data Source wizard on Windows) to be able to connect to the server.

 

[vpshriyan]

Hi raviaute,

>There is no need of a special service to accept ODBC connection request.

I differ.
There need to be network thread spawned by the instance in the form of SOCkets or Transport Layer Interface (TLI) poll threads. Local connections can gothrough with Shared Memory using Inter Process Communication mechanism (IPC). The specification and configuration of $INFORMIXDIR/etc/sqlhosts is essential and are not set by default.

>When the Informix server instance is running, it is ready to accept the client application's connection request.

Not necessarily.
If the instance is congigured to accept the network connection as described above, it will.

onstat -g ntt

will list the global network information. This will exactly tell you the types of threads initiated by the informix instance to serve the user requests.

Regards,
Shriyan

"The learning and knowledge that we have, is, at the most, but little compared with that of which we are ignorant."