Microsoft OLE DB Provider for ODBC Drivers error '80004005'

rabs · February 1st, 2010, 05:12 PM

I am attempting to import data into from an excel file into an application using asp. My code is as follows

HTML Code:

<%
                                        
                            'Routines for fetching excel file from file system
                            Dim conn 
                            Dim rs        
                            Dim file
                            Dim arrResultSet
                            Set file = request.form("excelFile")
                            Set conn = Server.CreateObject("ADODB.Connection")
                            Set rs = Server.CreateObject("ADODB.recordset")
                            Dim connString 
                            Dim sql
                            connString = "DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" & file &"; ReadOnly=0"
                             conn.Open connString
                            sql = "Select *  FROM [sheet1$];"
                            rs.Open sql, conn
                                                    
                            %>

I am using an excel file on my laptop and not on the server - the requirements for this work are that the user is able to import data from their local machine.

The following error is being returned....

Quote:

OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/mediabin/MapMetadata2.asp, line 131

The following is line 31 - connString = "DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" & file &"; ReadOnly=0"

Any help would be appreciated.

om_prakash · February 2nd, 2010, 01:00 AM

This issue might be due to invalid Excel file and/or file path.

You can also use following connection string:

connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";"

Or

connString = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDi r=c:\mypath;"

rabs · February 2nd, 2010, 11:05 AM

om_prakash - thanks for your response.

As I mentioned earlier the excel file is one the users PC and not on the server, so I cannnot specify the excel fine in the connection string.

That is why I am getting the filename from a form i.e.
Set file = request.form("excelFile")

Old Pedant · February 2nd, 2010, 10:07 PM

Then you can't do it.

There is no possible way for server-side code to utilize a file on the client's machine. It would be a *HUGE* security hole!

Just think, if *this* is possible, what's to prevent every malicious web site in the world from reading all your banking information and passwords and email and more???

You would have to allow the user to upload the file to the server, first, and *then* you could analyze it on the server. Period.