Welcome to MSDN Blogs Sign in | Join | Help

July 2009 - Posts

SQL CLR stored procedure called via JDBC using setAutoCommit(false) does not update database.

I have come across this question a few times; “I have a java client that connects to SQL Server via the JDBC driver. I then call a CLR stored procedure that interacts with the database. When I run with setAutoCommit false the data is not committed. However,
Posted by maspeng | 0 Comments
Filed under: ,

System.Data.SqlClient.SqlException: Cannot open database "database name" requested by the login. The login failed.

A short one today, this is about one of the slightly confusing error messages when it comes to connecting to SQL Server, namely: System.Data.SqlClient.SqlException: Cannot open database "database name" requested by the login. The login failed. Login failed
Posted by maspeng | 0 Comments
Filed under: ,

Improving XslCompiledTransform performance.

Imagine this scenario, you have some xml files that you wish to transform to html files, this is done by using xsl files. This you think is a bit slow (even though what “slow” is, is different from person to person J ). So, how do we do this? Again, I’ll
Posted by maspeng | 0 Comments
Filed under:

Attachment(s): PrecompileXsl.zip
 
Page view tracker