Sage 100 ProvideX

From Data Islands

With ProvideX you must have a 64 bit ODBC driver.

Within ODBC add in your connection as a system DSN



You can generate part of the connection string from here and add in the


part as required (if you do not do this you are prompted for credentials for every query)

Example command to add in the connection to the Data Islands console app

>addserver odbc "DSN=DIMAS100;UID=USERNAME;PWD=PASSWORD;Company=ABX; Directory=C:\Sage\Sage 100 Standard\MAS90; Prefix=C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\; ViewDLL=C:\Sage\Sage 100 Standard\MAS90\HOME; LogFile=\PVXODBC.LOG; SERVER=NotTheServer"