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:

• Uniface Library > DBMS Support > Database Connectors > DBMS Connector Overview

• Uniface Library > Uniface Reference > Configuration Settings: Assignment > Assignment Files and Syntax > [DRIVER_SETTINGS]

I hope the provided information is helpful.

Kind regards,
Daniel

And I think the second definition of $MSS is not needed.

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

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