Moving to a 64bit system

I'm really having a hard time with a recent server upgrade. For the longest time the company I worked for was using a 32 bit windows 2003 server. Recently the server has died on us so we had to get a new server. Unfortunately the only servers that they hosting company has now come with windows 2008 64bit.

I have been fighting with it for a little over a week trying to get our old websites to work.
Our websites are classic asp using ADODB.Connection. I have spent days trying to make it work correctly. I have gotten the server to give me useful errors but cant seem to get any of the solutions to work for me.

Can anyone give me a hand?  Here is a run down of what I have done so far.

- Accessed IIS and enabled detailed errors and posting of errors to the browser.
- Set up test website
- Created the test database
- Created a database login
- Created a user for the test database using the new login
- Set up a 32bit worker process and assigned it to the website
- Loaded test page

That's about as far as I get before I start getting errors. I do apologies for my lack of knowledge. I usually don't deal with this portion of a server. Unfortunately for me I'm now the only one that can do it. Any help would be appreciated. At this point I'm even considering paying to have it done if I cant find a company that can do it.

Thanks again for any help you can provide.

Also here is the page i am trying to use to test the server and the error that I'm getting.

ERROR
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/default2.asp, line 24

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

Under Construction
<br>
<%
Response.write Server.MapPath(Request.ServerVariables("Path_Info"))
%><br>
<%
response.write "Somewhat working"
%><br>
<%
dim strSQL
set Global_DBConnection=Server.CreateObject("ADODB.Connection")
DSN="Driver={SQL Server};Server=XXX;Database=test;UID=test;PWD=asdfg"
Global_DBConnection.Open(DSN)
%>