Excel connection from ASP gives error - Unable to open registry key

[mnhesh]

Hi All,

I have developed a site for online reporting. It has a option fromwhere user can browse an excel sheet which will be used to update the database.
It works well on my machine but gives error on web server.

The erroe is
"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 0x7dc Thread 0x89c DBC 0x10030024 Excel'. "

The connection string is

cn.Open "Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};Initial Catalog = '" & xlpath & "' "

The web server is a win 2000 advance server.

Please let me know the solution for this.

Thanks in advance

[pclement]

I'm not sure what type of authentication you are using for your web application (or Anonymous?) but it's probably a permissions issue.

PRB: Error Message: 0x80004005: General Error Unable to Open Registry Key (http://support.microsoft.com/default.aspx?scid=kb;en-us;295297)

If your web app is set up for Anonymous access then either the IWAM_<machine name> or IUSR_<machine name> probably does not have access to the registry key mentioned in the article.

[mnhesh]

Thanks pclement,

I read the article you have suggested. But the registry structure for my machine (win 2000) differs from that of described in the article. ( i.e. there is no security node under ODBC)

If your web app is set up for Anonymous access then either the IWAM_<machine name> or IUSR_<machine name> probably does not have access to the registry key mentioned in the article.

How can I do this? could you please explain?
The web server is in same city but far from my place. I have paid them for the hosting. Even these guys have no idea about this issue. If you can explain me I can go there and try it out.

Thanks again

[pclement]

Make sure you run Regedt32.exe and not Regedit.