Yeah, that's the answer I got from WRC. You can't do it in 2016

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? 

I've thrown this one to WRC who are looking at it. 

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.

If you use Portal (Explorer, SQL) to run a query that reports LastUpdated values

It's an odbc connection so it's not in the explorer > SQL

Nope my mistake, messed up my variables when renaming. Got them all ok now and still errors.

Huh, renamed the variables and seems a bit more compliant/working. 
Need to test it out but might have a winner!

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?

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

Yeah, just figure that...

Extends Ens.Request

Thanks, 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.

Cheers

Richard
 

Yeah, just figure that...

Extends Ens.Request

Thanks, 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.

Cheers

Richard
 

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.

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.

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