Troubleshooting a MSSQL Connection

Problem: When using a MSSQL connection, if you use a non-existent database name, such as the default name, pubs, the connection succeeds, but the error log receives continuous errors.

Solution: When you create the MSSQL connection, remove the default name, pubs, from the connection URL, jdbc:sqlserver://localhost:1433;databaseName=pubs, and enter the correct database name.


Created September 17, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com