Installing OLE DB MetaData stored procedures

You must install the OLE DB MetaData stored procedures on any Adaptive Server that you want to connect to using the OLE DB Provider.

StepsInstalling OLE DB stored procedures on Adaptive Server

  1. Change to the sp directory under the OLE DB installation directory.

    • For OLE DB 32-bit: %SYBASE%\DataAccess\oledb\sp

    • For OLE DB 64-bit: %SYBASE%\DataAccess64\oledb\sp

  2. Execute the install_oledb_sprocs script:

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