As I continue to attempt getting all old IIS6 sites running properly in IIS 7.5 (Windows Server 2003 R2 64bit), the next issue didn’t occur much past my last post.  After creating my new Data Source (DSN), I opened up the migrated site and received the following error:

Microsoft OLE DB Provider for ODBC Drivers error ’80004005′
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
/path/to/dsn.asp, line 6

Well that’s interesting.  It’s mostly interesting because of what was actually on line 6 of this file:

Conn.Open “dsn=dsnName;uid=user;pwd=pass;”

Googling kept pointing me to it being a 32bit application running in 64bit mode.  All the resolutions were mostly explaining that the application needs to be recompiled, yadda, yadda.  Obviously this .asp file isn’t a “32bit file”, and well what am I supposed to tell my customers, that they need to only use 64bit .mdb files?

Read the rest of this entry »

So I’m in the process of moving all the sites leftover on my old 32bit Windows Server 2003 web servers running IIS6. I’m moving everything to Microsoft Windows Server 2008 R2 64bit.  I am pretty sure I’m going to end up choosing the Web Edition of Windows Server 2008.  So far it seems to do everything I need at a huge discount to Standard Edition.

I would have expected there to be no problems with most of them. I started out with a dinky little site that uses a small Microsoft Access Database.  This site uses a standard DSN to access the .mdb. I proceed to go to the Administrative Tools and open the ODBC Data Source Administrator window and add a new DSN for the .mdb and lo and behold I see the following nearly empty window:

Read the rest of this entry »