Four Js Development Tools Forum

Hello,

I have Problems to configure the easysoft ODBC-Driver on a Linux-Server to connect to a MS SQL-Server with Genero (2.50).

Has anyone done anything like this before?
Which entry must I set in the odbc.ini File, and what about the Connection-String in the 4GL-Program?

Any help is welcome.


Kind regards

Stefan Serwe

Hi Stefan,

about one year ago it worked on 2.41 !

i've followed the instruction about easysoft ODBC-Driver in the Genero Manual.

the connection string on 4gl:

let txt_db = g_database clipped,
             "+driver='dbmftm90'",
             ",source='odbc_name'",
             ",username='xx'",
             ",password='yyyyyy'"

then:

connect to txt_db as "connection_identifier"


hope this help you !

bye

Hello Stefan,

Next time please contact you support for help in such case.

Basically, to connect to SQL Server with the EASYSOFT ODBC driver, you need to:

- Install and license the EASYSOFT ODBC driver

- Set EASYSOFT_ROOT env var to the installation dir (ex: EASYSOFT_ROOT=/usr/local/easysoft)

- Add $EASYSOFT_ROOT/lib:$EASYSOFT_ROOT/sqlserver/lib to LD_LIBRARY_PATH

- Define ODBCINI env var to your odbc.ini file

- Configure the odbc.ini file with a data source entry like:

[mydatasource]
Driver=Easysoft ODBC-SQL Server
Description=Easysoft SQL Server ODBC driver
Server=<hostname>
Port=1681
Database=<sqlserver_dbname>
Client_CSet=<you_charset>   (like UTF-8 for ex)
Mars_Connection=No
Logging=No
LogFile=/tmp/odbc.log
QuotedId=No
AnsiNPW=Yes
Language=
Version7=No
ClientLB=No
Failover_Partner=
VarMaxAsLong=No
DisguiseWide=No
DisguiseLong=No
Trusted_Connection=No
Trusted_Domain=
IPv6=No

For Genero, you must not use the dbmftm90 ODI driver, but one of the dbmesm* drivers, according to the version of SQL Server.

dbmesm90 = SQL Server 2005
dbmesmA0 = SQL Server 2008
dbmesmB0 = SQL Server 2012

Pass the ODBC data source to the CONNECT TO instruction

MAIN
        CONNECT TO "mydatasource+driver='dbmesmB0'" USER "dbuser" USING "pswd"
        ...
END MAIN
 

You may also consider to define the database driver as default driver in your FGLPROFILE, so you don't need to specify it in your program:

dbi.default.driver = "dbmesmB0"

For more details see the documentation:
https://4js.com/online_documentation/fjs-fgl-manual-html/?path=fjs-fgl-manual#c_fgl_Connections_001.html
https://4js.com/online_documentation/fjs-fgl-manual-html/?path=fjs-fgl-manual#c_fgl_Connections_009.html
https://4js.com/online_documentation/fjs-fgl-manual-html/?path=fjs-fgl-manual#t_fgl_odiagmsv_004.html

Seb