Back to Four Js Website
Four Js Customer Forum
Subscribe for automatic updates:
RSS
Sign in for full access
|
Help
Four Js Development Tools Forum
>
Discussions by product
>
Genero BDL
>
Freetds + SQL Server 2017
Most recent posts
Pages: [
1
]
« previous
next »
Reply
|
Print
Author
Topic: Freetds + SQL Server 2017 (Read 22196 times)
Benjamin G.
Posts: 127
Freetds + SQL Server 2017
«
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
Sebastien F.
Posts: 532
Re: Freetds + SQL Server 2017
«
Reply #1 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
Benjamin G.
Posts: 127
Re: Freetds + SQL Server 2017
«
Reply #2 on:
November 09, 2019, 05:33:15 pm »
Hi,
Version
fglrun 3.00.10 rev-dee7cac
Genero virtual machine
Target s64s100
Benjamin G.
Posts: 127
Re: Freetds + SQL Server 2017
«
Reply #3 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
Sebastien F.
Posts: 532
Re: Freetds + SQL Server 2017
«
Reply #4 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
Pages: [
1
]
Reply
|
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General
-----------------------------
=> General Discussion
=> Ask Reuben
=> WWDC21
-----------------------------
Discussions by product
-----------------------------
=> Products announcements
=> Genero BDL
=> GWS
=> GAS and GBC
=> GDC
=> Genero Mobile for Android or iOS
=> Genero Studio
=> Reporting tools (GRW, GRE)
-----------------------------
Jobs
-----------------------------
=> Jobs
Powered by SMF 1.1.21
|
SMF © 2015, Simple Machines
Loading...