OLE DB error Code 80040E00h

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Komutel
Posts: 2
Joined: Tue 05 Mar 2013 18:48

OLE DB error Code 80040E00h

Post by Komutel » Tue 05 Mar 2013 18:57

Hi,
I'm using SDAC 4.3.5 and I didn't get much problem until now.
Everything is going well for a while, but for a reason I can't figure, I'm getting and OLE DB error 80040E00h. After that, I keep getting that error really often until a restart my application.
Have you ever seen such an error?
If so, do you have any fix or workaround at least?
Thanks!

AndreyZ

Re: OLE DB error Code 80040E00h

Post by AndreyZ » Wed 06 Mar 2013 10:39

Hello,

Please try using the latest SDAC version 6.6.12 and check if the problem remains. If it does, please try creating a small sample that demonstrates this problem and send it to andreyz*devart*com . Also, please specify the following:
- the exact version of your IDE;
- the exact version of SQL Server server and client. You can learn it from the Info sheet of TMSConnection Editor.

Komutel
Posts: 2
Joined: Tue 05 Mar 2013 18:48

Re: OLE DB error Code 80040E00h

Post by Komutel » Wed 06 Mar 2013 13:46

I would like to try the latest version, but I can't really do that.
The problem happens after a few hours and we can't reproduce it in our lab, but it keeps happening to one of our client. We can't test it out in our client's environment.
I'm presently trying to reproduce the error in our lab. If I can reproduce, is there a trial or something I can use to try the latest version without buying it now? I don't want to buy something I won't use if it doesn't help me.
I forgot to mention that it happens when the connection is used a lot through only one connection object.
Thanks!

AndreyZ

Re: OLE DB error Code 80040E00h

Post by AndreyZ » Thu 07 Mar 2013 09:18

You can download SDAC Trial version at http://www.devart.com/sdac/download.html
We are looking forward to receiving your sample.

LeoMendez
Posts: 5
Joined: Tue 29 May 2012 21:37

Re: OLE DB error Code 80040E00h

Post by LeoMendez » Thu 08 Jul 2021 19:52

Hello , I'm Using 7.1.4 XE7 ( Buyed version ) And im having the same issue.
The annoying thing is that if use My old Sdac and delphi6E with The same code , the error never ocurrs , even if y run the application all Week.

Image of the error : http://cloud.financialtech.cl/dl.php?f= ... 2127C0DD3C

The error is independent of the procedure , but i paste one of them.

procedure TForm1.TRAE_MAX_DIAImage;
VAR

QUERY,fecha, NEMOTEC:string;

BEGIN
//Edit_Fecha.Text:=FormatDateTime('YYYYMMDD',Date());
WITH MSQuery_ticks_maxnetd DO
BEGIN
NEMOTEC:='1';
// VirtualTable2.Clear;
Params.Clear;
SQL.Clear;
query:=' EXEC Dbo.SElECT_MAX_CLP_DTTC @V_FECHA = '''+FormatDateTime('YYYMMDD',now())+'''';
SQL.Add(QUERY);
Close;
TRY
OPEN;
wHILE NOT MSQuery_ticks_maxnetd.eof DO
BEGIN
FormatSettings.DecimalSeparator:='.';
Edit_high.Text:=Fields[0].Text;
Edit_high.Text:=AnsiReplaceStr(Edit_high.Text,',','.');
V_HIGH:=StrToFloat(Edit_high.Text);
next;
END;
EXCEPT
MessageDlg('ERROR DE BASE DE DATOS AL CONSULTAR MAX', mtInformation, [mbOk], 0);
END;
end;
END;


Is kind of overwhelming
Many thanks in advanced

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: OLE DB error Code 80040E00h

Post by Stellar » Wed 14 Jul 2021 08:58

Unfortunately, we couldn't reproduce the issue. To investigate this behavior of SDAC, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html

Post Reply