|
| OLE DB access error. Error Number = 170137 |
| Iniciado por Michels JÜRGEN, 01,may. 2017 18:43 - No hay respuesta |
| |
| | | |
|
| |
Miembro registrado
1 mensaje |
|
| Publicado el 01,mayo 2017 - 18:43 |
Does 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) |
| |
| |
| | | |
|
| | | | |
| | |
|