"Cannot initialize SSPI package" 
Author Message
 "Cannot initialize SSPI package"

 Hi,
        I've got several VB DLL's that utilize the Data Environment to
read/write to SQL Server. When running these as stand-alone DLLs they
work fine. As soon as I place them under the control of MTS, I get
a "Cannot initialize SSPI package" when trying to establish a database
connection. The DSNs use "SQL Server Security", ie , I specify an ID
and Password and connect via TCP/IP.

        Does anyone have any idea why this might be happening? I
suspect that the DTC may be the culprit as it does its thing to
coordinate the transactional stuff? Any help would be greatly
appreciated."

--
Mike Morris

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Mon, 22 Jul 2002 03:00:00 GMT  
 "Cannot initialize SSPI package"
Hi Mike,
I have not unfortunately encountered completely the same problem
that you have described, but I have some funny problems
when I tried to use Data Environment to connect to SQL Server
from a Web Class. It stopped work correctly after I compiled the
application. After a couple days of nightmare I found out that for
some reason Data Environment set one of the internal (not exposed
to a user) SQL Server connection parameters to a wrong value.
I had no choice, changed Data Environment to plain ADO and it
worked fine. After that I never used Data Environment.
Hope it helps,
Gene


Quote:
> Hi,
> I've got several VB DLL's that utilize the Data Environment to
> read/write to SQL Server. When running these as stand-alone DLLs they
> work fine. As soon as I place them under the control of MTS, I get
> a "Cannot initialize SSPI package" when trying to establish a database
> connection. The DSNs use "SQL Server Security", ie , I specify an ID
> and Password and connect via TCP/IP.

> Does anyone have any idea why this might be happening? I
> suspect that the DTC may be the culprit as it does its thing to
> coordinate the transactional stuff? Any help would be greatly
> appreciated."

> --
> Mike Morris

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Sat, 27 Jul 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. "Cannot initialize SSPI package"

2. "cannot initialize data bindings"

3. Cannot initialize SSPI context

4. "Cannot load """

5. Error in "Initialize Component;"

6. VB6 ADO, Jet "Error initializing provider"

7. HELP: "VBAJET32.DLL Failed to initialize..."

8. VB6 ADO, Jet "Error initializing provider"

9. VB6 ADO, Jet "Error initializing provider"

10. "...an error in initializing provider..."

11. What is "Package"

12. *"*-.,._,.-*"* I"LL TRADE VISUAL C++ FOR VBASIC *"*-.,_,.-*"*

 

 
Powered by phpBB® Forum Software