Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADODB.Connection failing after installing server updates

Status
Not open for further replies.

frumpus

Programmer
Aug 1, 2005
113
US
I'm running a webserver with Windows 2003 Server R2, SP 1 with IIS 6.0

I have a few ASP pages that connect to databases using the following code:

Code:
Set oracledb = CreateObject("ADODB.Connection")
oracledb.Open "DSN=prod_db","username","password"

This has always worked fine until now. On 7/17, seven windows updates were installed and ever since, the 'oracledb.open' line has failed with this error.

Code:
ADODB.Connection error '800a0046' 

Permission denied 

confirmID.asp, line 84

I read up on each of the updates and the most likely culprit seemed to be KB933854 which affects webservers running asp.net and has a known issue involving sql server 2005 integration services. not exactly my issue but in the ballpark. I uninstalled this update, but still have the connection problem.

the other 6 seemingly unrelated updates are:

KB926122 affecting active directory and domain controller issues (this machine is strictly a webserver)

KB935839 win32 API update with no known issues

KB936357 intel CPU update

KB927891 which is a 'windows update' update

KB933566 cumulative IE update

KB935840 browser related update affecting SSL/TLS

Can anyone tell me what is causing this problem? Is there a way around it other than removing critical security updates? I am at a loss.
 
UPDATE

I have now gone ahead and uninstalled the other 6 updates and my problem remains. Those updates were the only changes from when this was working last however so now I'm stumped.
 
FINAL UPDATE

We just nuked the webserver and restored the site. Now everything is fine.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top