Sorry, but there are no more tags available to filter with.
-
When linking to MAS 200, if you link directly you use the Providex ODBC driver. This has its own SQL syntax. For example, to use a function in a SQL SELECT , you need to use: {fn current_date()} like this: select field1, {fn current_date()} from table See the attached document for more information.
-
MAS 200 uses the Pervasive database system, and pulling data from it can be a bit difficult. Belinda Zenk of Argenta Sytems has contributed the following notes on how to use SQL Server to create a linked server to the MAS 200 database. This means that Inaport can read from the linked tables in SQL Server...
Page 1 of 1 (2 items)