Announcement

Collapse
No announcement yet.

Scriptcase 9.2.0010 Ubuntu 16.04.5 cannot connect to SQL Server

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 ?







    Last edited by Vincenzo; 09-28-2018, 09:24 AM.

  • #2
    Hi Vincenzo

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

    Giorgio
    Giorgio Bravi
    Dolphin Software & Thinkware

    Comment


    • #3
      SOLVED

      follow instruction at https://www.scriptcase.net/docs/en_u...lserver-linux/

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




      Comment


      • #4
        Hi Vincenzo

        That's the corret approach.

        Giorgio
        Giorgio Bravi
        Dolphin Software & Thinkware

        Comment

        Working...
        X