jaegd's Q&A profile

• Architecture SQL 2005 and Visio for Enterprise Architects Database

  I reverse engeneered a SQL2005 database into Visio for EA where I had utilized the new schema feature (like what was done in the sample Adventure Works database). After the db schema was generated I was happy to see the the schema name appeared in the owner attribute of the table definition. However, I was unable to change the owner to a different schema name. Additionally, if I create a new database design, it appears I cannot associate an owner (schema) to the table. Am I missing something If I name the table with a dot notation to include the schema name, it prepends the dbo owner as well. Any recommendations I like the notion of using schemas for security purposes. Thanks, Tom I'm working on a client's Data Model in Vi ...Show All

• Smart Device Development Installing activex control on to mobile device

  Hi, I'm trying to install and register a ActiveX control written in C# for CF 2.0. I created a smart device cab project and added the primary output of the ActiveX control project to the setup. I then copy the files (.cab, .inf) to the device and ran them but I still recieve Automation errors when trying to create this object in PIE using JScript. Any help would be appreciated. Thanks. That's not what article says: From TFA: The following interoperability with native code is not supported by the .NET Compact Framework: Using an assembly registration tool, such as Regasm.exe, for COM clients to use a managed component as a COM class. Activating managed types from COM. Hosting the runtime fr ...Show All

• SQL Server How to move Transactional Distributor to new platform?

  I have to move our dedicated Sql 2000 transactional distributor to a new and faster machine. Great! Can someone give me or point me to a cookbook of the best way to do this This has to be done quickly so I would like to script it and have it ready ahead of time. I am not a replication guru so I am a bit nervous . . . I have looked at the scripts output by EM, but I am sure there are some assumptions . . Thanks ...Show All

• Visual Basic Conversion of Double to Single

  I've been fighting with this problem for the past couple days and finally narrowed the problem down to the following couple problems: (This is all in VS 2003 .NET 1.1) #1 I have a Generic procedure that has a ByVal parameter of a Single datatype. In one of my modules, I happen to be calling the procedure passing in a Double datatype variable that has a value of 152347.04. When I step into the procedure, the Single datatype parameter then has a value of 152347.047. I've tried type casting the Double to the Single datatype but still get the same results. I can't figure out why it's not converting over the Double to a Single type by adding some erroneous value to it. #2 Also in the same procedure, I was passing in an ArrayList object that was ...Show All

• SQL Server Checkpoints: FTP task download FTP files fails in between then what will happen?

  Hi, I have a FTP task in my control flow that download files from a FTP server. This ftp task is inside a foreach container that loops over a ADO recordset for the file name. The files that the ftp task pulls are huge. If the FTP task fails then I want the FTP task to restart and only download those files that have not been downloaded. Is this possible What possible configurations do I have to make to the foreach container and the filetask Thanks a lot in advance for your help and time. Regards, $wapnil ...Show All

• .NET Development passing string to my stored procedure

  i have the following function in my vb.net application and im passing 2 variables as strings Function SLP_RPT_GetDistricts1( ByVal p_tsDate_ch As Date , ByVal P_bc_ch As String ) As IDataReader where tsDate_ch = 1/1/2007 & P-bc_ch= 21 and my stored procedure is CREATE PROCEDURE SLP_RPT_GetDistricts1 @p_Date  CHAR(25), @p_BC_ch  CHAR(2) AS BEGIN SELECT DISTINCT District_ch from SL_RPT_Geography where (start_sd >= @p_date) and (bc_ch = @p_bc_ch) and (isnull(end_sd,getdate() )< getdate()+1) order by district_ch END GO but it's not working and i keep getting that tsDate is not a parameter of the procedure.... but when i insert the actual values in my procedure it works and ...Show All

• .NET Development Why the change to Managed code and why not provide an Unmanaged (Native) option for VB.Net?

  While I know any program can be broken with enough effort. It seems to me that Microsoft's change to the .Net format has just made life much easier for code breakers while making it harder for Individuals writing code to sell small programs to protect their code. I used Obfucation of code with code I have written since the early versions of basic. But now it takes nothing to decompile the code and then work on figuring it out. While programs compiled in Native code it took much more to decompile and break the code where small specialized programs usually were not worth the effort to break. Why doesn't Microsoft continue to provide native code compilation for VB.Net programs to allow small business / Self Programers the same level of code ...Show All

• Windows Forms AddHandler - pass info

  I loop through a number of small images and need a click event on each of them So, I use an AddHandler. For k = 1 To iNumOfImages Dim box As PictureBox = CType ( Me .Controls( "pbImg" & k), PictureBox) AddHandler box.Click, AddressOf DoImageClick Next Private Sub DoImageClick( ByVal sender As System.Object, ByVal e As System.EventArgs) 'What Image Was Clicked End Sub In the DoImageClick, I need to find the name of the item clicked. Or pass a var there. I've looked in the System.Object and the EventArgs extensivelly but found nothing I can use. Suggestions Thanks, Zath The sender parameter will the the contol that ...Show All

