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
Local Administrator
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)
Local Administrator
And I think the second definition of $MSS is not needed.
Author: Iain Sharp (i.sharp@pcisystems.co.uk)
Local Administrator
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)
Local Administrator
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)