Scriptcase 9.2.0010 Ubuntu 16.04.5 cannot connect to SQL Server

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 ?

Hi Vincenzo

we use Sql Server from Linux currently without problems ( almost )
The only difference is that we use Debian 9.

Giorgio

SOLVED

follow instruction at https://www.scriptcase.net/docs/en_us/v9/manual/05-scriptcase-connections/10-mssql/03-sqlserver-linux/

also modify the freetds.conf extacly where the page tells to do, in the connection use the name wrote in the freetds.conf.

Hi Vincenzo

That’s the corret approach.

Giorgio