Todd Jaspers's Q&A profile

• SQL Server insert error

  I have a database using a sql backend and an access front end, which was upsized. I am trying to add employees to the employee table and I am getting the following error: Violation of Primary Key Contraint 'aaaatblEmployees_PK. Cannot insert duplicate key in object. I am going right to the access front end to add these employees to the table. The primary field is autonumbered in access and when it upsized to sql the identity increment was set to 1 automatically. Could this be conflicting with the field in access I made a local table of the employee table and I was able to insert records fine. What can be wrong. Thanks ...Show All

• Visual Studio Item Template: IWizard "ContainingProject"

  Hello! I am currently implementing an Custom Item Template, which uses some code within class that implements IWizard. BTW: It is really amazing how easy it is now to add own Templates (compared to the old .vsdir, .vsz Files and the COM Interfaces). But I have one Problem: How can I get a reference to the Project in which the new item will be added from the IWizard.RunStarted Method For my template to work it is nesserary to get some properties from the containing project. A workaround would be to wait for the "BeforeOpeningFile" event and replace some placeholders "by-hand", but this would be a very "evil" workaround. Any ideas Hi Ed! Thank you for your answer. The thing with the automati ...Show All

• .NET Development This Error Appears: Format of the initialization string does not conform to specification starting at index 0.

  I have saved the database connection string to a key named 'ConnectionString' allowing to access it by calling 'configurationSettings.AppSettings("ConnectionString") But a red line comes under the configuration in the part of the : 'configurationSettings.AppSettings("ConnectionString")'. When i run it this error appears: Format of the initialization string does not conform to specification starting at index 0. and says: Line 4: Public Shared Function GetCategory() As SqlDataReader Line 5: Dim connection As New SqlConnection(connectionString) Line 6: Dim command As New SqlCommand("GetCategory", connection) Line 7: command.CommandType = CommandType.StoredProcedure Line 8: connection.O ...Show All

