Larry Aultman's Q&A profile

• SQL Server Problems running SQL Agent Jobs & SSIS Packages

  I'm having some difficulties with the SQL Agent and running my SSIS packages. At present, I have several packages that import data from Oracle, a few that use a JODBC connection and several more that transfer data from other SQL servers (2000) I originally had the SQL Agent log in as a System Account, and although the pacages run fine if I manually right click and execute them, if I add them to a Job they fail with a login error. I then changed the login details to my domain account and the Jobs that run accross the SQL servers run fine. However the others that use Oracle and JODBC still fail with login errors. I've tried creating Credenti ...Show All

• .NET Development Loading Access DB in Memory, efficient way ?

  Hi, I want to load three ~150 Mb sized Access 2000 DB's in memory to perform a lot of operations. Loading ONE complete DB in DataTables will result in an out of memory exception. The memory of the DataTables blow up to 1,400 Mb. Is there an memory efficient way to hold tables in memory, the tables have around 8 million entries and work with them fast Has anyone sample code or a hint what mechanism to use Thx.... Use the ODBC (or OleDb) driver with the Jet provider. Let Jet take care of figuring what to load and cache depending on the queries you execute. Don't preload everything into ...Show All

• Visual Studio Team System Can we switch licenses between VS 2005 Team Editions?

  Hello all! Because we are a Microsoft Certified Partner with the ISV compentency that gives us the VS 2005 Team Edition for Software Developers + MSDN Premium subscription Which is great but...that gives us 5 licenses for the VS 2005 Team Edition for Software Developers and an additional 5 licenses (for a total of 10 licenses) because we are ISV but is it only for that particular product or can we use some for the Testers product Since we are not 10 developers here, but more like 4 devs and 4 QA's could it be possible to transfert 5 licenses to let's say...VS 2005 Team Edition for Testers and then download both products&nbs ...Show All

• Visual Studio Team System Beta 3

  OK, so I keep hearing that there may be a Beta 3 released for VSTS. Could someone please confirm or deny this If this is is true, when will it be released the dates here aren't exactly right.  Yes, The client editions of VSTS have RTM'd and are commercially avalibale, but the TFS RTM is not 12/02, but is slated for Q1 CY06.  We will post exact RTM date very early in the new year thanks Michael ...Show All

• .NET Development signing file and store as p7m

  Hi I need to sign a file and save it together with the signature as a p7m file. Found some new classes in .net 2 (SignCMS), but I have no clue how to use .... does anyone have some example. Also tips for .net 1.1 are very welcome! Thank you! For p7m you'll want to use the EnvelopedCms class. Esentially your two steps are Encrypt followed by Encode. The output of Encode will be your p7m data. -Shawn ...Show All

• .NET Development Async sockets, receive callback problem

  Hi, I'm writing an async socket server that transport custom serialized objects. However, I ran into a problem when sending a lot of messages in a loop from the server to the client. To simplify matters I shortened my test code: Here I'm sending some data to the client... for ( int i = 0; i < 100; i++) { state.WorkSocket.BeginSend(b, 0, b.Length, SocketFlags.None, sendCallback, state); }   The client receives the data and processes it:                 StateObject state = (StateObject)ar.AsyncState;         &nb ...Show All

• Visual C# Unmanaged codes for C#?

  Please corrected me if I was wrong, because I discuss this issue with my supervisor. Typically C# writes the managed codes and unsafe codes, but my supervisor insisted that C# could write unmanaged codes, at least in .NET Framework 1.0( ). I know C# could work with unmanaged codes, but I doubt C# could write unmanaged codes. C# need CLR, right Yes, the C# code is always managed... the unmanaged DLL’s that it calls remain unmanaged regardless of what you call them from. The only way to make those DLL’s be managed would be to recompile them with managed support (like the /clr flag). ...Show All

