sspi

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
bradk
Posts: 34
Joined: Thu 20 Apr 2006 01:42

sspi

Post by bradk » Thu 12 Oct 2006 00:30

is there any option to support sspi based authentication ?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 12 Oct 2006 13:30

No, there is no option to support Security Service Provider Interface.

Scott Herbert
Posts: 3
Joined: Tue 31 Aug 2010 05:25
Location: Canberra, Australia

SSPI

Post by Scott Herbert » Wed 19 Jan 2011 22:16

Are there any plans to build in SSPI support?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 20 Jan 2011 11:37

We will investigate the possibility of implementing this feature in dotConnect for PostgreSQL and notify you about the results as soon as possible.

PatrickG
Posts: 12
Joined: Thu 10 Mar 2011 21:51

sspi

Post by PatrickG » Thu 10 Mar 2011 22:02

It has been in available in PostgreSQL for a long time, it sure would be nice to be able to use this feature.

I too would like to be notified if and when this feature were to become available.

Thanks

Patrick

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 14 Mar 2011 09:38

We will post about the results of our investigation in this thread.

cjbiggs
Posts: 105
Joined: Fri 15 Jan 2010 19:56

Post by cjbiggs » Mon 13 Jun 2011 14:02

As a licensed Devart User, my company need to know the plans for supporting SSPI in the Devart dotConnect for PostgresSQL. This has been a feature of PostgresSQL for a couple of years and pgAdmin has support for it. Npgsql was it implemented in there Open Source .NET Data Provider. Looking at the open source for it, it seem to be pretty easy to implement.

Can Devart provide a clear answer and direction on this feature? I have a 2 weeks to make my decision of leaving Devart and going to Npgsql to meet my company requirements.

Thanks,

Charlie J.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 15 Jun 2011 15:18

cjbiggs, please contact us and give us your e-mail you have used during product registration. We will send you a test build with this feature. Could you please test it in your environment?

cjbiggs
Posts: 105
Joined: Fri 15 Jan 2010 19:56

Post by cjbiggs » Wed 15 Jun 2011 16:13

Thanks. The registered user email for my company is [email protected] We will test the build as soon as we get it.

Thanks,

Charlile J.

cjbiggs
Posts: 105
Joined: Fri 15 Jan 2010 19:56

Post by cjbiggs » Thu 16 Jun 2011 13:53

Have the test build for SSPI been sent so I can test the fix in my environment.

Thanks,

Charlie J.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 16 Jun 2011 17:02

We have sent our test assemblies to you. Please notify us about the results.

cjbiggs
Posts: 105
Joined: Fri 15 Jan 2010 19:56

Post by cjbiggs » Fri 17 Jun 2011 13:46

Hi,

Sorry but we have not received the test build for the SSPI. Can you please send it to [email protected] We are all setup and ready to test it out today.


Thanks,

Charlie J. Biggs

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 20 Jun 2011 09:41

cjbiggs wrote: Can you please send it to [email protected]
Done.

cjbiggs
Posts: 105
Joined: Fri 15 Jan 2010 19:56

Post by cjbiggs » Tue 21 Jun 2011 23:35

Is there a specific version of dotConnect for PostgresSQL I need to have installed to get the assemblies that was emailed to me? I have dotConnect for PostgresSQL 5.30.172 installed. Plus I am using Entity Framework and DBProviderFactory to connect. Are there any issues with using Entity Framework and DBProviderFactory with the special build for SSPI?

Thanks,

Charlie J.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 22 Jun 2011 07:07

Please uninstall your current version of dotConnect for PostgreSQL and add the references into your project to the assemblies (Devart.Data.dll and Devart.Data.PostgreSql.dll) which we have sent to you. They are the test assemblies and can be used only for opening connection to the server (no other operations). If you confirm that the SSPI connection works, we will add the feature to the next public build of dotConnect for PostgreSQL.

Post Reply