pcsoft.us.windevCopyright 2026, PC SOFT1 May 2017 18:43:54 Z1 May 2017 18:43:54 ZDoes somebody have an idea, how can I repair this problem? I work with WINDEV 21 and MSSQL. I appeal to the DB with Microsoft ODBC Driver for SQL Server Version 12.00.2000. In a table a field "Free_Info" is defined as varbinary (1002), not null. By the takeover in the DataModell of WINDEV the field has been taken over as a "text" from the Sub type "Text memo" (Type Multi-Line-Text) If I try to write a new record with HADD I receive the following error: Error at line 41 of Global Procedure Protokoll_Gerät process. HAdd function called. OLE DB access error. Error Number = 170137 Failure saving value of <Free_Info> item present in <> file. Check whether <adVarBinary> items are supported by your provider. Value = <GerID 503211 nach Audit eingelagert. | Eingelagert auf : STO: TAL -Talheim - LO: 2-HochRegalLager - LP: H. 1.02.03> System Error Details: Description = Fehler bei einem aus mehreren Schritten bestehenden OLE DB-Vorgang. Prüfen Sie die einzelnen OLE DB-Statuswerte, falls vorhanden. Daten wurden nicht verarbeitet . Source = Microsoft OLE DB Provider for SQL Server Error Number = -2147217887 (0x80040e21) ----- Technical Information ----- Project : LIAS_Warrenwirtschaft WL call: Process of 'Global Procedure Protokoll_Gerät' (COL_Verarbeitungsroutinen.Protokoll_Gerät), line 41, thread 0 'HAdd' function, syntax 1 What happened? OLE DB access error. Error Number = 170137 Failure saving value of <Free_Info> item present in <> file. Check whether <adVarBinary> items are supported by your provider. Value = <GerID 503211 nach Audit eingelagert. | Eingelagert auf : STO: TAL -Talheim - LO: 2-HochRegalLager - LP: H. 1.02.03> Error code: 73001 Level: fatal error WD55 error code: 3001 System error message: Description = Fehler bei einem aus mehreren Schritten bestehenden OLE DB-Vorgang. Prüfen Sie die einzelnen OLE DB-Statuswerte, falls vorhanden. Daten wurden nicht verarbeitet . Source = Microsoft OLE DB Provider for SQL Server Error Number = -2147217887 (0x80040e21) Dump of the error of 'wd210hf64.dll' module (21.0.124.5). Identifier of detailed information (.err): 72801 Debugging information: IEWDOLDB=113.9 Module=<WDOLDB> Version=<21.0.11.0> Provider: SQLOLEDB User: sa Data source: JMLAP\MSSQLSERVER2014 Database: LIAS_Nexchance Connection time-out: 30 Command time-out: 30 Unicode supported: 1 Page code of WL: 1252 Page code of the connection: UTF-16 MDAC Version = <6.3.9600.16384>. [Data format] Query Parameter Checked = <1> = <INTEGER> Query Parameter Needing conversion = <97> = <INTEGERBOOLDECIMAL> DecimalSeparator = <Undefined> DateFormat = <Undefined> [Cursor settings Match] LockType = <adLockOptimistic>, Location = <adUseServer>, Type = <adOpenKeyset>, Capacities = <10fef00> LockType = <adLockPessimistic>, Location = <adUseServer>, Type = <adOpenKeyset>, Capacities = <10fef00> LockType = <adLockUnspecified>, Location = <adUseNone>, Type = <adOpenUnspecified>, Capacities = <ffffffff> [Recordset 1] Settings = <LockType = <adLockPessimistic>, Location = <adUseServer>, Type = <adOpenKeyset>, Capacities = <10fef00>> CapacitiesSupported = <adAddNew;adApproxPosition;adBookmark;adDelete;adFind;adHoldRecords;adMovePrevious;adNotify;adResync;adUpdate;adUpdateBatch;> CapacitiesNotsupported = <adIndex;adSeek;> HFFunctionsSupported = <HAjoute;HSupprime;HModifie;HPositionCourante;HAvance;HRecule;HLitPremier;HLitSuivant;HLitPrecedent;HRecherche;> HFFunctionsNotsupported = <> [Recordset 2] Settings = <LockType = <adLockOptimistic>, Location = <adUseServer>, Type = <adOpenKeyset>, Capacities = <10fef00>> CapacitiesSupported = <adAddNew;adApproxPosition;adBookmark;adDelete;adFind;adHoldRecords;adMovePrevious;adNotify;adResync;adUpdate;adUpdateBatch;> CapacitiesNotsupported = <adIndex;adSeek;> HFFunctionsSupported = <HAjoute;HSupprime;HModifie;HPositionCourante;HAvance;HRecule;HLitPremier;HLitSuivant;HLitPrecedent;HRecherche;> HFFunctionsNotsupported = <> Fonction (7,0) Additional Information: EIT_NATIVECODE : <170137> EIT_ADOCODE : <-2147217887> EIT_BASECODE : <0> EIT_ODBCDESCRIPTION : <Fehler bei einem aus mehreren Schritten bestehenden OLE DB-Vorgang. Prüfen Sie die einzelnen OLE DB-Statuswerte, falls vorhanden. Daten wurden nicht verarbeitet .> EIT_LOGICALTABLENAME : <LOG_Geräte> EIT_PILEWL : Global Procedure Protokoll_Gerät (COL_Verarbeitungsroutinen.Protokoll_Gerät), line 41 Global Procedure Lagerfachsatz_anlegen_Teil1 (COL_Verarbeitungsroutinen.Lagerfachsatz_anlegen_Teil1), line 74 Global Procedure Lagerplatz_suchen (COL_Verarbeitungsroutinen.Lagerplatz_suchen), line 63 Click BTN_Verarbeiten ( SC_SuperControl1 ) (WIN_Audit_ArtikelModell.SC_SuperControl1.BTN_Verarbeiten), line 25 EIT_DATEHEURE : 01/05/2017 18:07:59 EIT_TYPE_WDFILE : <7> EIT_IDCODE : <458752> Help if the code : LOG_Geräte.GSDID = GerID LOG_Geräte.Datuma = DateSys() LOG_Geräte.Geraetedurchlaufstatus = Durchlaufstatus LOG_Geräte.LLFAC_GID = Fachsatz_GID LOG_Geräte.ProgrammName = ProgrammName LOG_Geräte.Timea = TimeSys() LOG_Geräte.Usera = gsUser_Angemeldet LOG_Geräte.Free_Info = Info_Text GID_Erzeugen(LOG_Geräte.LOGGID, ProgrammName,gsUser_Angemeldet,gnFirmenNr_Standard) HAdd(LOG_Geräte)30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60718-ole-access-error-error-number/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)