1 (888) 569-7711
Toll-Free:

ODBC Set-Up: Sybase

To set up a Sybase DSN: (This article is written for our PowerSchool users, if you are using another SIS please disregard mentions of PowerSchool, and your setup may need to be modified slightly.)

  1. Open the Windows Data Sources (ODBC) control panel:
    1. From the Start menu, choose Control Panel.
    2. On Windows 2000/XP, open the Administrative Tools folder.
    3. Double-click the Data Sources (ODBC) icon.
  2. This will open the ODBC Data Source Administrator:

    3. Create New Data Source

    Create Data Source
  3. On the System DSN tab, click the Add… button.

    4. Create New Data Source

    Create New Data Source
  4. From the list of drivers that appears, choose Sybase ASE ODBC Driver
  5. If you cannot find a suitable Sybase Driver you may need to install one: Sybase Driver Install
  6. Click Finish. The Sybase ODBC Driver Configuration will appear.

    7. ODBC Sybase Wire Protocol Driver Setup

    ODBC Sybase Wire Protocol Driver Setup
  7. For Data Source Name, Provide a descriptive name for your data source. This name displays on any list of data sources. ex PowerSchool
  8. Description Enter a description for this data source (optional).
  9. Network Library Name Select Winsock from the drop-down menu.
  10. Network Access Enter your server address followed by the port number. The port numbers are:

    5000 if the database resides on a Windows server
    11222 if the database resides on a Mac server

    Separate the server address and the port number with a comma (no spaces). ex: district.yourschool.com,11222
  11. Note: You are not required to enter data in the remaining fields.
  12. Click OK.
  13. Click OK again to exit the ODBC Data Source Administrator.


Your Data Source is now set up and ready to be used by the Data Extractor.


Troubleshooting:

Contact support

Toll Free
1 (888) 569-7711
Support hours
Monday-Friday
8:30AM - 3:00PM PST
Start a support request
By email