Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1050 Thread 0x10a8 DBC 0x225e154 Excel'

[Application Development]

Hi all, PLEASE HELP.

I'm having a real issue with reading an Excel file from my asp on a
remote server.

A snipit of my script is as follows:

exceldb="serverdetails/adotest.xls"
Set objConn = Server.CreateObject("ADODB.Connection")
' Create a server connection object
objConn.Open "DBQ=" & Server.MapPath(exceldb) & ";" & _
"DRIVER={Microsoft Excel Driver (*.xls)};"

This all work fine. The problem comes when i try to access the file
Exce file on a remote machine. I get the following message

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Excel Driver]General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x1050 Thread 0x10ac DBC
0x225e36c Excel'.


I have set up a virtual directory and the pointed it to the location of
the Excel file.

I gave "connect as" permissions of the virtual directory, domain admin
priviledge (over kill i know). I know that the account has full access
to the directory and file.

If i test the url of the virtual directry and file name, i can open the
file, so i know the virtual directory is working fine.

If i change the virtual directory and point it to another location on
the server hosting IIS then all works fine.

I have a lot of articles pointing the problem to the permissions of the
file or the temp directory, but as i am using a domain admin account i
can't see this being the issue.

Can anyone please help.

Thanks in advance

Hoppers