Four Js Development Tools Forum

Discussions by product => Genero BDL => Topic started by: Benjamin G. on November 09, 2019, 10:30:31 am



Title: Freetds + SQL Server 2017
Post by: Benjamin G. on November 09, 2019, 10:30:31 am
Hi,

We 're facing with a connection problem with Freetds 1.1.20 under Solaris 10 (Sparc) against SQL Server 2017. With SQL Server 2014 work's fine.
Here by technical infos :

# ../bin/tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v1.1.20
             freetds.conf directory: /opt/freetds141/etc
     MS db-lib source compatibility: no
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: yes
                        TDS version: auto
                              iODBC: no
                           unixodbc: yes
              SSPI "trusted" logins: no
                           Kerberos: no
                            OpenSSL: yes
                             GnuTLS: no
                               MARS: yes


# ../bin/tsql -S ptv_prod -U SMARTOUR -P SMARTOUR
locale is "C"
locale charset is "646"
using default charset "ISO-8859-1"
1> select @@VERSION
2> go

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)
        Aug 22 2017 17:04:49
        Copyright (C) 2017 Microsoft Corporation
        Express Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)

/opt/unixodbc64/etc/odbc.ini :

[ptv_prod]
Driver=/opt/freetds141/lib/libtdsodbc.so
TDS_Version=7.3
Server=vmptv.provencale.ad
Database=PTV_LP_TransferDB
Port=1433
Trace=No

flgrun :

SQL: CONNECT
 | 4gl source      : main.4gl line=41
 | loading driver  : [/opt/fourjs/genero/V3.00.29/fgl/dbdrivers/dbmftm_0]
 | db driver type  : ftm
 | ftm.c:00185(3)  : Connection parameters for 'ptv + driver='dbmftm90' ,source = 'ptv_prod',username = 'SMARTOUR', password= 'SMARTOUR'':
 | ftm.c:00187(3)  :  ODBC Data source = 'ptv_prod'
 | ftm.c:00188(3)  :  User name        = 'SMARTOUR'
 | ftm.c:00189(3)  :  Password         = '*'
 | ftm.c:00190(3)  :  Login timeout    = 'default'
 | ftm.c:00191(3)  :  Prefetch rows    = 'default'
 | ftm.c:00218(1)  : Could not identify the SQL Server version
 | sqlcode         : -6319
 |   sqlstate      : HY000
 |   sqlerrd2      : -1
 |   sql message   : Internal error in the database library. Set FGLSQLDEBUG to get more details.
 |   sql msg param :
 | curr driver     : ident='dbmftm_0'
 | curr connection : ident='none' (dbspec=[none])
 | Execution time  :   0 00:00:00.02553

Thanks for help





Title: Re: Freetds + SQL Server 2017
Post by: Sebastien F. on November 09, 2019, 03:37:27 pm
Hello,

What is the Genero FGLGWS version (fglrun -V) ?

I suspect that you have an old Genero version that is not certified with SQL Server 2017.

Please try with Genero FGLGWS 3.20.

https://4js.com/download/products/?

Seb


Title: Re: Freetds + SQL Server 2017
Post by: Benjamin G. on November 09, 2019, 05:33:15 pm
Hi,

Version

fglrun 3.00.10 rev-dee7cac
Genero virtual machine
Target s64s100



Title: Re: Freetds + SQL Server 2017
Post by: Benjamin G. on November 09, 2019, 05:37:59 pm
i've just check with "strings dbmfmt_0.so" and result :

SELECT @@VERSION
Could not execute SELECT @@VERSION.
Couldn't bind for server version.
Couldn't fetch for server version.
Couldn't close cursor for server version.
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008
SQL Server 2005

seems that 2017 is not supported ...
we 'll try with 3.20



Title: Re: Freetds + SQL Server 2017
Post by: Sebastien F. on November 09, 2019, 05:41:29 pm
Yes good idea to install 3.20!

FYI we provide a platform and database support matrix for each version of Genero.

Please check:

http://4js.com/mirror/documentation.php?s=genero&f=fjs-genero-3.00.XX-PlatformsDb.pdf
http://4js.com/mirror/documentation.php?s=genero&f=fjs-genero-3.10.XX-PlatformsDb.pdf
http://4js.com/mirror/documentation.php?s=genero&f=fjs-genero-3.20.XX-PlatformsDb.pdf

Seb