C0000005 error caused by a buffer overrun while updating DB using OLEDB

[GG]

We use Common - OLEDB - ExecuteQuery, with an update query. This causes ,  memory error, specifically, a C0000005 error is an access violation error caused by a buffer overrun. What could be the solution to this ? Is there any alternative to this ?

------------------------------
Gnana Gracy Antony Santiago Raj
Developer
BNP
------------------------------

[GG]

Hi , But still this didnt work in my bot. Thanks Lakshmi Narayana for looking into this. Can you share with me the connection string and code flow so that I can check with mine? Kindly take a look at mine.

------------------------------
Gracy
------------------------------

[LakshmiNarayan3]

Hi

My connection string

 

I don't think their is issue with connection string , as it is throwing error in execution 

If possible can you share the sample file with some dummy data (replacing any sensitive data )

Simple and direct steps 

for sample data i have used you can refer above

Regards

------------------------------
Lakshmi Narayana
------------------------------

[GG]

Here you go...

Tx,

GG

------------------------------
Gracy
------------------------------

[LakshmiNarayan3]

Hi

I have tested with your file and it successfully updated the value

but this time i used single quotes for the number as it threw error stating datatype mismatch

UPDATE [Sheet1$] SET [IGNORE] = 'T' WHERE [AGREEMENT ID] = '697970'

 tested with two values both are updated

Can you try removing the IMEX=1 in connection string

if possible try this connection string "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[Input File Name With Path]&";Extended Properties=""Excel 12.0 Xml;HDR=YES"";" 

Regards

------------------------------
Lakshmi Narayana
------------------------------

[GG]

Nope, I have changed the connection string, but still the same error. 

------------------------------
Gracy
------------------------------

[GG]

Is it do with Blueprism version ? We use v6.10.1

------------------------------
Gracy
------------------------------

[PvD_SE]

Hi Gracy,

Have you looked here:
https://www.connectionstrings.com/excel/
...for the correct connection string?

------------------------------
Happy coding!
---------------
Paul
Sweden

(By all means, do not mark this as the 'Best answer'! )
------------------------------