[Stackoverflow] [Progress OpenEdge ABL] ADO MySql Error After upgrading From MySQL 5.2 to 8.0 within Progress OpenEdge

Status
Not open for further replies.
M

MrMoonMan

Guest
Working Progress OpenEdge code started getting errors after upgrading to a newer MySql.

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...
 
Status
Not open for further replies.
Top