Deleting a service from services.msc


In order to delete a service from the windows services list, use sc command tool
sc delete ServiceName
Ex:- sc delete ZTime

Check the sc command help for other options available.

DSPMSGD - Display Message Descriptions

Go to Green screen and execute the following command to know more about the error message code.



DSPMSGD RANGE(SQL0551) MSGF(QSQLMSG)

cannot set a credential for pricipal 'sa'.Error Number: 15535 Severity: 16

Alter failed for Login 'sa'.
Cannot set a credential for pricipal 'sa'.
Error Number: 15535 Severity: 16 State: 1


The above error occurred when we attempted to change the sa user password using sql server management studio.


To resolve this, check the 'Map to credential' as shown in the picture and give a try.


[01004][0] [Microsoft][ODBC SQL Server Driver]String data, right truncation

This will happen when the size of the buffer created by application is less than the length of data retrieved from table.Mean s length of the column in the application specs is less than length of column in the database.
Practically in an enterprise this will happen only when someone plays with these lengths[either application end or database end].

So the approach is to narrow down the problem from View->Table->column.After this check whether the problem is with application specifications or with the database table specifications.

Microsoft SQL Server JDBC Driver version 2.0

Microsoft SQL Server JDBC Driver version 2.0 supports both JDBC 3.0 and JDBC 4.0. To support backward compatibility and possible upgrade scenarios, the JDBC Driver version 2.0 includes two JAR class libraries in the installation package: sqljdbc.jar and sqljdbc4.jar.

The sqljdbc.jar class library provides support for JDBC 3.0 and requires a Java Runtime Environment (JRE) of version 5.0. The sqljdbc4.jar class library provides support for JDBC 4.0 and requires a Java Runtime Environment (JRE) of version 6.0 or later. The sqljdbc4.jar includes all of the features of the sqljdbc.jar as well as the new JDBC 4.0 methods.
SQL Server JDBC FAQ


ORA-00604: error occurred at recursive SQL level 1 ORA-12705: invalid or unknown NLS parameter value specified

We faced this issue while connecting to Oracle database Release 10.1.0.5.0 from a Java program [via JDBC]. No probs with the OCI connection, sqlplus is fine.
The reason being, our Language,Country combination in the Regional and Language options[of control panel] doesn't fall under the Fully supported Locales.Hope this helps