Page 1 of 1

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

Posted: Thu 03 Nov 2016 17:06
by FredS
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

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

Posted: Fri 04 Nov 2016 08:50
by azyk
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?

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

Posted: Fri 04 Nov 2016 15:38
by FredS
The main thread connects successfully and loads the data. This occurs only inside the threads.

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

Posted: Tue 08 Nov 2016 09:21
by azyk
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 .

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

Posted: Tue 08 Nov 2016 16:27
by FredS
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.

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

Posted: Tue 08 Nov 2016 17:30
by FredS
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.

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

Posted: Fri 11 Nov 2016 08:30
by azyk
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.