Re: Postgresql ODBC driver not found
On Thu, Sep 23, 2021 at 08:18:45AM -0400, Henning Follmann wrote:
> On Thu, Sep 23, 2021 at 08:44:42AM +0200, Pierre Couderc wrote:
> > Thank you very much!
> >
> > See below :
> >
> > On 9/22/21 3:37 PM, Henning Follmann wrote:
> > > 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...?
I don't see where you ask for the PostgreSQL ODBC connection in particular.
Maybe I'm the one missing something?
> > > The ability to clearly describe your problem!
> > Sorry I tried to be minimum... But here are more details?
>
> Not sorry, but what do you expect? That everybody has a magic crystal
> bowl to fill in missing information?
Hey, ease up. Missing information makes it harder to diagnose the issue,
but there is no need to be rude about it.
[...]
> > > Did you compile it? And if so, how?
> > Yes, with default tools (gcc under debian bulllseye linked with libodbc)
>
> Are you kidding me? That is not additional information. Just you
> being condescending.
> Strike one.
>
> > > You installed odbcunix I assume.
> > > How did you configure it?
> > Correctly.
>
> Really? REALLY?
> Strike two.
Wow, seriously rude.
[...]
> can you please connect to your database with:
>
> isql "PostgreSQL Unicode" <user> <password>
>
> and perform a minimum check like:
> select 1;
[...]
That's helpful, and I look forward to seeing the response to this.
> -H
>
> --
> Henning Follmann | hfollmann@itcfollmann.com
--Gregory
Reply to: