go to post ED Coder · Aug 20, 2019 Hi Julius, updated the statements to include the W variant and still doesnt work for me.I think it could be something with the statement, because a select statement doesnt give me an error. Can you spot anything in the following error message?
go to post ED Coder · Aug 19, 2019 Hi Julius, Thank youYes, the driver installed is matching the cache architecture and using WINSQL I am able to successfully run the SELECT and INSERT query.So its something in my code I guess? Will keep tryingRegards,Eric
go to post ED Coder · Aug 19, 2019 Thank you Eduard,Same error running a SELECT statement as well.Is there anything that you suggest before I consider having to make changes to the conf file?Regards,Eric
go to post ED Coder · Aug 19, 2019 Hi Eduard, thank you. I tried the set param binding as well but it seems that it could be an issue with my Gateway connection.I tried linking the table and then testing my query and got the following error. The connections are all fine so dont know what is causing thisAny advice or suggestions?Regards,Eric
go to post ED Coder · Aug 19, 2019 Hi Julius, thank you for responding to my query. It seems like it is failing on "EXECUTE". The Error is : ERROR #6022: Gateway failed: ExecuteTried the set Param to bind the parameters and getting the same error. Any suggestions what could be causing this? The user has full access to the Database. It is a MYSQL DB, I have had no issues connecting to a SQL DB using the same steps.ODBC Connection is successful. Driver I am using is MySQL ODBC 8.0 Unicode DriverAny suggestions or advice on what I could check? I am able to ping the server as wellRegards,Eric
go to post ED Coder · Aug 16, 2019 Hi Guillaume, thank you so much for the screenshots and explaining it to me. I was able to establish the connection and no errors when my query runs but the data doesnt get updated in mySQL DB. Can you advice if my insert statement is correct?set pQuery = "INSERT INTO TABLENAME(column1, column2, column3, column4, column5) " set pQuery = pQuery_"VALUES("_value1_","_value2_","_value3_","_value4_","_value5_")" set sc=conn.Prepare(hstmt,pQuery)set sc=conn.Prepare(hstmt,pQuery) if $$$ISERR(sc) quit sc //Execute statement set sc=conn.Execute(hstmt) if $$$ISERR(sc) quit sc
go to post ED Coder · Aug 16, 2019 Thank You Julius, I was able to connect to the mySQL DB using the SQL gateway Connection Class. I assumed that there would be a different class to connect.
go to post ED Coder · Aug 14, 2019 You are spot on Jeff. Yes, I was thinking if I should update the schema.. but didnt do it. The message we are getting is an ORU_01 but has the EVN segment. Thank You, now I know what caused my issue too.
go to post ED Coder · Aug 9, 2019 Yes Jeff, I was looking at the cloned message that was sent across. I removed by index now, and it works. so looking good. Thank you so much for guiding me on this
go to post ED Coder · Aug 8, 2019 Was able to solve this by the following code.//create a copy of the requests newREQ = request.%ConstructClone()s ind = ""s EVNSeg = newREQ.FindSegment("EVN",.ind)if EVNSeg '= ""{s res = newREQ.RemoveSegmentAt(ind)}s request = newREQQuit request