Instead of
SELECT MAX(ORDEN)
FROM demo_planta2.dbo.ORDEN_VENTA_CAB
Use an alias in the projection column:
SELECT MAX(ORDEN) foo
FROM demo_planta2.dbo.ORDEN_VENTA_CAB
Juan
On Fri, May 12, 2023 at 8:46 PM scott wrote:
> Hello Luis, Juan Pablo,
> I think I'm having the same issue with ExecuteSQ
Hello Luis, Juan Pablo,
I think I'm having the same issue with ExecuteSQL to connect with Azure
serverless SQL endpoint using Active Directory. I have downloaded the
official microsoft jdbc driver and all dependent jars, and my results seem
the same as Luis reported. I am not sure what was done her
Thanks Juan Pablo.
It did work !!
Thanks.
LC
On Fri, 2020-05-08 at 13:54 -0300, Juan Pablo Gardella wrote:
> Try again by adding a column alias name tonthe results.
>
> On Fri, May 8, 2020, 12:21 PM Luis Carmona
> wrote:
> > Hi juan Pablo,
> >
> > I did, but jTDS was the only way achive
Hi juan Pablo,
I did, but jTDS was the only way achive the connection. With the
offical jdbc driver always issued error about TSL protocol problems.
After some reading, seems to be it is cause the SWL server is too old.
And with jTDS I got the coneection, and was able to execute Database
list Ta
Try again by adding a column alias name tonthe results.
On Fri, May 8, 2020, 12:21 PM Luis Carmona wrote:
> Hi juan Pablo,
>
> I did, but jTDS was the only way achive the connection. With the
> offical jdbc driver always issued error about TSL protocol problems.
>
> After some reading, seems to
Did you try using mssql official jdbc driver?
On Fri, 8 May 2020 at 01:34, Luis Carmona wrote:
> Hi everyone,
>
> I am trying to execute a query to an MS SQL Server, through jTDS
> driver, but can't figure why is it giving me error all the time.
>
> If I let the processor as it is, setting the c
