M
MrMoonMan
Guest
Working Progress OpenEdge code started getting errors after upgrading to a newer MySql.
or we I change the Options Value 32 to a different one, say 132 I get:
However, if I run the command in a database explorer
There was also an upgrade from progress 10a to 11. But we never had issues with ODBC connections after an upgrade before.
Continue reading...
Here is the code:
Code:
/* Create the connection object for the link to SQL */
Create "ADODB.Connection" ObjConnection.
/* Create a recordset object ready to return the data */
Create "ADODB.RecordSet" ObjRecordSet.
/* Create a command object for sending the SQL statement */
Create "ADODB.Command" ObjCommand.
...
PUT UNFORMATTED STRING ( l-command ) SKIP.
ASSIGN
ObjCommand:ActiveConnection = ObjConnection
ObjCommand:CommandText = ODBC-QUERY
ObjCommand:CommandType = 1 /* adCmdText */
ObjConnection:CursorLocation = 3 /* adUseClient */
ObjRecordSet:CursorType = 3 /* adOpenStatic */
ObjRecordSet
= ObjCommand:Execute ( output ODBC-NULL,
"",
-1 )
/*ODBC-RECCOUNT = ObjRecordSet:RecordCount*/
.
The Error:
Code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into IFTxCarcass ( TxDate,TxTime,TxSeq,TxChain,TxLot,GradeSF,GradeMarket,
or we I change the Options Value 32 to a different one, say 132 I get:
Code:
The number of attributes is larger than the number of attribute values provided
Query:
Code:
insert into IFTxCarcass ( TxDate,TxTime,TxSeq,TxChain,TxLot,GradeSF,GradeMarket,WeightHDW,TxSex,Operator,FatClass,HookRFID,ChillerGroupCode,Barcode,MSAEligibleFlag )
However, if I run the command in a database explorer
SQLYog
it works fine.Additional:
There was also an upgrade from progress 10a to 11. But we never had issues with ODBC connections after an upgrade before.
Continue reading...