OleDb reader vs. ODBC reader

[joker]

First off stop using a DSN as it has been Deprecated from the MDAC.

Second read the following articles.

[url]http://www.aspfaq.com/show.asp?id=2126[/url]

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ado_deprecated_components.asp[/url]

And the following at [url]http://support.microsoft.com[/url]

190195 How To Extract Information from Excel Sheet with DAO

194124 PRB: Excel Values Returned as NULL Using DAO OpenRecordset

199841 How To Display ASP Results Using Excel in IE with MIME Types

246167 PRB: Collating Sequence Error Opening ADODB Recordset the First
Time Against an Excel XLS

246335 How To Transfer Data from an ADO Recordset to Excel with Automation

247412 INFO: Methods for Transferring Data to Excel from Visual Basic

266263 BUG: Word 2000 and Excel 2000 Display ASP Source When Using MIME
Type to Stream Data

278973 SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write
Data in Excel Workbooks

288343 BUG: Excel ODBC Driver Disregards the FirstRowHasNames or Header
Setting

295646 How To Transfer Data from ADO Data Source to Excel with ADO

314763 FIX: ADO Inserts Data into Wrong Columns in Excel

Sorry for listing so many I just wanted to make sure I covered my bases
on my answer.

Al Gorney wrote:

> I am writing a web application that will be running on one server and reading
> an .xls file that resides on another. I used an ODBC reader and it worked
> fine on localhost in debug, yet when I deployed to the server, it fails; the
> error is too long to put here, but here are the highlights: "General error
> unable to open registry key... temporary (volatile) jet DSN for
> process...0x808 thread 0x8f8 0x4f63ac Excel...Error Microsoft ODBC driver
> mgr driver's SQLSetConnectAttr failed...Microsoft jet database engine cannot
> open the file 'unknown'. It is open by another user or you need permission to
> view its data". Like I said before, it works in debug on my workstation but
> not on the server...Thanks, Al

[Unregistered]

Run your program As Administrator