Daren Coles's Q&A profile

• SQL Server Link to a record in CRM from SSRS report

  Hi All, I have develped a simple report in SSRS, I would like to link to the record in CRM from SSRS. Example: Report looks like Id Name ------------------------------- 001 ABS Co. If I click on ABS Co. it should take me the record details of ABS Co. in CRM. Please help Hi, you’ve to add the AccountId to your reportdataset. Using the field AccountId you can build up the following link for the action property (Jump to URL) of the field: = "http://CRMSERVER/sfa/accts/edit.aspx id={" & Fields!AccountId.Value.ToString() & "}" Best regards ...Show All

• .NET Development Compatibility problem using Microsoft.mshtml with .NET Framework 2.0

  Hello everybody, I have an application that runs with no problem using the .NET Framework 1.1, in this application I'm using the Microsoft.mshtml component to host a browser in my Windows Forms. If you run the same application in a machine only with .NET Framework 2.0 (.NET 1.1 not installed), the following error message appears: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to class type 'mshtml.HTMLInputElementClass'. COM components that enter the CLR and do not support IProvideClassInfo or that do not have any interop assembly registered will be wrapped in the __ComObject type. Instances of this type cannot be cast to any other class; however they can be cast to interfaces as long as the under ...Show All

• SQL Server Sequel 2005 installation Perflib problem

  Hey everyone, I'm trying to install SQL 2005 developers edition on my local PC and I get the following error during the System Configuration Check: - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. I looked it up in MSDN and i'm having problems resolving the problem. How to: Increment the Counter Registry Key for Setup in SQL Server 2005 says I should match the values of "Last Help" and "Last Counter" f ...Show All

• SQL Server Transaction log filling up in "Simple" recovery model, catch 22

  I need to do the quaterly cleanup of our database involving moving historical data to our history db and delete-ing records in a our operational datastore. I've set the recovery model to "simple" as advertised in numerous fora and KB articles. Still the the transaction log goes through the roof evertime I do a delete * from myTable where datetime < '2006-10-01' Where eventually it fails becouse transaction log is full....(Msg 9002) If I do a BACKUP LOG myDatabase TO myBackup sql claims that I cannot perform a transaction log backup (Msg 4208). So I 'm stuck with a large log file in the "simple" recovery model that can not be shrunk... If people would just read the man ...Show All

• .NET Development DeleteCommand causes an error ... Data type mismatch

  I've been attempting to create a button that will delete a record from a table in the database I am currently connected to. Other commands are working such as my InsertCommand and SelectCommand, but I can't seem to figure out how to work the DeleteCommand. Here is my button code: Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click AddressCommand = New OleDbCommand("DELETE FROM addresses WHERE idnum = ", AddressConnection) AddressAdapter.DeleteCommand = AddressCommand AddressAdapter.DeleteCommand.Parameters.Clear() AddressAdapter.DeleteCommand.Parameters.Add("ReferenceName", OleDbType.Numeric).Value = CInt(txtIDNUmt.text);//change the type of t ...Show All

• Visual Studio Team System Assembly reference issue

  I've made an application that uses some TFS assemblies and now I want to distribute this application to some users. During development I just set the 'copy local' to true, but now that it is time to deploy, I don't want to distribute the TFS assemblies too. When I set the copy local to false, my application will not start because some of the dependent assemblies cannot be found. Here's what I did. I needed to use Microsoft.TeamFoundation.WorkItemTracking.Controls.dll which is in the private assemblies folder (but not in the GAC) so I edited my TFS references in the project file to be like the following: < Reference Include = " Microsoft.TeamFoundation.WorkItemTracking.Controls, Version=8.0.0.0, Culture=neutral, PublicK ...Show All

• SQL Server Rookie needs help with what to do after installation.

  Any guidance to get me off the ground would really help After you have installed what If you are talking about Visual Studio and programming... Examples are some of the best way to learn. Check out some of the VB/C# examples for the basic operations or some more robust examples as found in the Starter Kits . Also there are 101 Samples for Visual Studio 2005 which is a robust, initial development tasks to more involved tasks for winforms, web development etc. ...Show All

• Visual C# How to write Urdu on C# Controls

  How can i write Urdu on C# Controls(e.g. Button, TextBox, Treeview, etc.). In urdu there are multiple glyphs for every characters. Different glyphs of a character are used depending upon the position of the character in the word. Its Urgent.... Plz Reply as soon as possible... Hi, please follow the below steps to achieve the same. 1. Change your forms language property to Urdu. 2. And text property to your urdu text. 3. Save project and compile. 4. Now change your regional settings language to Urdu. 5. Run the application. You will see urdu text. thank you, bhanu. ...Show All

