Thread: PostgeSQL & odbctest & SQL_NO_DATA_FOUND

Hello,

I have spent several hours of tracking down a setup issue with PostgreSQL & iODBC 3.0.5.  While I now have it working, I am still confused as to why it works the way it does and am hoping someone out there has the answer.

I set up odbcinst.ini and assigned it to the environmental variable ODBCINSTINI.
I set up odbc.ini and assigned it to the environmental variable ODBCINI.

When I used odbctest to access PostgreSQL using the connect string dsn=PostgreSQL, I kept getting:

SQLAllocEnv ( ... )
SQL_SUCCESS

SQLAllocConnect ( ... )
SQL_SUCCESS

SQLDriverConnect ( ... )
SQL_NO_DATA_FOUND

SQLError ( ... )
SQL_NO_DATA_FOUND

SQLError ( ... )
SQL_NO_DATA_FOUND

SQLFreeConnect ( ... )
SQL_SUCCESS

When I used a connect string which specified the dsn, server, port and database it worked correctly.

In tracing the problem down, it appears that the odbctest program looks at the odbc.ini file specified in ODBCINI only until SQLAllocConnect is complete.  From that point on, it ignores what is in ODBCINI and only attempts to access the odbc.ini file in {$HOME}/.odbc.ini.

Therefore, copying the odbc.ini to {$HOME}/.odbc.ini allows a connect to be made using just the dsn.

Does anyone know why it works this way?  Is this a problem with PostgreSQL, iODBC or odbctest?  I would very much like to use ODBCINI to specify which odbc.ini to use rather than have copies in everyone's {$HOME}.

Thanks in advance,

Graydon Gorby
Positive Business Solutions, Inc.