Sage 100 ProvideX: Difference between revisions

From Data Islands
(Created page with "With ProvideX you must have a 64 bit ODBC driver. Within ODBC add in your connection as a system DSN 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"")
 
No edit summary
Line 4: Line 4:
Within ODBC add in your connection as a system DSN
Within ODBC add in your connection as a system DSN


[[File:sage100 providex system dsn.png]]


[[File:sage 100 providex 1.png]]
[[File:sage 100 providex 2.png]]
[[File:sage 100 providex 3.png]]


Example command to add in the connection to the Data Islands console app
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"
>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"

Revision as of 16:51, 28 February 2023

With ProvideX you must have a 64 bit ODBC driver.


Within ODBC add in your connection as a system DSN

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"