• Visual C++ Pointer in C# to C++ unsigned char array

  Hi, I have a C++ class for accessing images from a DirectShow-compatible camera. For this I get a pixelbuffer that is actually a one-dimensional array of characters. I need access to this from C#, and I would like to avoid copying memory, since I need to update the camera image live, and this should be performed very fast. This is my C++ method in my Managed C++ application: --------------------------------------------------------------------------------------- unsigned char *DSCamera::GetFrame() { DWORD waitResult; unsigned char * pixelBuffer; if (mGraphManager == NULL) return (NULL); waitResult = mGraphManager->WaitForNextSample(mFrameTimeoutMS); if (waitResult == WAIT_OBJECT_0) { ...Show All

• SQL Server Mon- Fri Bit fields Query

  I am having trouble figuring out how to complete this any help is appreiciated. I have Mon , Tues , Weds , Thurs , Fri as bit fields I need to write a query for a report to see if the value is true, and display M , T , W , Th , F in a column Days if they are scheduled that day example: Mon and Wed I got on the bus the checkboxes are set to True, I want one column in the report Days : to display M, W Ray: Is something like this sufficient set nocount on declare @monStr varchar (11) set @monStr = 'M,' declare @tueStr varchar (11) set @tueStr = 'T,' declare @wedStr varchar (11) set @wedStr = 'W,' declare @thuStr varchar (11) set @thuStr = 'Th,' declare @friStr varchar ( ...Show All

• Visual Basic How to install an assembly in GAC

  Hi, All dot net experts, The assembly is CrystalDecisions.CrystalReports.Engine version 10.2.3600.0. When I run my OneTouch deployment of my vs2005 win app converted from vs2003, I got this error saying "Unable to install or run the app. The app requires that assembly Crystalxxx be installed in the GAC first." I googled the topic and found this KB article. But it talked about creating a strong name for the dll you created. Does that also apply to third party Dlls Prior to this point, I have been developing and deploying CR reports in vs2003 without running into this kind of hassle. http: / / support. microsoft. com/ default. aspx/ kb/ 315682 Does the prereq staff install in the bootstrapper ...Show All

• SQL Server Upside down text

  Is there a way to print text upside down on a report Hi, Unfortunately this is not possible. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Visual Studio Tools for Office Access Denied starting MS Outlook from Windows Service

  Hi everybody, I am writing windows service where fileSystemWatcher monitors certain folder on our network. If file occurs, i want  service to open new outlook mail window. I logged service with my username... (i have also administrator credentials in domain) but i got the answer Access Denied. Here is the code for FSW_created method:   Dim pass As New SecureString() pass.Clear() pass.AppendChar( "p" ) pass.AppendChar( "s" ) pass.AppendChar( "s" ) pass.AppendChar( "s" ) pass.AppendChar( "w" ) pass.AppendChar( "o" ) pass.AppendChar( "r" ) pass.AppendChar( "d" ) Dim psi = New ProcessStartInfo() psi.FileName = "C:\Program Files\Microsoft Office\Office11\Outlook.exe" ...Show All

• SQL Server Error 87 while installing SQL Server 2005

  Hi everyone! I'm not sure if this is an old issue, but I couldn't find it in any thread. Here I go: I downloaded SQL Server 2005 Enterprise Edition from the MSDN site; but when I run the installation wizard I get this error: Errors occurred during the installation Error 87 installing .NET Framework 2.0 The parameter is incorrect And then I have to cancel the installation. This machine meets the hardware requirements, and it already has the .NET framework 2.0 installed. Humm, what else It's a Windows 2003 Server SP1 machine...let me know if you need more information. I've been trying to figure out a solution, but I finally gave up I'm trying to install Team Foundation Server, but first I have to install IIS 6.0 (don ...Show All

• .NET Development Interop Debugging with ICorDebug

  I'm working on a debugger using the ICorDebug interfaces. I'vem only just started and I'm trying to get a proof of concept for my boss. I'm able to launch or attach to managed apps and I'm getting all the proper DebugManagedCallback calls for attach, create process, load module, etc. Things get wierd when I add the unmanaged callback and set the flags for interop debugging. My unmanaged callback gets called and I call ICorDebug::Continue with the value of the out of band flag that's passed into the function. Everything works until I get the initial int 3 call. In that case the out of band flag is FALSE but whether I call Continue with TRUE or FALSE, the app is never fully launched and I don't get any of the managed callbacks. I've tried ev ...Show All