Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #240291

Re: Postgresql ODBC driver not found

Show all headers | View raw

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

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Postgresql ODBC driver not found Pierre Couderc <pierre@couderc.eu> - 2021-09-22 11:20 +0200
  Re: Postgresql ODBC driver not found Henning Follmann <hfollmann@itcfollmann.com> - 2021-09-22 15:40 +0200
    Re: Postgresql ODBC driver not found Pierre Couderc <pierre@couderc.eu> - 2021-09-23 08:50 +0200
      Re: Postgresql ODBC driver not found Henning Follmann <hfollmann@itcfollmann.com> - 2021-09-23 14:20 +0200
        Re: Postgresql ODBC driver not found Gregory Seidman <gsslist+debian@anthropohedron.net> - 2021-09-23 18:00 +0200
          Re: Postgresql ODBC driver not found Pierre Couderc <pierre@couderc.eu> - 2021-09-24 00:00 +0200
            Re: Postgresql ODBC driver not found Henning Follmann <hfollmann@itcfollmann.com> - 2021-09-24 17:40 +0200
              Re: Postgresql ODBC driver not found Pierre Couderc <pierre@couderc.eu> - 2021-09-25 09:20 +0200
                Re: Postgresql ODBC driver not found Henning Follmann <hfollmann@itcfollmann.com> - 2021-09-25 15:50 +0200
                Re: Postgresql ODBC driver not found Pierre Couderc <pierre@couderc.eu> - 2021-09-26 00:20 +0200
                Re: Postgresql ODBC driver not found Henning Follmann <hfollmann@itcfollmann.com> - 2021-09-26 14:00 +0200

csiph-web