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
0
votes
0 answers
OleDbException was unhandled
I'm using Access as database, but it seems the OleDbDataReader reader = cmd.ExecuteReader(); throws the error:
OleDbException was unhandled
Angelyme
- 1
0
votes
2 answers
Exporting to Excel using Microsoft.ACE.OLEDB.12.0 - VarChar limited to 255 characters - need longer alternative for up to 8000 chars
I am trying to create an Excel spreadsheet using the Microsoft.ACE.OLEDB.12.0 provider in vb.net, and I cannot seem to define a field that allows more than 255 characters.
Here is my current code to create the table:
create table [table_name]…
user3613310
- 7
- 4
0
votes
1 answer
Check null and emptry string in a cell while retrieving the excel data
Error : Additional information: Syntax error (missing operator) in query expression '[SKU N#] !='''.
if (getFileExtension.ToLower() == ".xls")
{
conString =…
Mannan Bahelim
- 1,289
- 1
- 11
- 31
0
votes
0 answers
Cannot save new row in database because of OleDbException using VB.NET
As the title states, I am having a problem and I cannot find it's cause.
Imports System
Imports System.Data.OleDb
Public Class Register
Dim con As New OleDbConnection
Dim strProvider As String
Dim strDataSource As String
Dim tables…
Justin de Gois
- 35
- 1
- 5
0
votes
1 answer
No value given for one or more required parameters - OLEDB cmd updating Excel
I am getting the error in the title when trying to update a row in Excel with blank values in these positions [BI6:DP6].
I have counted and it appears there are 60 spots in these cells to update, so I am stuck.
Any ideas? String to update is…
Techgration
- 516
- 4
- 16
0
votes
0 answers
The query contained only ignored words OleDbException using Index Server
I have ASP.NET 4.6.1 WebForms Legacy that using Index Server in Windows Server 2008 R2.
I get OleDbException error with message:
The query contained only ignored words.
My code:
var datos = new List();
var sql = "Select DocAuthor,…
Kiquenet
- 14,494
- 35
- 148
- 243
0
votes
2 answers
OleDB + Jet: Syntax Error in Join Operation
I've built a complex query for my access database and in access it works like a charm. But when I try to run the same query in my program via OleDB I get the exception "Syntax Error in Join Operation". No further info.
SELECT
…
Kempeth
- 1,856
- 2
- 22
- 37
0
votes
1 answer
Export SQL QueryResult to Excell file on Server without installing Office
I want write result rows of a query to a excell file:
INSERT into OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=C:\temp\testing.xlsx;',
'SELECT Id,CompanyName FROM [Sheet1$]')
select Id,CompanyName from tbl_Company
But When…
Javad Norouzi
- 327
- 4
- 11
0
votes
0 answers
Fill and Refresh Datagridview upon button click
I upon button click i retrieve and place data onto a datagridview. However, after i change the "Location", the location and execute button click i receive an error. Below is the code i have and the error i receive.
Code:
private void…
hex c
- 705
- 2
- 13
- 22
0
votes
4 answers
OleDbException was unhandled by user code in c#
Here is the cs file:
public int CheckExisting(String sqlDbQry, String sTable)
{
Qry = sqlDbQry;
con = new OleDbConnection(connectionstr);
if (con.State == ConnectionState.Open)
con.Close();
…
pcs
- 1,864
- 4
- 25
- 49
0
votes
1 answer
About reading multiple .dbf files in C#
Currently I'm making a program to import values from multiple dBase files (.dbf). I have already an List full of Strings that have the name of the dBase files. That list is named FicheirosParaAnalisar. The dBase files not always have the same lines…
user3664117
- 49
- 2
- 11
0
votes
2 answers
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Error
Currently, I am trying to run my c# code on my Windows x64 platform. But I cannot add my data into the MS Access. Its saying
Additional information: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.. I tried to check…
anonymous5671
- 331
- 7
- 23
0
votes
0 answers
External table is not in the expected format. What is wrong with this xls file?
When I run the code below I get the following error:
System.Data.OleDbException of {"External table is not in the expected format."}
I have tried all the different Extended Properties:
Excel 8.0
With HDR=NO and without. With IMEX=1 and…
Jet
- 1
- 2
0
votes
1 answer
How to add BLOB column in database?
I have read that for saving images into my database I need a datatype called BLOB. Also, in this link Microsoft Access Data Types, that for adding a column BLOB in my database working in Microsoft Access I need Ole Object. So I have done some tries…
Pichi Wuana
- 732
- 2
- 9
- 35
0
votes
1 answer
Syntax error in UPDATE statement OleDbException
I'm writing an application which stores user information. Currently the user is supposed to update their Name, Height, Weight and Birthday.
string height = TB_ClientHeight.Text;
string weight = TB_ClientWeight.Text;
string name =…
kkmonlee
- 379
- 2
- 16