darrellbuckley
asked on
Classic ASP and Server 2008R2
I just setup a server to run some classic asp pages I have and everything was going smooth until I setup my access DSN, using odbcad32 I setup the dsn ran my scripts and I keep getting this error, can't seem to resolve. Line 251 is the line that the dsn is listed.
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
/formdone.asp, line 251
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
/formdone.asp, line 251
also make sure you enable 32-bit application support for whatever application pool you're using to run the site
ASKER
I dragged the sysWOW64\odbcad32.exe to the desktop and ran that to setup the dsn, I did just change the application pool to classic asp, I haven't restarted the computer yet but got the same message.
you sure your database is 32 bit? Check Task Manager, and under Processes, look for "*32" to be appended to the process name for your DB
ASKER
it was working in the same environment it was in, same server setup. It's an old access database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You the man Monty! Thanks a bunch......
glad ya got it working :)
are you positive you set up a 32 bit connection? Make sure your run the setup from c:\windows\sysWOW64\odbcad