Vista, IIS7, Classic ASP, and Microsoft Access – How to Get It Working!

First, make sure ASP Classic Is Installed on Vista, good instructions here

Make sure your app is set up as a virtual directory, etc, etc.

Then, you need to set permissions and run commands and change around settings just to get anywhere. Just for kicks I made the IUSR for the directory have modify rights, but I am not sure if that did anything, oh well, I am not changing it back.

I ran the default page, and got this

An error occurred on the server when processing the URL. Please contact the system administrator

Nice huh? Well, I went and turned off Friendly HTTP Errors in IE Internet Options, that didn’t give me anymore info, so, found this:

cscript %systemdrive%inetpubadminiscriptsadsutil.vbs set w3svc/AspScriptErrorSentToBrowser true     

That will send the actual errors to the browser, ok good.

Now, getting this:

Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’

Found out you need to run 3 more commands to get this to work… ok

icacls %windir%serviceprofilesnetworkserviceAppDataLocalTemp /grant Users:(CI)(S,WD,AD,X)

icacls %windir%serviceprofilesnetworkserviceAppDataLocalTemp /grant “CREATOR OWNER”:(OI)(CI)(IO)(F)


%windir%system32inetsrvappcmd set config -section:applicationPools /[name=’DefaultAppPool’].processModel.loadUserProfile:false

After all that nonsense, the page/app actually worked! What a debacle…

Technorati tags: , , , , , , , , , ,
Geeky/Programming Life Random

It's all in the family… My Uncle Matt is a MS Access to SQL Server Conversion Expert!

Last weekend I went out to Florida to visit my Aunt Jen and Uncle Matt, I have never been to Florida so this was cool. I knew that Matt had – I took a look at the site a couple years ago but never really dug into it. Turns out he is like one of the best MS Access to SQL Server Converters around. Now, don’t get me wrong – Microsoft Access stinks – but more for a database than for a front end. Using SQL 2000/2005 as a backend and Access as a front end isn’t TOO bad, really VB 6.0’ish. I would rather see ASP.NET Front ends, but it really depends on what companies want.

It was cool to have someone in the family I can relate to! Since currently I am working on Data Warehousing and SQL Server 2005 stuff, this was cool that we could “geek talk”!

Technorati tags: , , , , , , , , ,