• Internet Explorer Development New Snip IT Context Menu Extension from MS - Undocumented Installer Feature

  Hi all, Just downloaded and installed the new Snip IT context menu extension from http://go.microsoft.com/ linkid=6168206 Unfortunately there appears to be an unwelcome feature in the installer. User preferences for the install directory are not reflected in the registry entries for the script source location folder. Test Plan. Download and run SnipIT.msi from the above download page. When prompted to choose the installation folder, choose a location on your computer other than the default (C:\SnipIT\SnipIT\). I choose d:\snipit Continue and complete the intallation. Open regedit and inspect the values for each of the IE Context menu created under the key HKCU\Software\Microsoft\Internet Explorer\MenuExt\ H ...Show All

• Visual Studio Get latest version not reliable

  hi. i have a vss 2005 setup (integrated into vs 2005) with 4 machines on two sites. the sites are connected via vpn. we're using the normal connector (not the http one). we're working on a solution with ~50 projects. we quite often find that doing a "get latest version", does not, in fact, get the latest version of the solution. sometimes only a single file is omitted, sometimes complete projects are not updated. this obviously leads to failed builds, which is when we notice that GLV didn't work. doing another GLV at this point most of the time does resolve the problem, however, vss inconsistency in getting the latest version of a source file (or complete project) is not exactly helpful. any ideas what would be causin ...Show All

• Visual Studio Express Editions vb command line problem

  Hi, I'm starting out in C++ and using the command line prompt to compile my programs using the cl /clr [programname].cpp command. Unfortunately, whenever I have alot of errors in my code, the error list this command generates overruns and I can't scroll backwards through them far enough to get to the earliest code errors (they seem to be "cut off"). Does anyone know a way around this Thanks so much, Chris That is not related at all to VC++. Just open the properties of your command prompt and look at the options tab. You should find an option of expanding the buffer size. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Express Editions serial port - sending 8 bit problem

  Hi, I have a problem with sending 8 bits through the serial port. I tried to sent chr(129) and I received in the other computer chr(63). when I sent chr(0) till chr(127) it work fine. from chr(128) till chr(255) some of them are fine and some of them I'm getting chr(63) I saw that if I sent 6 or 7 bits it's getting fine and the problem occur in the 8 bit sending. this is how I open the serial port:: --------------------------------------------- sp.PortName = "COM1" sp.ReadTimeout = 500 sp.DtrEnable = True sp.RtsEnable = True sp.BaudRate = 19200 sp.DataBits = 8 sp.StopBits = StopBits.One sp.Parity = Parity.None sp.Open() -------------------------------------------------------- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Suggestion for stock Vertex structs

  I notice that the framework provides a few stock vertex structures like VertexPositionColor etc. This is cool but it would be great if these could inherit from an interface which provides a mechanism to get the SizeInBytes and Element information abstractly. These structs currently provide this information as static properties but this is no good if you are are trying to write a generic function that can deal with a number of different types of vertex structures seamlessly. My suggestion is that in future something like an IVertexInfo is provided that lets you deal with these concrete vertex structures abstractly.  Perhaps something like this. interface IVertexInfo {     VertexElement [] Elemen ...Show All

• Visual Studio Team System Create New Team Projects from Clients fails

  Hi, We have a problem.... We have installed TFS on our Server which is a TFS only server. We have followed each step from the the manual. We have setup some users to be administrators on the TFS. We have also added them as Content Managers in the reporting services. The admin right is also set on Sharepoint. Now to the funny part when we are logged on the TFS server we can create team projects. If we login on a workstation with the Team Explorer installed it crashes. We have figured out the this happens when the wizard tries to setup the Reporing services. If anyone can give us some tips on how to solve this it would be very appriciated. BR Magnus Muller We have tested on a virtual network without F-Secure(anti-virus) then ev ...Show All

• Visual Basic Update DB/Please review my code

  I have an XML file that I have put into a datagrid. (The grid is loading the XML perfectly!) I am now looping through my datagrid to update my SQL 2005 DB. Can someone please tell me what I am doing wrong here (One thing that may look odd is that I am querying the Inventory record first to count the current inventory then adding the column total to that count. That is because the XML file shows inventory at 3 different locations and I only need to know the TOTAL) Thanks in advance! visual basic code: Private Sub btnGetData_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles btnGetData.Click dsAvailableBatch. Clear () dgBatch.Refresh() txtStatus.Text = DateTime. Now & " - Getting batch please wait..." ...Show All