Ubuntu 16.04.5 64bit
Installed Scriptcase 9.2.0009 and then updated to 9.2.0010
Installed unixODBC and Freetds, also SQL Server driver for PHP 7 and also odbc driver for SQL Server.
tried to create a connection to SQL Server, the only options available is DBLIB, on thest connection I see error:
Errore di connessione
Connection attempt failed: SQLSTATE[HY000] (null) (severity 2)
I tried also ODBC, dsn1 -> sql server odbc driver dsn2 -> freetds
I get error
odbc_connect(): SQL error: [unixODBC][Driver Manager]Can’t open lib ‘/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1’ : file not found, SQL state 01000 in SQLConnect
and
odbc_connect(): SQL error: [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so’ : file not found, SQL state 01000 in SQLConnect
on terminal mode, using isql I can connect dsn1 and dsn2 without problem.
On apache2 and php 7 on same server, i tried few php rows to try PDO_DBLIB and it works, so PHP environment works Sctipcase environemt doesn’t.
I tried also to let PHP Scriptase to load /usr/lib/php/20151012/sqlsrv.so but in the log file seems that a 32bit php cannot load a 64bit dynamic library, but I installed the 64bit Scriptcase for Linux.
Any hint ?