Scriptcase version 9.11 Bugs with MSSQL

Scriptcase 9 Bugs
#1

I just move from 9.10.023 to 9.11.006

Now I get this error

Connection attempt failed: SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user ‘sa’

It seem to be limited to the new menu and the old menu app

I move back to 9.10.023 and the error is not happening

#2

I’m using
image

it’s been working so far

#3

DBLIB is not available on the production server

Only
MSSQL Server NATIVE SRV PDO
MSSQL Server Native SRV
MSSQL Server Server ODBC

The MSSQL Server NATIVE SRV PDO and MSSQL Server Native SRV have the same problem

#4

@jlboutin60 I’m not sure, maybe try updating the production files from Scriptcase Download Add-ons | PHP code generator | Forms and Reports Builder ??

I switched to dblib when I upgraded my server for scriptcase with php 8

#5

Production files are up to date

Thanks anyway

#6

I have done more test and the bug is only happening in the menu (old and new), so I have to go back to 9.10.023, since the menu is essential.

@Henrique_Barros , are you able to look at this please

#7

I don’t have access to an environment with MSSQL (I work on linux), but I’ll ask test team to try and replicate this for me. I’ll let you know when I identify the issue.