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
0
votes
0 answers

Having Issues while uploading Excel Sheet. Sheet 1 is not a valid name.

While uploading excel it is giving error, At first its work fine but today it is giving error, I had implemented the save thing in another project and there it is working properly, I tried to give the exact name as sheet name as suggested in…
Bhupendra
  • 41
  • 9
0
votes
1 answer

OLEDBconnection exception: invalid argument in c#

It's my first try to to read test data for my automated test scripts from excel sheet using oledbconnection with Dapper. Whatever i do, i get invalid argument exception. I need to select the cell from column C based on the values in columns A and B.…
goraccio
  • 21
  • 2
0
votes
1 answer

IErrorInfo.GetDescription failed with E_FAIL(0x80004005) C#

I am getting an IErrorInfo.GetDescription failed with E_FAIL(0x80004005) And I don't know what this means nor how to solve it. When I copy and paste the exact query into my Access-db and run it it works like a charm but when I try and run it in c#…
Jelle Taal
  • 25
  • 1
  • 7
0
votes
1 answer

SSIS Error with OLE DB destination when executing

I'm New to SSIS so have been following some online tutorials. I have come across the following and cannot figure out what has happened. the error is with the OLE DB connection if anyone can point me in the right direction to getting this resolved…
sql2015
  • 591
  • 3
  • 13
  • 34
0
votes
2 answers

Syntax error in INSERT INTO statement in c# OleDb Exception cant spot the error

EXACT duplicate of Syntax error in INSERT INTO statement in c# oledb? Hi I cant spot the error. Please help. There is an OleDb Exception due to a Syntax Error. Syntax error in INSERT INTO statement OleDb Exception is unhandled. private…
Howard
  • 41
  • 1
  • 3
  • 6
0
votes
1 answer

System.Data.OleDb.OleDbException: System resource exceeded

I am getting this issue while trying to read data from an excel file using OleDb. This is working fine on my test server (Window Server 2008) but not working in UAT server with the same configuration. It used to work on the UAT server, but suddenly…
Girish
  • 166
  • 1
  • 2
  • 13
0
votes
1 answer

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14

Why I can't use same connection in loop. Could you help me, please? I would explain step of all. Step is as following: "Get By Brand" block(Execute SQL Task): I query Brand data, output is object. For example the output is "AAA", "BBB" - The loop…
akkapolk
  • 554
  • 8
  • 33
0
votes
0 answers

Error using C# Parameter @id has no default value

I created a login form in asp, and I seem to get this error: Parameter @id has no default value. Description: An unhandled exception occurred during the execution of the >current web request. Please review the stack trace for more information…
sn4il
  • 1
  • 1
0
votes
0 answers

"Operation must be an updateable query" VB.Net OleDB for Excel

Ive been trying to find a solution for this problem without any success: I'm using VB.NET and I need to read and update records from an Excel file. I use the OleDB API for that. It works fine for all the reading, but impossible to write to the file…
Ali
  • 3
  • 1
  • 7
0
votes
1 answer

OleDbException: Syntax error in INSERT INTO statement

I got OleDbException: Syntax error in INSERT INTO statement. I think that my INSERT INTO statement is good. Parameters have good data type so it's not problem. Does someone maybe know what's the problem? OleDbCommand command = new…
MiOnIs
  • 125
  • 12
0
votes
3 answers

IIS and OLE DB External table is not in the expected format

I am having some very strange issues with OLE DB connecting to Excel workbooks. Our system has a large Excel macro enabled template (we have Excel 2010 and Excel 2016). Occasionally a user will add pictures, charts, tabs, etc that give the error…
Lee Z
  • 802
  • 2
  • 13
  • 39
0
votes
1 answer

How to insert into already existing DBF file?

I'm having trouble with insert command into already existing DBF File. My variable fullPath = "C:\Kasa_NMP\MAT_DAY.dbf"... After I run this I get: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in…
solujic
  • 924
  • 1
  • 18
  • 43
0
votes
1 answer

SQL query with BETWEEN operator causes "Syntax error in number in query expression"

I'm using a MS Access database. I want to get first and last records that are in between 2 dates. But I get error when using a BETWEEN operator: Syntax error in number in query expression 'Datum_k BETWEEN 3.4.2017. AND 3.4.2017.'. My code: private…
solujic
  • 924
  • 1
  • 18
  • 43
0
votes
0 answers

Intermittent oledbException (0x80004005): SQL0401: Comparison operator = operands not compatible

Once in a while I see in the logs, this exception: 12:27:38,504 [8] DEBUG - Inside GetRoles USER1 12:27:38,537 [8] ERROR - Error in method, "GetRoles" . User account that invoked error- USER1 System.Data.OleDb.OleDbException (0x80004005):…
eaglei22
  • 2,589
  • 1
  • 38
  • 53
0
votes
0 answers

OleDbException: Could not update; currently locked

I am using .mdb database in ASP.NET MVC application. I am inserting multiple rows within a for loop using transaction. In case of exception, transaction is rollbacked & disposed. But if I try to insert after an exception, I am getting…
s.k.paul
  • 7,099
  • 28
  • 93
  • 168
1 2 3
…
9 10