SQLCLR Blessed assemblies

As per http://support.microsoft.com/kb/922672 there is a specific set of assemblies supported inside the SQLCLR  i.e. •Microsoft.VisualBasic.dll •Mscorlib.dll •System.Data.dll •System.dll •System.Xml.dll •Microsoft.VisualC.dll •CustomMarshalers.dll •System.Security.dll •System.Web.Services.dll •System.Data.SqlXml.dll •System.Transactions.dll •System.Data.OracleClient.dll •System.Configuration.dll If a user assembly references any .NET frameworks assembly that is outside of the ‘blessed’ list and you try to register the assembly with SQL Server, error…

2

Typed DataSet : TableAdapter CommandTimeout

If you want to set CommandTimeout  for Typed dataset’s TableAdapter there is no public property exposed.You could still  either extend the partial TableAdapter class or modify the existing designer generated code to modify CommandTimeout behaviour. For e.g. : I added DataSet1 to my windows application which has a TableAdapter called GetProductionLocationTableAdapter. GetProductionLocationTableAdapter calls a stored…

1

ODBC Trace not collecting logs ?

If you are trying to run ODBC trace and do not see data being collected or log file being generated. Try following steps. 1. From your registry key HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.ini\ODBC make sure that the value for entry Trace is 1. 2. Re-Start your computer. 3. After your computer re-starts, Launch the application against which you want…

1

ADO.NET 2.0 performance counters

ADO.NET 2.0 introduces a new set of performance counters that are specific to each provider. In the Visual Studio 2005 release, the supported providers are the SQL Client and Microsoft’s Oracle Client managed providers. Those legacy .NET CLR data counters were deprecated in Visual Studio 2005, and they will no longer be populated. The counters…

0