OleDBException is an exception thrown regarding an OLE DB data source.
More information can be found at the this website: Microsoft Developer Network - OleDbException Class.
Questions tagged [oledbexception]
138 questions
8
votes
5 answers
OleDbException System Resources Exceeded
The following code executes a simple insert command. If it is called 2,000 times consecutively (to insert 2,000 rows) an OleDbException with message = "System Resources Exceeded" is thrown. Is there something else I should be doing to free up…
Pauly
- 1,631
- 5
- 18
- 29
6
votes
1 answer
OleDB Connection string for reading an Excel file exclusively opened by other user
Can anyone tell me OleDB Connection string to be used for just reading an Excel file exclusively opened by other user?
I tried following connection string which did not work for me:-
"Provider=Microsoft.Jet.OLEDB.4.0;Data…
Kushal Waikar
- 2,976
- 5
- 26
- 31
6
votes
4 answers
C# OleDb Exception "No value given for one or more required parameters" while trying to delete from Access database
I have a table with "SEMESTER, SUBJECT, OFFER, RESULT" where "SEMESTER" & "SUBJECT" is PRIMARY KEY. When i use the query
"DELETE FROM Course_Information WHERE Semester = 1 AND Subject = 'CSE-414' ;
Its working perfectly in access database but i…
user2594788
- 63
- 1
- 1
- 5
5
votes
3 answers
C# Access OleDb Data type mismatch in criteria expression
Would you please kindly check the following code for errors that give me a 'Data type mismatch in criteria expression' exception? I just can't seem to find the source of the problem...
*record.Date of nullable DateTime? type is explicitly casted to…
MooMooCoding
- 319
- 1
- 5
- 15
4
votes
1 answer
OleDbException (0x80004005): Unknown
I have the following code (part of a Windows Form) which connects to an Excel file successfully on my machine, but on a different box it fails.
var fd = new OpenFileDialog();
if (fd.ShowDialog() == DialogResult.OK)
{
var extendedProperties =…
Ryan Gates
- 4,501
- 6
- 50
- 90
4
votes
1 answer
System.Data.OleDb.OleDbException: Operation must use an updateable query
I'm confused. I'm trying to add a single record into an Access 2000 database using ASP.Net.
However, when I try to add new record, I get the following error:
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable…
Amintabar
- 2,198
- 1
- 29
- 29
3
votes
2 answers
How to get rid of the exception "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" in Win 7
I am running an ASP.NET C# application on .NET 4.0 framework using VS2010 on a Win 7 machine. Within my code I want to link Excel file with "DataTable" object. ie I want to access the data within Excel file and store it in DataTable object. So I…
codeLover
- 3,720
- 10
- 65
- 121
3
votes
3 answers
System.Data.OleDb.OleDbException: Unspecified error
I'm Totally new in ASP.net and currently working on a CRM application. This project uses .mdb files as backend but I am getting the following runtime error:
Description: An unhandled exception occurred during the execution of the current web…
Amol K
- 31
- 1
- 1
- 2
3
votes
5 answers
data mismatch in criteria expression using Oledb, C#, Dapper
I am simply inserting data using [c#, DAPPER, MS Access] inside a table but the column which is [DateTime] in c# is mapped to [date/time] column in MsAccess cause a issue like "data mismatch in criteria expression".
After a long research I got a…
Ankur Soni
- 5,725
- 5
- 50
- 81
3
votes
1 answer
OleDB connection only working when debugging
I have a C# application that connects to a named SQL Express instance on the local machine using OleDBConnection:
_connection = new OleDbConnection(_strConn);
_connection.Open();
_strConn is something like this: "Provider=sqloledb;Data…
Francesc Castells
- 2,692
- 21
- 25
2
votes
1 answer
System.Data.OleDb.OleDbException: Too many fields defined
I'm working on building a .NET WinForms application to replace a series of forms in a Microsoft Access (insert collective groan here) database. In an effort to get the initial version finished, I am attempting to use the existing queries rather…
Andy Dyer
- 506
- 6
- 20
2
votes
4 answers
Microsoft.Jet.OLEDB.4.0 provider is not registered
Hi I am getting a problem like this while uploading filetype .xls "Error in excel file:The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."
I am using following system versions:
64-bit Operating System( Windows…
prashiddha
- 49
- 2
- 5
2
votes
1 answer
Why am I obtaining this exception: "he 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"?
I have this simple C# console application:
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ImporterRidistribuzioni
{
class…
AndreaNobili
- 40,955
- 107
- 324
- 596
2
votes
0 answers
"Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine" but I have it installed already
I have the same problem as others but (in this case) I have already installed that component.
UPDATE:
I have Windows 10 x64, Office 2016 x64, MS Access Database Engine 2016 x64. Is a ASP.NET .NET Framework 4.5 target AnyCPU Visual Studio Solution…
Raul Miranda
- 71
- 1
- 3
- 10
2
votes
2 answers
ACE oleDb drivers unable to handle huge excel files
Does ACE OLEDB drivers have any known issues with larger files?
I am using the below code to retrieve the worksheets in a 400Mb xls file
public string[] GetWorkSheets()
{
var connectionString = "Provider=Microsoft.ACE.OleDb.12.0; data…
Whimsical
- 5,985
- 1
- 31
- 39