This guide will take you through the Sybiz ODBC driver setup to allow the Web Ninja connection to the Sybiz database.
Note that you will need the following Sybiz details to complete the set-up:
- Server name
- Systems administrator (sa) username and password
- Database name
First, locate the 32-bit ODBC Data Source Administrator by navigating here:
c:\windows\syswow64\odbcad32.exe
Create a new data source under the System DSN by clicking 'Add'.
Locate the SQL server, highlight it and click 'Finish'.
Name the data source 'wn_sybiz' and then select the Server that the Sybiz database is installed on. Note that if it does not appear in the Server drop-down menu, you may need to type it in.
Next, tick the 'Change the default database to:' check box and then select the Sybiz database from the drop-down menu. This should be the live database.
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 screenshot below. Click 'OK' to complete the driver set-up.
Pass the ODBC driver name (if different to wn_sybiz), username and password onto your Web Ninja contact so they can complete the configuration set-up in the Web Ninja control panel.
Once the ODBC driver is set up, contact the Sybiz partner and get these details for your Web Ninja contact:
-
ODBC Driver Version: Should use the SQL Server Native Client 11.0
-
SQL Server Location: This is the location/name of the SQL Server EG. myServer\SQLSERVER
-
Database Name: This is the name of your database (case sensitive)
-
Common Server Name: This is the name of your common server which stores the different companies and dictates access rights. This is used for writing orders back to Sybiz Vision. Leave blank to use the Server above
-
Common Database Name: This is the name of your common database which stores the different companies and dictates access rights. This is used for writing orders back to Sybiz Vision
-
ODBC Username: The ODBC Username used to connect to your Database
-
ODBC Password: The ODBC Password used to connect to your Database
-
Application Username: The Application username for our system to create sales orders. Cannot be a login other users use to login otherwise orders will not write back
-
Application Password: The Application password for the username above