By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,219 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,219 IT Pros & Developers. It's quick & easy.

Error trying to open connection to Excel file (.NET 1.1)

P: n/a
PAM
Hello

I'm a newbie trying to open a connection to an Excel file in a deployed ASP .NET app and get the error

[OleDbException (0x8000ffff): No error information available: E_UNEXPECTED(0x8000FFFF).
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +2
System.Data.OleDb.OleDbConnection.InitializeProvid er() +5
System.Data.OleDb.OleDbConnection.Open() +20

The ASPNET user has permission to Read, List Folder Contents and Read & Execute on this directory.

The code I'm using to open the file (which works just fine on my machine, of course) is

fiFileInfo = New System.IO.FileInfo("F:\Shared\pasapps\Insurance Apps\Data\file.xls"

If fiFileInfo.Exists The

Dim MyConnection As New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; data source=" & fiFileInfo.FullName & ";Extended Properties=Excel 8.0;"
Dim mySelectQuery As String = "SELECT * from [Sheet1$]
Dim MyCommand As New OleDbCommand(mySelectQuery, MyConnection

MyConnection.Open(

The server (Win2K, Build 2195, SP 4) has .NET Framework 1.1 installed (same exact version as the development machine)

Any thoughts would be appreciated

Thanks in advance
Patricia
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
PAM
The app is on the E:\ drive (while the file is on F:\) -- don't know if that's significant...
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.