Erreur No 76

Menu : Parameters > General parameters > Folders (GESADS) Context : You are creating or importing a new folder Action 1 : When you hit once the validation button of the folder Error 1 : Error No 76 [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user … Action 2 : You try to validate…
Lire la suite

Comment utiliser le debug X3 et Eclipse ?

How to connect Eclipse and Sage X3? The recent trend with cloud has several side effects, on Sage X3 debugger tools. Many Sage X3 consultants encounter several issues in order to connect their Eclipse and Sage X3 in debug mode. These issues are sometimes linked to network complexity, if you are fed up with “infbox” in…
Lire la suite

Comment ajouter une base de donnée dont le nom contient un point dans Sage Enterprise Intelligence

Sometimes your database contains a dot in the identifier name. This is allowed by SQL server : https://docs.microsoft.com/fr-be/sql/relational-databases/databases/database-identifiers?view=sql-server-2017 « When identifiers are used in Transact-SQL statements, the identifiers that do not comply with these rules must be delimited by double quotation marks or brackets. » When you use SQL query you can call this database like that : [external.db] or « external.db »…
Lire la suite

Comment utiliser ATEXTRA

What is ATEXTRA ? ATEXTRA table exist since Adonix (1997) to store a part of translated text of the application. The weak point of this method is the size limitation, specificaly the maximum lenght of the boxes. It is not possible to store more than 80 characters for a box within this method. You can…
Lire la suite