Using the ODBC Capability

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

      Woosage50 allows you to use a Sage Price List to populate the Regular Prices on your website, which is useful if you use Sage Sales Prices for your trade/wholesale customers and want to create a Price List for retail customers, particularly if retail ...