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