Sage 100 ProvideX - Revision history

WikiSysopdi at 16:57, 26 March 2025

2025-03-26T16:57:17Z

← Older revision		Revision as of 16:57, 26 March 2025
Line 15:		Line 15:
	[[File:sage 100 providex 2.png]]		[[File:sage 100 providex 2.png]]

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

	UID=USERNAME;PWD=PASSWORD;Company=ABX		UID=USERNAME;PWD=PASSWORD;Company=ABX

WikiSysopdi at 16:53, 28 February 2023

2023-02-28T16:53:42Z

← Older revision		Revision as of 16:53, 28 February 2023
Line 2:		Line 2:


	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:sage100 providex system dsn.png]]

			-

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

			-

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

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

			UID=USERNAME;PWD=PASSWORD;Company=ABX

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

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

WikiSysopdi at 16:51, 28 February 2023

2023-02-28T16:51:05Z

← Older revision		Revision as of 16:51, 28 February 2023
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"

WikiSysopdi: 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""

2023-02-28T16:49:01Z

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""

New page

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"