Any real example for UNIFACE dbms.asn SQL connection

Author: grigorfortran@gmail.com (_baterfly)

Hi, I've tried to create database access to SQL Server Express. Want to use Integrated security, so in the PATHS section write

$MSS MSS:SQLEXPRESS:TestDataBase||.

But every time receive  8008 Assignment statement error.

If you have any Idea ? Welcome :)

[DRIVER_SETTINGS]
U3.0
USYS$MSS_PARAMS = hs:on, ids:quoted, procs:off,locktime:360, keysetcursor:on,checks:off

[PATHS]
$MSS MSS:TestDataBase:UnifaceEx||

$MSS = TestDataBase:UnifaceEx||
$IDF = $MSS
$SYS = $MSS
$UUU = $MSS
$DEF = $MSS

 

4 Comments

  1. Hello,

    In the [DRIVER_SETTINGS] you have to specify the mnemonic of the Microsoft SQL Server connector (MSS) and the version of the connector. For example:

    [DRIVER_SETTINGS]
    MSS=U3.0

    For more info see the following chapters in the Uniface documentation:

    I hope the provided information is helpful.

    Kind regards,
    Daniel


    Author: diseli (daniel.iseli@uniface.com)
  2. And I think the second definition of $MSS is not needed.


    Author: Iain Sharp (i.sharp@pcisystems.co.uk)
  3. Indeed! Thanks Iain, for spotting that error. This line is also most likely the cause for the 8008 error, since there's no connector specified in the ($MSS) path. The first path definition on the other hand is correct.

    $MSS MSS:TestDataBase:UnifaceEx||


    Author: diseli (daniel.iseli@uniface.com)
  4. Hi Grigory

    In your ASN-File there a few errors :-)

    This one should work:
    --------------------

    [DRIVER_SETTINGS]
    ; Wich driver version to use
    MSS=U3.0

    ; Which parameter for connection
    USYS$MSS_PARAMS = hs:on, ids:quoted, procs:off,locktime:360, keysetcursor:on,checks:off

    [PATHS]
    ; "Open" the database on a SQL-server (where "TestDataBase" is the ODBC name and UnifaceEx the database name))
    $MY_PATH MSS:TestDataBase:UnifaceEx||

    ; Assign the open path to the "default" pathes of UnifAce
    $IDF = $MY_PATH
    $SYS = $MY_PATH
    $UUU = $MY_PATH
    $DEF = $MY_PATH
    --------------------

    ========= Or (as we strukture our database) ===========

    --------------------
    [DRIVER_SETTINGS]
    MSS=U3.0
    USYS$MSS_PARAMS = hs:on, ids:quoted, procs:off,locktime:360, keysetcursor:on,checks:off

    [PATHS]
    ; assume, there is a ODBC source "Test_SQL_server" connecting the the SQL-server
    ; On this server, there are two databases
    ; DataBase_Model : The meta dictonary of UnifACe
    ; DataBAse_Data : The "real" application data

    ; "Open" UnifAce meta dictonary
    $PATH_MODEL MSS:Test_SQL_Server:DataBase_Model||

    ; "Open" application data
    $PATH_DATA MSS:Test_SQL_Server:DataBase_Data||


    ; Map the pathes to the internal UnifAce pathes
    $IDF = $PATH_MODEL
    $SYS = $PATH_MODEL
    $UUU = $PATH_MODEL
    $DEF = $PATH_DATA

    --------------------

    So you can easy separate development and deployment :-)

    Regards
    Ingo


    Author: istiller (i2stiller@gmx.de)