• Software Development for Windows Vista DLL priority

  I'm trying to write a DLL which requires a high priority, is there any way to do that (other than putting code in each DLL entry function to increase the thread's priority). Just to give a little bit more background, I'm writing a USB driver using Jungo, where you have their driver in kernel mode and most of your driver functionality in user space. The problem is that whenever a process reaches a 100% cpu usage, the part of the driver in user space starts behaving very slowly (specially when switching back/to user space after Jungo driver calls), and I'd like to fix that (I've noticed that changing the priority works well, but might not be the best solution, so other suggestions are welcomed). TIA ...Show All

• SQL Server SQL Server does not allow remote connections

  I downloaded VS studio express, and created a personal website using the wizard to test drive the thing. When I hit ctr + f5 to run the sample provided, then I get this message: " An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) " I tried disabling the firewall (Norton's firewall because Windows is disable always). Any suggestions This is a brand-new machine, running XP sp2, just downloaded the VS studio express. I really appreciate your inputs. Regards, Car ...Show All

• Windows Forms Cannot add record in VB 2005 Express Edition

  I am just getting started with VB 2005 and built a data application following the example in the video "Absolute Beginners video" and have never been able to add or change a record using the update method. I even downloaded the project and still could not add or modify a record. Is there a reference I need to set or possibly an update I need I have Windows xp home SP2 Look in the solution explorer at the databases properties. Make sure its Copy to output property is set to only if newer. Sometimes you are updating the database but when you start the program the old version of the database is copied over the newer one. http://www.onteorasoftware.com/blog.aspx BlogID=61 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Games OUT OF THE BOX??

  I cant make them work on a PC with just .NET 2.0 DirectX and the XNA Framework, it still needs the GSE and VC# Express, otherwise I get an error that the framework dll should have been installed into the Global Assembly Cache. Just all of that and nothing. The Directx runtime installer says I already have a newer or equal version and wont install any files. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. xbox controller coding

  how do implement the xbox controller within xna frame work got any tutorial references there thanks Look at the GamePad class. GamePadState gps = GamePad.GetState(PlayerIndex.One); connected_ = gps.IsConnected; if (connected_) { Matrix m = Matrix.CreateFromQuaternion(scene.Camera.Ori); // for forward/right scene.Camera.Pos = scene.Camera.Pos + (m.Forward * gps.ThumbSticks.Left.Y + m.Right * gps.ThumbSticks.Left.X) * (float)gameTime.ElapsedRealTime.TotalSeconds * SPEED; } ...Show All

• Visual Basic Streamwriter in VB 2005

  This SHOULD be easy. I must be missing something. I'm assembling a long string and trying to write it out to a file. If I display it in a message box or textbox, it looks fine. But when I write it out to a file, it gets chopped off. I thought it might be my data, because it is supposed to be HTML, but it seems to be related to the amount of data, because it chops off at about the same number of lines no matter what the data. I tried breaking it into smaller strings and doing two writelines, but it still does the same thing. lname = names(1) outFile = "D:\Class of 57\updatehtm\" & lname & ".htm" output = New FileStream(outFile, FileMode.OpenOrCreate, FileAccess.Write) fileWriter = New StreamWriter(outp ...Show All

• SQL Server Flat File Source Problem...

  I have a weird thing happening. I have an .csv file. When I try to load it into a table, I can do it easily in DTS 2000. But when I am trying to do it in SSIS 2005 with exactly the same settings (like Text qualifier, row delimiter etc.), I am getting an error: "The last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly." I looked at the file and it looks complete to me. What could be the problem P.S. DTS 2000 is on 32-bit Windows, and SSIS 2005 is on 64-bit Windows 2003 . Could that we a problem Victor_V wrote: I have a weird thing happening. I have an .csv file. When I try to load it into a table, I can do it easily ...Show All

• SQL Server Delete any records in table 1 that are not in table 2 (tables joined on 2 columns)

  I have two tables. The primary key for both tables is comprised of 2 columns. How do I delete any records in table 1 that are not in table 2. e.g. if this was the data in the 2 tables Table 1 col1 col2 col 3 0 0 0 0 1 0 Table 2 col1 col2 col3 0 0 0 I would like to delete the records containg the values 0, 1, 0 from table 1 because the is no record in table 2 with the values 0, 1 as the primary key. Hi, You can do this as follow (by suggesting that COL1 and COL2 are the key columns): DELETE FROM table1 FROM table1 LEFT OUTER JOIN table2 ON table1 . COL1 = table2 . col1 AND table1 . COL2 = table2 . col2 WHERE table2 . COL1 IS NULL Gr ...Show All

• Visual Studio Microsoft Visual Studio 2005 Languages

  As I began installing Microsoft Visual Studio 2005, everything was written in French. I pressed through the installation successfully, but when I run the program everything is written in French as well. How can I switch it to english, or where can I find an english language pack for it this is interesting. Can you confirm that your OS is English Well really this shouldnt have mattered I would thought. Something is fishy but not sure exactly where. On a last resort, I would start to repair VS.NET and see how that goes. But you want to try and avoid it if you can until absolutely neccessary as a last resort. ...Show All

• SQL Server Bulk insert Remote Files access denied

  Here is my setup. Machine A: SQL Server 2005 x64 on a Windows Server 2003 x64 Machine B: XP Pro SP2 with SSMS installed Machine C: hold files that I want to import to Machine A. The drive is shared and set for everyone to read. Everyone is logged in as Admin and SQL services are start up under the admin account. I'm using Windows Authentication to log into Machine A from machine B. When I try to bulk insert from query analyzer running on Machine B BULK INSERT ModelData FROM '\\MachineC\Data\Files\Something.txt' WITH ( FIELDTERMINATOR = ',' , ROWTERMINATOR = '\n' ) I get Operating system error code 5(access is denied). I have looked at the examples shown from the BOL links provided but I just have a small workg ...Show All

• Software Development for Windows Vista Design questions for payment system (timer)

  Hi, I'm new to workflow and currently is trying to evaluate our payment system by utilizing this new technology. I have the following question and would appreciate any links, comments, or hints. Our application is a asp.net web application, where user can submite their donations. There are many possible scenarios. One of them is: user do their first payment right away and then schedule future payments, for example, charge their credit card every first day of the month. The steps are as follows: There is a asp.net website where donations are made. After the donation is submitted, the workflow starts. Inside the workflow, we create invoice, charge credit card/check/direct deposit, send thank you email, and etc. On the ...Show All

• Windows Forms Keyboard cues problem

  Hello , Background: I've got a WinForms app written in C# using .Net 2.0. In this app I have a custom button class: public class ThinButton : Button The reason for having the class is to override the default painting. Specifically I want to draw a thin border and have a narrower margin between the button edge and the button text. This allows me to have a smaller button (to fit into tight places) that still looks good. The Problem: I have noticed that when I press the alt key on the keyboard (when running the app) the accelerator key mnemonics are shown underlined, as they should, for all controls, including my ThinButtons. When I press the alt key again, the mnemonics dissappear, as they should, for some control ...Show All