• SQL Server Separate date and time datatypes - come on guys!

  Oh for crying out loud, how come there aren't separate date and time datatypes in SQL 2005!   I know for a fact that this feature has been requested for YEARS!!!!  Thanks for giving me the YAGNI feature of renaming my menu items in SQL Management Studio.  I guess that was somehow a higher priority than a time datatype.   NNTP User wrote: TimeSpan supports full milliseconds.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 -- I'm assuming you mean the TimeStamp type which is referenced as @@D ...Show All

• Windows Forms Missing toolbar icons in print preview dialog

  Hello,  I'm developing a C# application. Initially I had a Windows.Form object with (among other members) a PrintPreviewDialog data member, and this dialog worked just fine: all the toolbar buttons in the print preview dialog displayed the icons correctly. Then I added a Toolbar and an ImageList object to my form, added two .ico files to the ImageList obje ...Show All

• SQL Server Missing Fields in XML DataSet

  I'm using a VS 2005 WebService to return a DataTable that is consumed by a RS 2005 report. The problem is when I execute the query in the Report Designer, there are seven fields being left out. I have tried to manually add these fields to the DataSet using the DataSets tab, but when I run the report, I get an "Index out of bounds" error. Of course, when I view the results from the WebService in IE, I can see the fields just fine. Here are a few cuts from what I'm talking about: The WebService returns several columns, including the following: <xs:element name="Sulfur" type="xs:string" minOccurs="0" /> <xs:element name="Phytas ...Show All

• Software Development for Windows Vista Beta 2 problems with any workflow & designer

  Hello, I have a Windows Vista CTP December 05 machine on which I had installed the WinFX RTC CTP December, the Windows SDK CTP December, the Orcas VS Extensions CTP December and the WWF Extensions CTP December. All of them worked OK. I'm using the RTM Visual Studio 2005 Team Suite and RTM SQL 2005 Developer Edition. Now I uninstalled them in the reverse order and it seemed that the machine was clean. I could not see the the WinFX RTC in Vistas uninstall console, but I used the uninstall tool vs_uninst_winfx.exe instead. Is that not enough to uninstall the WWF runtime components There was no entry in Vistas uninstall cons ...Show All

• .NET Development System.Configuration.Install not found VS2005 Beta 2

  I am trying to work through "How To: Host a Remote Object in a Windows Service" and when I add the following include: using System.Configuration.Include; I get the following error: Error 1 The type or namespace name 'Install' does not exist in the namespace 'System.Configuration' (are you missing an assembly reference ) I can navigate to it in the Object Browser, through the Solution Explorer, but for some reason I cannot use it.  I am new to VS, so I'm sure that I'm just doing something very wrong. Any help will be greatly appreciated!  Shawn, Thanks so much for the help.  This ...Show All

• Visual C# a question

  I'm going to try vc#2005, what's the most improvement between 2003 and 2005 Seems a stupid question,:-) Hi, There has been language changes in 2003-2005, unlike in 2002-2003 the changes only occured in the framework. But for me the most useful change must be the partial classes. It enables you to have a 2-file approach just like the old-C++. Also check out the Class Designer. kudos to microsoft for providing us such a wonderful tool...       cheers, Paul June A. Domag ...Show All

• Visual C# set the cell of datagrid or table to certain text..?

  Is there a way to programatically create a table or datagrid For example, when i click a button, it will display a table which the cell contains the certain text i want, like row1, column 1 ="Price" row1.column 2 ="Profit" row2, column 2 = "xxx" hi, i don't know what version do you use , this code worked on VC# EE with .net framework 2.0, if you have old version you can change the datagridview to datagrid in the code and see what you got hope that helps ...Show All

• Smart Device Development Handling Sliding Keyboard + Some ARM Assembly decoding

  Hi, Apologies in advance if this may be off topic, but i think it is an interesting and challenging issue related to WM device programming ( besides, no one has been able to assist of yet in other news group ). My device has a sliding keyboard...when that keyboard is slid open on the WM2005 Today screen, the keyboards enters a "num lock" state. This is where some overloaded keys that act as the phone dial-pad ONLY output numbers, not characters. i'd like to disable this so that the keyboard functions normally on the today screen when my today item has focus and the keyboard is slid open...this way i can accept chara ...Show All