dbExpress driver using sspi method authentication

dbExpress driver using sspi method authentication

Postby Tiago-Agile » Fri 28 Jul 2017 12:05

I have been using the Devart dbExpress driver for postgres in my Delphi XE2 applications for years, and it has been working very well. But now I'm with a situation that I need to use the sspi method authentication in postgres, in the pg_hba.conf, like this:

# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host MYDB APPUSER samenet sspi map=mymap
# IPv6 local connections:
#host all all ::1/128 md5 mymap
host MYDB APPUSER samenet sspi map=mymap

​Whe​n I try to connect the application with the database, using the dbExpress driver, it gives me the message:
" Cannot connect to database. Unknown auth method"

When I try the connection in the pgAdmin ( postresql client ), it works normally.

​Is there a configuration tha I can set in the connection parameters to suport this auth method? Or is there any other way that I can connect the databaset using the devart driver​ that supports this?
I didn't found anything related in the documentation, so I'm asking for help.
Tiago-Agile
 
Posts: 1
Joined: Fri 28 Jul 2017 11:51

Re: dbExpress driver using sspi method authentication

Postby azyk » Tue 01 Aug 2017 08:32

We have not tested SSPI Authentication for PostgreSQL using our driver. Now we are performing such testing and after its completion we will inform you about the results.
azyk
Devart Team
 
Posts: 961
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A


Return to dbExpress driver for PostgreSQL