This guide will take you through the ODBC driver set-up to allow the Web Ninja connection to the Jiwa database.
First, locate the 32 bit ODBC Data Source Administrator by navigating here:
Create a new data source under the System DSN by clicking 'Add'.
Click 'Add' and locate the SQL Server. Highlight it and then click 'Finish'.
Name the drive wn_jiwa, select the server then click 'Next'.
Select 'With SQL Server Authentication using a login ID and password entered by the user.' and enter the systems administrator login ID and password, then click 'Next'.
Next, tick the 'Change the default database to:' check box and then select the database from the drop down menu. Click next to complete the window.
Finally, click 'Finish' and then click 'Test Data Source'. If you have configured the ODBC Driver correctly, you should see the window as shown in the screen shot below. Click 'OK' to complete the driver set-up.
Pass the ODBC driver name (if different to wn_jiwa), sa username and password onto your Web Ninja contact so they can complete the configuration set-up in the Web Ninja control panel.