search
Twitter Rss Feeds
MicrosoftArticlesForumsGroups
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml/Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsGroups
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsGroups
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsGroups
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsGroups
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Publisher
Money

Operating SystemsArticlesForumsGroups
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsGroups
Share Point
BizTalk
Site Server
Exhange Server
IIS
Transaction Server

Graphic DesignArticlesForumsGroups
Macromedia Flash
Adobe PhotoShop
Microsoft Expression

OtherArticlesForumsGroups
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Reviews
Search Engines
Resumes

 

Previous Thread:   Type mismatch error between SQL Money format and Web Cookie value

3/2/2006 2:49:02 AM    Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1050 Thread 0x10a8 DBC 0x225e154 Excel'
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


Pete's Blog   |    Pete's Resume   |    Robbe's Blog   |    Robbe's Resume   |    Archive #2   |    Archive #3   |    Dotnetslackers   |    XmlPitStop   |    Advertise   |   Contact Us   |   Privacy   |   Copyright (c) 2000 - 2009 eggheadcafe.com  All rights reserved.