Re: Postgresql ODBC driver not found

[Henning Follmann <hfollmann@itcfollmann.com>]

On Wed, Sep 22, 2021 at 11:07:28AM +0200, Pierre Couderc wrote:
> It is here I see it/them with:
> 
> odbcinst -q -d
> 
> but not with :
> 
>   SQLHENV env;
>   SQLCHAR driver[256];
>   SQLCHAR attr[256];
>   SQLSMALLINT driver_ret;
>   SQLSMALLINT attr_ret;
>   SQLUSMALLINT direction;
>   SQLRETURN ret;
>   SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
>   SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void *) SQL_OV_ODBC3, 0);
> 
>   direction = SQL_FETCH_FIRST;
>   while(SQL_SUCCEEDED(ret = SQLDrivers(env, direction,
>                                        driver, sizeof(driver), &driver_ret,
>                                        attr, sizeof(attr), &attr_ret))) {
>     direction = SQL_FETCH_NEXT;
>     printf("%s - %s\n", driver, attr);
>     if (ret == SQL_SUCCESS_WITH_INFO) printf("\tdata truncation\n");
>   }
> 
> What do I miss...?
>

The ability to clearly describe your problem!

What did you do?
  I assume you wrote some c code.
  Did you compile it? And if so, how?
  You installed odbcunix I assume.
  How did you configure it?
  What is the output of "odbcinst -q -d"?

What did you expect?

What did not work?
 Include logs, error messages.

What did you do to solve your problem so far?

-H






-- 
Henning Follmann           | hfollmann@itcfollmann.com