Looking for something?
Follow

Sybiz ODBC Driver Set-up

This guide will take you through the Sybiz ODBC driver set-up 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'.

mceclip2.png

 

Locate the SQL server, highlight it and click 'Finish'.

 

mceclip3.png

 

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.

 

mceclip0.png

 

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 screen shot 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.

 

Let us know if this information has been helpful.
We'd love to hear your feedback!

0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk