Correcting Common XP Server Problems

  1. If you are unsure whether XP Server is running, check by using sp_who. For example, if your Adaptive Server is named stores, run the following isql command:

    1> exec STORES_XP...sp_who
    2> go
    

    This command connects to XP Server and shows the spids that are currently running on XP Server.

  2. If you are not sure whether XP Server is configured, run the following command:

    1> select * from master..sysservers
    2> go
    

    This command will show a row for each server; check that the sysservers table includes the row for the XP server (the XP server name should appear in the srvname column).

  3. If XP Server is not running and you get an 11018 error when you attempt to execute an ESP, check that your interfaces file (Unix) or sql.ini file (Windows) has the correct entry for XP Server. The XP Server name must be all upper case and it should have the format ASE_SERVERNAME_XP. (See the “Error Message Writeups” chapter for a detailed explanation of Error 11018.)

  4. Check that your environment contains the correct locations of extended stored procedures and the associated DLL’s: