Strange DNS problem with Win 64 and asp 1.1

[sonic123]

Hello,

I recently upgraded to Windows 64. I installed asp 1.1 and followed the Microsoft patch to run it under 32 bit mode. I'm also using IIS.

I have a site running on asp using ms sql server 2000 as the db. I've set up the server added the ODBC entries for the datasource that I use (although interesting I only had the sql server connector not the whole list of connectors (access etc ) that I had under win 2000). I then run the asp site using my IIS localhost. The static site pages work fine but and dynamic page throws the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Now I have checked all of the DNS entries for spelling mistakes etc and they are fine. So I'm stuck as to why I can't connect to the db! By the way after I set up the ODBC entries if I test the connection it connects correctly.

Any help? Anyone else had similar probs?

Many thanks

Sonic.

P.S I am running the following connection sub:

Sub OpenWebSiteDSN()
Set websiteConn = Server.CreateObject("ADODB.Connection")
websiteConnection="DSN=MydatabaseConn;Database=Myd atabase;UID=webuser;PW=;"
websiteConn.Open websiteConnection
End Sub

[daninmanchester]

Have you check the permissions?
What type of authentication are you using?
If you are using integrated it wil use you account when testing and then the ASP.net account when running the script.