Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Microsoft JET Database Engine error
Message
De
09/01/2007 16:24:48
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Titre:
Microsoft JET Database Engine error
Versions des environnements
Environment:
VB.NET 1.1
Divers
Thread ID:
01183972
Message ID:
01183972
Vues:
69
What is the best way to debug Microsoft Jet Database Engine errors? In my ASP.NET application, I am attempting to connect to an Excel file using impersonation for file security. I can see the file, so I know that part works. When I try to pull data from the file using an OleDBCommand, I get an error.

err.number = 5
err.description "Unspecified error"
err.source = "Microsoft JET Database Engine"

Here is my code:
da.SelectCommand = New System.Data.OleDb.OleDbCommand
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & System.Configuration.ConfigurationSettings.AppSettings.Get("CSDPath").ToString & ";Extended Properties=""Excel 8.0;HDR=No;IMEX=1"""

da.SelectCommand.CommandText = "SELECT * FROM [Sheet1$]"
da.SelectCommand.CommandType = CommandType.Text
da.SelectCommand.Connection = conn
da.Fill(ds, "CSD Rates")
Very fitting: http://xkcd.com/386/
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform