Stack Overflow
Stack Overflow

Questions tagged [oledbexception]

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.

138 questions
1
vote
1 answer

Access denied when trying to run stored procedure on MS SQL Server

I am getting below error message when I am trying to run stored procedure. Msg 7399, Level 16, State 1, Procedure accountupdater, Line 10 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access…
Saidamin Usmanov
  • 47
  • 5
1
vote
1 answer

Error executing update over OLEDB from C#

I am using OLEDB to Update data in .dbf database from c#. I get Error: System.Data.OleDb.OleDbException {"Undefined function 'replace' in expression."} on ExecuteNonQuery. How can I make this work with least changes, i need to replace double quotes…
watbywbarif
  • 6,487
  • 8
  • 50
  • 64
1
vote
1 answer

C# Alter add column on excel with OLEDB

I am trying to add a column in Excel sheet with OLEDB by using ALTER statement. I am not able to do it. I tried with following code but its not working out sqladd = "ALTER TABLE Data ADD NewRow varchar(50)"; Here, Data is the Sheet name in Excel…
Pranav Nalavade
  • 23
  • 1
  • 4
1
vote
1 answer

OleDbException when trying to update an Access database

I'm following all the instructions that I can see in the web, including MSDN:https://msdn.microsoft.com/en-us/library/ms233819.aspx Unfortunatelly, no matters how much I change the code, it always return to me an error: "A first chance exception of…
FerPessoa
  • 63
  • 1
  • 9
1
vote
1 answer

Unhandled exception of type 'System.Data.OleDb.OleDbException' occured in System.Data.dll

I'm getting an error in this code, designed to create records in an Access Database, but can't seem to work out why. Option Explicit On Option Strict On Imports System.Data.OleDb 'Name: CustomerController.vb 'Description: Class acting…
Alastair McIntyre
  • 11
  • 1
1
vote
1 answer

Error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine not getting fixed

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and…
Manish
  • 21
  • 1
  • 9
1
vote
1 answer

Nested SELECT throws an exception "No value given for one or more required parameters"

Trying to execute the following query on northwind access database throws an exception: No value given for one or more required parameters My simplified query is SELECT * FROM (SELECT [Orders].[OrderDate] FROM [Orders]) t WHERE…
VladL
  • 12,769
  • 10
  • 63
  • 83
1
vote
1 answer

c# window application system.data.oledb.oledbexception operation must use an updateable query

I have made a window application that works very well when i ran through but after creating its setup it is throwing below mentioned exception. I have try to give full access to the database file but still it is not…
Sandeep
  • 2,573
  • 3
  • 21
  • 28
1
vote
1 answer

Is it possible to get the specific type of an OleDbException in VB.NET?

I try to catch/get the Type of the OleDbException to generate the correct error message. At this moment I'm sure I catch whatever OleDbException, but I want to catch only duplicate value violations to generate the error message. This is what I do…
Tassisto
  • 9,877
  • 28
  • 100
  • 157
1
vote
2 answers

SQL INSERT INTO statement for MS Access

I am trying to learn how to use MS Access with my VB.net program. I am practicing learning how to use the INSERT INTO statement but I keep getting an error. Here is my code: Imports System.Data.OleDb Public Class Form1 Private Sub…
gromit1
  • 577
  • 2
  • 14
  • 36
1
vote
1 answer

oledb exception: the database engine could not lock table

I have a C# application that interacts with an Access database. When I execute an OleDbCommand object to ALTER a table and ADD a new column, I receive an error: OleDbException: The database engine could not lock table because it is already in use…
Hamid62
  • 183
  • 4
  • 15
1
vote
2 answers

OleDbException: Missing semicolon (;) at end of SQL statement

I got an OleDbException saying that "Missing semicolon (;) at end of SQL statement." I got confused if the UPDATE statement is correct or not. In my code, I test the update statement using a button. Can anyone help me? I want to add 1 to the…
Catherine Takishima
  • 91
  • 2
  • 3
  • 12
1
vote
1 answer

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. error for excel

i use windows 7 home basic 64-bit and microsoft excel starter 2010 and i want to read an excel file but when i debug my code, i take this error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. my code is the…
rockenpeace
  • 1,011
  • 5
  • 18
  • 29
1
vote
5 answers

Sql error "Arithmetic operation resulted in an overflow."

I am running a service that does some computation and communicates with an ms sql server every minute or so (24/7, uptime is very important) and writes to error log if anything funny happens (like a timeout or lost connection). This works great,…
David Božjak
  • 16,887
  • 18
  • 67
  • 98
1
vote
2 answers

what should I do in "Data type mismatch in criteria expression"

Why am I getting this error? "OledbException was unhandled" "Data type mismatch in criteria expression." There is no problem when I am querying a string data type, but when I am querying a integer data type, I am always getting this problem.. I am…
user188228
  • 19
  • 1
  • 2
  • 7
1 2 3
…
9 10