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

Discussion in 'ASP .Net' started by =?Utf-8?B?UEFN?=, Feb 26, 2004.

  1. 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(Int32 hr) +2
    System.Data.OleDb.OleDbConnection.InitializeProvider() +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
     
    =?Utf-8?B?UEFN?=, Feb 26, 2004
    #1
    1. Advertising

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

    The app is on the E:\ drive (while the file is on F:\) -- don't know if that's significant...
     
    =?Utf-8?B?UEFN?=, Feb 26, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. THY
    Replies:
    4
    Views:
    532
    Gönen EREN
    Aug 22, 2003
  2. Replies:
    2
    Views:
    5,855
    Paul Clement
    Dec 30, 2005
  3. Replies:
    4
    Views:
    43,368
    spatil02
    Jan 30, 2012
  4. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,596
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  5. viza
    Replies:
    0
    Views:
    677
Loading...

Share This Page