go to post Richard Housham · Jan 24, 2019 Yeah, that's the answer I got from WRC. You can't do it in 2016
go to post Richard Housham · Jan 21, 2019 Yeah, I'm on the hunt for another option.Seems like there is something in here though that says its possible.https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...Failing NTLM, is there a Negotiate option?
go to post Richard Housham · Jul 18, 2018 Had a look, almost got it but then got this. [SQLCODE: <-226>:<Gateway query Execute() failed>] [%msg: <Connection 'xxxxx': Execute: SQLState: (22018) NativeError: [0] Message: [Microsoft][ODBC Driver 11 for SQL Server]Invalid character value for cast specification >]Yeah, it's not happy.
go to post Richard Housham · Jul 17, 2018 If you use Portal (Explorer, SQL) to run a query that reports LastUpdated valuesIt's an odbc connection so it's not in the explorer > SQL
go to post Richard Housham · Jul 17, 2018 Nope my mistake, messed up my variables when renaming. Got them all ok now and still errors.
go to post Richard Housham · Jul 17, 2018 Huh, renamed the variables and seems a bit more compliant/working. Need to test it out but might have a winner!
go to post Richard Housham · Jul 17, 2018 Hi yeah, I could have them all the same name. But not sure if it'll make any difference.(I'll give it a go though).With regards data type LastUpdated is a datetime in SQL Server 2008 .I've tried to get a more updated driver see if that would help (no). I also read some stuff here on C and odbc issues.https://docs.microsoft.com/en-us/sql/relational-databases/native-client-...If I remember correctly ensemble/healthshare has a C 'core' does it not?
go to post Richard Housham · Apr 28, 2017 Cheers, thanks!Yes I'm in the UK - but with the NHS and I think my manager would prefer to send me on the course that some of the other team members have been on.That said if you have a link to your consultant, I can forward that on to my line manager - so it can't hurt.I've also got a contact myself (from a previous hospital) as well as team mates, just a forum like this is helpful for the small stuff espically when your getting started.Thanks again for your time.Richard
go to post Richard Housham · Apr 27, 2017 Yeah, just figure that... Extends Ens.RequestThanks, I'm just getting to grips with all of this. My first two productions (for real projects) have been completely different one was SOAP to SQL this is email attachment to hl7 and sending an email as well.Just seems like I don't know what's coming next!!! Combined with still not going on a course I'm still feeling my way through!!!Thanks again, under 10mins for a response!So great that I can come here and get the answers to these little things.CheersRichard
go to post Richard Housham · Apr 27, 2017 Yeah, just figure that... Extends Ens.RequestThanks, I'm just getting to grips with all of this. My first two productions (for real projects) have been completely different one was SOAP to SQL this is email attachment to hl7 and sending an email as well.Just seems like I don't know what's coming next!!! Combined with still not going on a course I'm still feeling my way through!!!Thanks again, under 10mins for a response!So great that I can come here and get the answers to these little things.CheersRichard
go to post Richard Housham · Apr 25, 2017 Running Caché for Windows using a dedicated user account (so called service account) may have some other advantages:Mmmm maybe - but given that it wasn't an option on install it's not something that our Server Guys want to do and I don't blame them really. Just seems like it could lead to places that we don't want to be.Why do you expect that libre office route would be shorter? Do you plan to use another (not $zf(-1,...)) approach?Yeah still using $ZF but instead of using word and a macro to do the conversation just use libreOffice. It can do the conversation straight out of the box (after little play with the command line options). I just wanted to use Word because I thought it would be more reliable but it was just turning into a nightmare to get working.
go to post Richard Housham · Apr 25, 2017 Running Caché for Windows using a dedicated user account (so called service account) may have some other advantages:Mmmm maybe - but given that it wasn't an option on install it's not something that our Server Guys want to do and I don't blame them really. Just seems like it could lead to places that we don't want to be.Why do you expect that libre office route would be shorter? Do you plan to use another (not $zf(-1,...)) approach?Yeah still using $ZF but instead of using word and a macro to do the conversation just use libreOffice. It can do the conversation straight out of the box (after little play with the command line options). I just wanted to use Word because I thought it would be more reliable but it was just turning into a nightmare to get working.
go to post Richard Housham · Apr 25, 2017 Thanks for your quick response it's nice to know I have a place to go when I get stuck.Having said that it's getting a bit ridiculous, install word with a macro and then to have cache run as a different user to access that macro (which might have all manner of issues). So long story short just going down the libre office route.Thanks though for the advice and your answer.Richard