The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,862 other subscribers

“Delphi” “Data provider or other service returned an E_FAIL status” “NVARCHAR” – Google Search

Posted by jpluimers on 2021/06/22

For my link archive: [Archive.is] “Delphi” “Data provider or other service returned an E_FAIL status” “NVARCHAR” – Google Search

In this case it was while reading data. Cause yet unknown, as over time the error disappeared before it could be investigated further.

My initial thoughts:

  • local field size too small for actual content
  • character set mapping issue for certain locales

I recommended checking with [WayBack/Archive.is] bitbucket.org/jeroenp/wiert.me/src/default/Native/Delphi/Library/RTL/i18n/FormatSettingsHelperUnit.pas to see which locale ID and name the process was running under.

Related (but not the cause as this occurred while writing data, not reading): [WayBack] sql server 2008 – Why am I getting Data provider or other service returned an E_FAIL status? SQL Native Client – Stack Overflow

–jeroen

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.