Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Microsoft JET Database Engine error
Message
From
09/01/2007 16:24:48
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
Microsoft JET Database Engine error
Environment versions
Environment:
VB.NET 1.1
Miscellaneous
Thread ID:
01183972
Message ID:
01183972
Views:
68
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/
Next
Reply
Map
View

Click here to load this message in the networking platform