CODEWITHSUNDEEP
asp-classiciis-7.5windows-server-2008
Joe Grasso
Joe Grasso

Reputation: 475

Migrated from Server 2003 to 2008, ODBC problems

I migrated a website written in classic asp to windows server 2008 RS/ IIS 7.5. I made all the changes to run classic asp on the server and everything works fine with *.asp pages, except when it pertains to *.asp pages trying to access an *.mdb file.

The error I am receiving:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/MyChildFolder/Default.asp, line 9

As I said, this code worked fine just moments ago on a Windows 2003 Server/ IIS 6.0.

Upvotes: 0

Views: 711

Answers (2)

Bye
Bye

Reputation: 2806

Very simple to solve this:

  1. Open IIS Manager, I assume 7.5
  2. Open the Application Pool node and click on the domain name in question.
  3. Choose Advanced settings on the right side.
  4. In the Genl section, 2nd down, "Enable 32 bit applications", set that to true.

You should be good to go.

Upvotes: 3

Steve
Steve

Reputation: 151

Windows 2008 has 64bit ODBC that doesn't work with ASP as ASP uses 32bit or you should set this up to.

You can access 32 ODBC here C:\Windows\SysWOW64\odbcad32.exe

Upvotes: 0

Related Questions