is this post any help?
https://community.intersystems.com/post/connecting-mysql-odbc
- Log in to post comments
is this post any help?
https://community.intersystems.com/post/connecting-mysql-odbc
Also worth noting that you can create your own custom function - https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_adv#EGDV_adv_custom_utilfunctions
Alternatively, a more visual way is to use the business metrics and a DeepSee dashboard - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_bmetric
Using this format ( "2008-09-15 10:00:00" ) solved my issues with calling a stored procedure using ..Adapter.ExecuteProcedure
I've just tried something very similar but the pdf files are transferred in via ftp (set to binary) and out by ftp.
I seem to have the base64 output in the OBX segment with \X0D\\X0A\ within it. If I decode the base64 and copy into a pdf file I get a corrupt message but if I strip out the \X0D\\X0A\ manually and then decode and create a pdf file then it seems fine.
I have added a ..ReplaceStr(target.{OBX(1):5(1).3},"\X0D\\X0A\") for the moment.
Any ideas? I am using the Ens.StreamContaininer to get the Stream Container ID and then using the code within the DTL to populate my OBX segment.
Thanks