Using the ODBC Capability
There is now a facility to create the ODBC DSN from the Utilities tab of the Woosage Control Centre, so the information below this blue box is mainly for troubleshooting or making changes to the ODBC DSN directly.
To create or update the ODBC DSN use the Create DSN button in the Utilities tab.
If updating ODBC due to an update of Sage version, then ensure Sage is updated first.
If the
data path is on a server the UNC format should be used (e.g. \\ServerName\FolderName\FileName)
as opposed to the drive letter form.
Carry out the following steps to create a new ODBC Data Source for Woosage.
On the
Windows PC where Woosage is installed open the ODBC Data Source
Administrator (32-bit) in Windows Administrative Tools, which displays the
following:
Note: if you are using the 64-bit version of Sage you must run the 64-bit ODBC Data Source Administrator.
Select the System
DSN tab and click the Add… button, which opens the following window:
Select Sage
Line 50 vXX (where XX is the version of Sage you are using, 26 in this
example) and click the Finish button and the following window is
displayed (with empty fields).
Enter the name
for the data source as WoosageToSage, then enter the path to your Sage
data, which MUST match the path name in the Woosage settings (copy from teh settings and paste in to the Data Path field). Then click the OK button and your new ODBC data source should appear in the list as shown below.
Related Articles
Using the Vizulate Simple Role Based Pricing Plugin
Purpose Simple Role Based Pricing is a plugin provided by Vizulate to facilitate the mapping of Sage Price Lists & Special Pricing to website roles. It does not provide any other functionality, but may be used with other plugins that include RBP ...Adding New Price List Customers (when using Barn2 Plugin)
Introduction Woosage supports the application of Customer and Special Price Lists to customer roles in WooCommerce. Each Customer Price List is mapped to a website role that will apply the relevant prices to customers with a role using a 3rd ...Using the Vizulate Simple Role Based Pricing Plugin with Woosage50
Purpose Simple Role Based Pricing is a plugin provided by Vizulate to facilitate the mapping of Sage Price Lists & Special Pricing to website roles. It can be used on it's own or with wholesale/trade/B2B plugins, where we don't support their method ...Adding New Price List Customers (when using Elex Plugin)
Introduction Woosage supports the application of Customer and Special Price Lists to customer roles in WooCommerce. Each Customer Price List is mapped to a website role that will apply the relevant prices to customers using a 3rd party Role Based ...Using a Price List for website Regular Prices
We have added a feature to Woosage to allow you to use a Sage Price List to populate the Regular Prices on your website. This is useful for clients that use Sage Sales Prices for their trade/wholesale customers and want to create a Price List for ...