Cannot initialize SSPI package

From: Ogie T (rtorreca_at_hotmail.com)
Date: 04/21/04 

Date: 21 Apr 2004 10:39:42 -0700

After installing the security updates below, my vb6 applications
started having problems connecting to the database.

http://www.microsoft.com/technet/security/bulletin/ms04-011.mspx
http://www.microsoft.com/technet/security/bulletin/ms04-012.mspx
http://www.microsoft.com/technet/security/bulletin/MS04-014.mspx

I do not have a custom security.dll installed so I know this is not
the cause of my problem. Searching my entire server will not return
this file.

System specs:
Windows 2000 5.00.2195 SP4
Visual Basic 6.0
ActiveX ADO 2.5
IIS 5.0

The applications I have uses a dll for connecting to the database.
Let's call this dll conn.dll for illustration purposes. Conn.dll
simply returns an adodb.connection that's already opened. (This way
when multiple application that need to go to that db, other programmer
won't need to know the uid/pwd/db. They just need this util to connect
to it)

I have an .exe that has been running stable for more than 2.5 years
that uses conn.dll. After applying the patches, it started failing and
found that it fails with "Cannot Initialize SSPI Package" when
attempting to connect to db. But the problem does not happen with our
web applications, which are installed on the same server and also use
conn.dll to connect to db. Why would it fail on one and not the other?

I also wrote a test .vbs script that uses conn.dll to see if it can
connect. No problem.

I also wrote another .exe that uses the code snippets from the
original .exe and it runs without any problems! Again, why would it
fail on one and not the other when it uses the exact same dll?

So, ok, I remove conn.dll from the .exe and tried to connect using
straight ADODB.connection with a hard-coded connection string. Still
fails. But use the same code on a vbscript on the other .exe I
mentioned, and it works just fine.

I haven't tried uninstalling the patches because it simply is not an
option at this time as they are critical patches that MUST be
installed.

If anyone can offer any help, I would greatly appreciate it.

thanks,
Ogie

Relevant Pages

  • Re: Cannot initialize SSPI package
    ... Server you are having trouble connecting to.. ... > After installing the security updates below, ... > I also wrote another .exe that uses the code snippets from the ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot initialize SSPI package
    ... > After installing the security updates below, ... > The applications I have uses a dll for connecting to the database. ... > I have an .exe that has been running stable for more than 2.5 years ... > found that it fails with "Cannot Initialize SSPI Package" when ...
    (microsoft.public.sqlserver.setup)
  • Re: I WANT MY FP2000 BACK-Fr Alex
    ... > However you needed to have Norton disabled when you installed ... > In general any anti-virus application should be disabled when installing ... > Thomas A. Rowe ... >>>> What other applications do I have. ...
    (microsoft.public.frontpage.client)
  • Re: Whats the Deal with IE8
    ... What third-party firewall? ... applications running in the background when you installed and/or ... I generally follow the same procedure when installing major upgrades. ... 13- Disable your security software. ...
    (microsoft.public.windowsupdate)
  • Re: ATAPI CD-ROM, UNIX"NEW GUY"
    ... >> As of now it is no longer working properly I cannot finnish installing ... Most of the applications you list are available for Mac OSX; ... Select the best operating system to support the applications. ...
    (freebsd-questions)
Quantcast