Installing ODBC MetaData stored procedures

The ODBC MetaData stored procedures ensure that ODBC functionalities behave as expected. Sybase recommends that you install these procedures on all the Adaptive Server servers that you need to connect to using ODBC.

This procedure installs the ODBC MetaData stored procedures in sybsystemprocs.

To run the script successfully, you need permission to create stored procedures in sybsystemprocs.

1. Go to the sp directory under the Adaptive Server ODBC Driver installation directory:

   • Adaptive Server ODBC Driver 32-bit for Microsoft Windows: %SYBASE%\DataAccess\ODBC\sp

   • Adaptive Server ODBC Driver 64-bit for Microsoft Windows: %SYBASE%\DataAccess64\ODBC\sp

   • Adaptive Server ODBC Driver 32-bit for Linux and Apple Mac OS X: $SYBASE\DataAccess\ODBC\sp

   • Adaptive Server ODBC Driver 64-bit for UNIX: $SYBASE\DataAccess64\ODBC\sp

2. Execute the install_odbc_sprocs script.

   • Adaptive Server ODBC Driver for Microsoft Windows:

     install_odbc_sprocs ServerName username 
        [password]
     

   • Adaptive Server ODBC Driver for UNIX and Apple Mac OS X:

     ./install_odbc_sprocs ServerName username
        [password]
     

   where:

   • ServerName is the name of the Adaptive Server.

   • username is the user name to connect to the server.

   • [password] is the password for the user name. If the value is null, leave the parameter empty.