Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1050 Thread 0x10a8 DBC 0x225e154 Excel' : Inetserver
This is a discussion on Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1050 Thread 0x10a8 DBC 0x225e154 Excel' within the Inetserver forums in Microsoft Tools category; 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 ...
| Inetserver Microsoft Inet server asp, iis, ftp, smtp and security related discussions |
![]() |
| | LinkBack | Thread Tools |
|
#1
| |||
| |||
| 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 |
|
#2
| |||
| |||
| hoppers wrote: > Hi all, PLEASE HELP. > > I'm having a real issue As opposed to a fake 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'. > This is a problem caused by using the obsolete ODBC driver: http://www.aspfaq.com/show.asp?id=2154 Try switching to using the Jet OLE DB provider per this: http://www.carlprothman.net/Default....rosoftJetExcel -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
|
#3
| |||
| |||
| Bob, thanks for the funny, and even more thanks for the solution, which has certainly got me further. My code now looks like this Dim objConn Dim ObjRS Set objConn = Server.CreateObject("ADODB.Connection") Set objRS = Server.CreateObject("ADODB.Recordset") strBaseFilePath = "serverdetails/adotest.xls" objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath(strBaseFilePath) & ";" & _ "Extended Properties=""Excel 8.0;""" objRS.Open "Select * from DataArea", objConn, adOpenStatic Which works and i can now actually get to my remote file however.....I now get this Microsoft JET Database Engine error '80004005' The Microsoft Jet database engine cannot open the file ' **path to file** \ Server Docs\adotest.xls'. It is already opened exclusively by another user, or you need permission to view its data. /excel.asp, line 11 I have checked that is not already open and i have confirmed that the virtual directory can see the file, which i can open by opening the link to the file via the virtual directory. I have check the file and it have everyone as full control. Any ideas? I did try and add a user id and password in the opening of the datasource, but i can't seem to find the correct syntax. Thanks again. |
|
#4
| |||
| |||
| hoppers wrote: > > Which works and i can now actually get to my remote file however.....I > now get this > > Microsoft JET Database Engine error '80004005' > > The Microsoft Jet database engine cannot open the file ' **path to > file** \ Server Docs\adotest.xls'. It is already opened exclusively by > another user, or you need permission to view its data. > > /excel.asp, line 11 > This is a tough one. If you were opening an Jet database, I would know to advise you to grant read/write (Modify) authority for the folder containing the mdb file to all users of the .mdb file so that the locking file (.ldb) can be created modified and deleted by the users. However, I do not believe an Excel file uses that type of semaphore-locking strategy. All i can suggest is that you look at this article: http://www.aspfaq.com/show.asp?id=2168 -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. |
![]() |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [Microsoft][ODBC Excel Driver] Cannot open database '(unknown)' | usenet | DOTNET | 0 | 09-10-2006 11:57 AM |
| Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression 'MANUAL # LIKE '%Plant%' OR TITLE LIKE '%Plant%' OR VENDOR LIKE '%Plant%''. | usenet | Inetserver | 1 | 08-01-2006 11: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' | usenet | Inetserver | 0 | 03-02-2006 05:49 AM |
| ERROR [22001] [Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. | usenet | DOTNET | 1 | 02-23-2004 12:51 PM |
| 2003 Server/VC6/ODBC Excel Driver/RDP Client | usenet | ADO DAO RDO RDS | 0 | 08-17-2003 11:38 AM |


