Tim Dallmann's Q&A profile
SQL Server Visual Basic Matrix Column Width
Is there a way to set a matrixs column width using VB ...Show All
SQL Server Problem executing a Oracle Procedure using Execute Sql Task
Hi All, I am trying to execute a Oracle Procedure through Execute Sql Task but it keeps throwing back an error ORA:00900. Is it possible to execute the procedure from this object Do I need to use the script task to execute this. If yes then how Any help would be appreciated. Thanks in advance. Amol hi, I did some stuff related that from a Sql Task but from Sql Server 2000 (dts), an Oracle function: DECLARE RetVal NUMBER; begin ACTUALIZAMARCAEMPLEADO; end; ...Show All
Visual Studio Express Editions Save project as
Is there any way to save a whole project as a new name (new project) - not just Form1 I miss a file menu point like "Save project as". A VB project consist of an awful lot of files in nested libraries so if you want to test a modification it would be very nice to be able to save the entire project under a new name. Ask and you shall receive.... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1135620&SiteID=1&mode=1 ...Show All
Visual Studio 2008 (Pre-release) DragSource_PreviewMouseLeftButtonDown seems to stop my GridViewColumnHeader.Click from firing on listview
I added Pavan's drag and drop classes to drag from a listview to a canvas. I had to modify the generic event a bit to make it work for listviews. Now I am trying to add column sorting to my listview using the example that came with the SDK. My listview sorting only works when I take the drag/drop functionality out. It seems like that functionality is blocking the click event from happening. Any ideas static void DragSource_PreviewMouseLeftButtonDown( object sender, MouseButtonEventArgs e) { // Make this the new drag source IDragSourceAdvisor advisor = GetDragSourceAdvisor(sender as DependencyObject ); if (advisor.IsDraggable(e.Source as UIElement ) == false ) return ; ListView lv = (( ListView )(e.S ...Show All
SQL Server Restoring SQL2000 Transaction Logs to SQL2005
Hey all, Just went through migrating to SQL 2005 as well and we have a need to apply log shipping between SQL 2000 and SQL 2005. Well not shipping per say in the automated fashion that SQL 2005 offers but rather we need to apply SQL 2000 transaction logs to a SQL 2005 instance. Though the database is still in SQL 2000 version 80 and the secondary database needs to be available in read only. (STANDBY MODE) When I attempt to restore either a FULL backup or transaction log I get the error: RESTORE DATABASE is terminating abnormally. This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY The only way I could restore the FULL was by using the WITH RECOV ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Displaying Fonts in XNA?!
Hi everyone, Just got started on this but already running into a heap of trouble... How do I display fonts I already got the bitmapfont.cs from Gary Kacmarcik on http://blogs.msdn.com/garykac/archive/2006/08/30/728521.aspx but the class won't build due to all sorts of weird errors. Am I doing something wrong or is it simply because the class was written voor Beta 1 or 2 How do you display fonts using XNA And why is it not easily accessible in the first place Seems like an enormous oversight to me. Thanks in advance. If you have found Gary's blog already, why do you still use the incompatible Beta1 version Check this one: http://blogs.msdn.com/garykac/archive/2006/11.aspx The final (up to now) are BitmapF ...Show All
SQL Server YTD
I need to create a YTD calculated measure that stops computing down the time hierarchy once it gets to todays date. I'm using business scorecard manager and it is looking for the last populated cell to determine what "current" is. The measure definition below calculates the YTD that I need but has no way of knowing when to stop even though the [Measures].[Visit Item Count] is null for every day after today, it just carries the last value forward. I need it to return nulls for everyday past today. SUM ( YTD ([Visit Date].[Calendar Year - Quarter - Month - Date]. CurrentMember ),[Measures].[Visit Item Count]) After much fiddling, see below, I'm one step closer. I have it working with a ha ...Show All
Visual C++ VS2005 SP1 released
VS2005 SP1 is released. http://msdn.microsoft.com/vstudio/support/vs2005sp1/default.aspx If you have any trouble installing, be aware of http://support.microsoft.com/kb/925336 (that exact problem happened to me when I tried to install VS2005 SP1) hi,Ted, when i installed sp1 later, i rebuild my project ,and the following error appear: -------------------------------------------------------- runtime error! program:..\common7\IDE\devenv.exe this apllication has requested the runtime to terminate it in an unusual way.please contact the application's support team for more informion. --------------------------------------------------------- my OS is english xp+sp2,what shou ...Show All
Windows Forms Append 2 byte[] arrays
How do I append 2 byte[] arrays Obviously this doesn't work: <code> byte[] 1; byte[] 2; byte[] 3; 3 = 1 + 2; </code> So how would I go about doing it I tried to convert them to strings, append the strings, and then convert back to bytes, but that doesn't work. Thanks! This works: byte[] arr1 = { 1, 2, 3 }; byte[] arr2 = { 4, 5, 6, 7 }; byte[] arr3 = new byte[arr1.Length + arr2.Length]; Array.Copy(arr1, arr3, arr1.Length); Array.Copy(arr2, 0, arr3, arr1.Length, arr2.Length); ...Show All
SQL Server What do I need to use SSIS API on a target machine?!
Hi, I've created an SSIS package to be loaded using my ASP .NET app. This package is kept within the application and loaded via Microsoft.SqlServer.Dts.Runtime.LoadPackage method. My target machine does not have MS SQL Server 2005 installed. So what do I need at minimum to get this up and running What components do I've to install or copy over I tried to copy just the class libraries across. I copied Microsoft.SQLServer.ManagedDTS.dll and Microsoft.SQLServer.DTSRuntimeWrap.dll into my bin directory but I got this error: [COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.] Microsoft.SqlServer.Dts.Runtime.Applic ...Show All
Visual Basic Performance- Code Snippet
Hello, Any suggestions for improvement in this code snippet, performance wise [expecially since we have Generics in .net 2.0] Dim arr() As String = Split(PageRange, "-") Dim StartPage As Integer = CInt(arr(0)) Dim EndPage As Integer = CInt(arr(1)) Thanks for the responses. Split function by default returns a 1-dimensional string array. This forces me to declare my array variable as "string" although i know that my array only has integers. I think there is a performance penalty in doing the boxing from "string" to "int" on each array element.May be I can have a "(Type T() of Integer) and use a function that splits a string into a 1-dimensioanl array of integers s ...Show All
Visual Studio 2008 (Pre-release) Rolebased Security & controls
Hello, For my WPF application, I need to use rolebased security to: a) Disable buttons b) Make controls readonly or read/write I'm planning to use an access matrix for each role. Each control has a boolean that indicates if it is enabled or if it is readonly. It just seems like a lot of work, and lot of binding code (in xaml-binding and cs-properties). aya-yaya... Is there a way out of this Is there a better approach Thanks Houman Josh, that is a great idea! I really like that. Unfortunately my problem is a little bit crazier than the regular rolebased security :( The admin can configure which controls are enabled or disabled for each role. Thanks Houman ...Show All
.NET Development Trying to send a mail via SMTP in VB 2005 - Authorization problem
I am having a the same problem. I created a VB 2005 app that would try to deliver mail with both System.Web.Mail and System.Net.Mail. Both methods will work if I don't authenticate. If I use the fields property to authenticate through System.Web.Mail, I can authenticate and send to users of the outside world. If I use the Credentials property of the SmtpClient class, I can't authenticate. Here is some code. System.Web.Mail - Authentication works If the authentication code is commented out, the code can still send to anyone that has an email address on my domain but can't send outside of the domain. If I include the authentication code, it can send to either internal or external. ----------------- ...Show All
Internet Explorer Development IE7 Certificate Request/Enrollment
With IE7, I've noticed the original ActiveX method of generating a client certificate request and installing the signed certificate no longer work (xenroll.dll calling CreatePKCS10() and acceptPKCS7()). How do you do this now with IE7. Vista customers with IE7 don't even have access to xenroll.dll. I have been unable to find much documentation on this change, only that the old way was replaced with "something new", but no details on what the something new is called. Any help would be greatly appreciated! Thanks, Andy I tried with the following code in installing certificate test, and it turns out to be an object. < html > <SCRIPT language= "vbscript" &g ...Show All
Visual Studio Express Editions How Can I use Label Edit for List View Subitems?
I would like to use the LabelEdit on subitems as well, but I am unsure howe to do this. I did a search and found one topic but there were no responces. I'm sure there is a way, but I'm just a simple self tought hobbiest programmer. I'm hoping that this would be an easier approach than to Load a new Form and then replace the Listview1.FoucsedItem, which how I have been doing it. Can any one help me or point me to a site Thanks. accessing the index of the subitem (first line of code) is the way to get to the individual subitems of an item... as far as your needs to edit the label like WMP or Itunes...you would have to show some code to better explain what your trying to do ...Show All