Installing ODBC MetaData stored procedures

You must install the ODBC MetaData stored procedures on any Adaptive Servers that you want to connect to using the ODBC Driver.

Windows

StepsTo install the stored procedures on a target Adaptive Server on Windows

  1. Change to the sp directory under the ODBC installation directory.

  2. Execute the install_odbc_sprocs script:

    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.

Linux

StepsTo install the stored procedures on a target Adaptive Server on Linux

  1. Change to the sp directory under the ODBC installation directory.

  2. Execute the install_odbc_sprocs script:

    ./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.