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