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)
DSPMSGD RANGE(SQL0551) MSGF(QSQLMSG)
Labels:
Iseries
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.
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.
Labels:
Database,
Sql Server
[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.
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
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
Labels:
Database,
JDBC,
Sql Server
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
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
Labels:
Java,
Troubleshooting
Subscribe to:
Posts (Atom)



