v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Post by FredS » Thu 03 Nov 2016 17:06

Just installed 6.4.15, ran fine with FB but I get this error (subject) when connecting inside a thread using <TUniConnection>.connect(ConnectionString).

ConnectionString=
'Provider Name=SQL Server;Provider=SQLOLEDB.1;Data Source=VMW7;Initial Catalog=PA;Force Create Database=False;Authentication=Windows;Login Prompt=False'

All works well in 6.4.14

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Post by azyk » Fri 04 Nov 2016 08:50

We can't reproduce the described issue. Please clarify, if there is a successful connection to SQL Server on the client machine, if you use SQL Server Management Studio for that user?

FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

Re: v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Post by FredS » Fri 04 Nov 2016 15:38

The main thread connects successfully and loads the data. This occurs only inside the threads.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Post by azyk » Tue 08 Nov 2016 09:21

To solve the issue, try before calling the TUniConnection.Connect method, add a call of the CoInitialize function. To use CoInitialize, add the ActiveX unit to the uses section.

If the issue is still reproduced, then compose a small example for its reproduction and send it, using the contact form on our website http://www.devart.com/company/contactform.html .

FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

Re: v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Post by FredS » Tue 08 Nov 2016 16:27

azyk wrote:To solve the issue, try before calling the TUniConnection.Connect method, add a call of the CoInitialize function. To use CoInitialize, add the ActiveX unit to the uses section..
This exists since it works in 6.4.14.

But to be clear this error occurs in 6.4.15 in a TTask not TThread.

FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

Re: v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Post by FredS » Tue 08 Nov 2016 17:30

FredS wrote:But to be clear this error occurs in 6.4.15 in a TTask not TThread.
Was using 6.4.14 due to this issue and switched to 6.4.15 to see if I could give you more info and can no longer reproduce this problem.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: v6.4.15 - EOLEDBError with message 'Cannot generate SSPI context'.

Post by azyk » Fri 11 Nov 2016 08:30

Using TTask we are also unable to reproduce the described issue in UniDAC 6.4.15. Please send us an example to reproduce the issue.

Post Reply