Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Getting a strange error for an old site I am trying to move to a new server - The new server is Win2008 64bit with IIS7.

This site is working perfectly on an IIS6 Win2003 server, but I have just moved it over and run the site but I get the following error

Provider cannot be found. It may not be properly installed.

From looking around people seem to to just say enable 32 bit applications in the App pool and it will be fine? Unfortunately I did this and it didn't work? It seems to be falling over here

'*************************************************************************
'Open Database Connection
'*************************************************************************
function openDB()
    on error resume next
    set connTemp = server.createobject("adodb.connection")
    connTemp.Open connString
    if err.number <> 0 then
    	dim errMsg
    	errMsg = "" _
    		& "<b>Module :</b> scripts/_INCappDBConn_.asp : openDB()<br /><br />" _
    		& "<b>Number :</b> " & err.number & "<br /><br />" _
    		& "<b>Page :</b> "   & Request.ServerVariables("PATH_INFO") & "<br /><br />" _
    		& "<b>Desc :</b> "   & err.Description
    	call errorDB("",errMsg)
    end if
    on error goto 0
    if UCase(dbLocked) = "Y" then
    	call errorDB("<b>" & LangText("ErrStoreClosed","") & "</b>","")
    	closeDB()
    end if
end function

Just wondering if anyone can shed any light on what is going in?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

I know that this is fairly basic - but did you start by making sure that in IIS has ASP installed? Classic ASP isn't installed by default on IIS7. Go to Programs and Features in Control Panel and click Turn Windows features on and off. Navigate down the tree of features and make sure ASP is checked.

If you haven't already gone down this path - it's probably the issue.

share|improve this answer
    
By the way, if this turns out to be the issue there are a few other things. You will need to add an application pool for classic ASP. When you create it set .Net Framework Version to "No Managed Code" and the Managed Pipeline mode to "Classic"... While "checking my work" on this I came across this article which may help you step by step: learn.iis.net/page.aspx/472/… Hope it helps! –  Dave Holland Dec 13 '09 at 23:26
add comment

I am sure you will be shocked when I suggest that not all Microsoft applications and services work correctly in 64-bit mode... Just in case this might be a factor in your environment, see if there is an option to run this database connection in a 32-bit mode. For example, I got your exact error in a Visual Studio project that used a VB .NET script, and after changing the VS Project property, Run64BitRuntime, to be 'False', meaning run in 32-bit = 'True'. Then, magically, the error disappeared : ) I know you mentioned you changed a setting in the Application pool, but the error might occur before then, at run time when the database connection is made. Testing it outside of IIS might confirm or eliminate this as an issue.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.