tstrob's Q&A profile

• SQL Server Bulk Insert error file does not exist

  Hello I am trying to bulk insert a text file into SQL 2005 table. When I execute the bulk insert I get the error "Msg 4860, Level 16, State 1, Line 1. Cannot bulk load. The file "\\ENDUSER-SQL\EnduserText\B1020063.txt" does not exist." The text file that it is saying does not exist I recently created thru my code. I can open the file but only when I rename the file will the Bulk Insert work. After creating the text file I am moving it to the server that SQL server is running on. Also if I run sp_FileExists it also says the file does not exist unless again I rename the file then this stored procedure recognizes the file. I dont' know if I have a permission issue or what is the problem. Any help would be apprei ...Show All

• .NET Development Problem installing Microsoft .NET Framework 1.1

  Hi i need to install Microsoft .NET Framework 1.1 on my PC for a game i want to play(Lord of the Rings Online), i downloaded the dotnetfx.exe setup file(file version: 1.1.4322.573) and ran it then during the copying new file prosess i got the following error: "Error 1304 error writing to file: C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\shfusres.dll Verify that you have access to that directory." So yea im kinda stuck as to what to do, any help with this would be really great. Much thanks. It sounds like there is some kind of permission problem on this system. Can you please try the steps listed at http://blogs.msdn.com/astebner/archive/2006/09/04/solving-setup-errors-by-using-the-subinacl-tool-to-repair ...Show All

• SQL Server Error reading certain numeric values with VFPOLEDB driver

  It appears that the VFPOLEDB driver tries to convert numeric types in VFP to decimal types in .NET. In this case, it's a Numeric 9,3 in VFP and it's trying to put it into a decimal 8,3 in .NET. I know that VFP has this funny quirk where if you don't use all of the decimal places after the decimal point, it allows you to use extras in front of the decimal point. In our case, the number is 104895.83 and yes, VFP is happy storing this in a Numeric 9,3 column. When trying to read this in .NET, you get this message: System.InvalidOperationException The provider could not determine the decimal value. blah, blah, blah... The question then is - is there a work-around I can find no way to force .NET to use greater precision. About a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. My first game... Asteroid Defense.

  In this game you are a ship protecting a planet from incoming asteroids. Controls: 360 controller: Left Joystick -- Move ship left and right. A -- Shoot Right or Left Trigger -- Change Weapon. Keyboard Left and Right Arrow Keys -- Move ship left and right. Up and Down Arrow Keys -- Change Weapon Space -- Shoot The weapon you are using is shown in the top left corner. The stronger the weapon you use, the less points you get for destroying an asteroid. Levels progress at timed intervals and more and more asteroids come down. You lose when one of them reaches the planet. Screenshot: http://www.rocketsoft.gm-school.uni.cc/uploads/ADScreen.JPG Game File: http://www.rocketsoft.gm-school.uni.cc/uploads/AsteroidDefense1.1.rar All in ...Show All

• Visual Basic Reusing Forms

  Greetings I am converting a VB6 program containing multiple forms into a 2005.net VB program. In the old VB6 program I use a modal form and then I want to re-use the same form but but change some of the labels and make visible a control that was invisible the first time around. In the VB 6 version I was in, say, Form1 and executed the following code: Unload Form1 Form1.Show 1 This re-did the Load event and I used a counter to customize the form in its second life. Is there any way to do this simply in VS2005 VB Have a look at the following very simple example of what I think you are trying to achieve. This uses the constructor for the second form (Sub New) to display the date passed to i ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpriteBatch.Draw(..., float layerDepth) No Longer Works For Me

  I guess that the deprecated BeginScene() used to automatically changed some device states in order to make it possible for layerDepth to work. But since that function is gone in Beta 2, I no longer know how to automatically depth order my textures. Is there a set of device states I need to be in to get this automatic sorting If not, I'll just write my own sorting code. Thanks! Terry A. King wrote: I have a question which sounds quite similar, or may offer a solution, to this. My question is how do I depth sort more than one SpriteBatch My initial test shows using : batch.Begin( SpriteBlendMode .AlphaBlend, SpriteSortMode .BackToFront, SaveStateMode .None); will correctly draw the sprites in the correct ...Show All

• Visual FoxPro Error massege: API library is not found when run program?

  Hi all! I use VFP9! My program was compiled to EXE file, but when run from EXE is error massege: "API library is not found when run program". But if start VFP9 before run program is normal not error! Thanks! Do you know which library you are using and is not found You may have to debug the EXE (can't use debugger step-by-step) by writing to a log or using Wait Window or MessageBox in strategic places, or debugout. Once you find the offending API call you may have a handle on the problem. Is this happening in the same PC Which OS Are there any permission problems Are there any path problems Is the user running the EXE the same user running the development APP in VFP (th ...Show All

• Visual Basic accessing dataset fields

  Hi, I can not get this for the life of me. I want to get a list (array) of all the values in a certain column in a dataset, how can I go about doing this Also, what is the format for getting the value in a certain field from a dataset Like "Row x, Column y" where x and y are specified by a unique row value and unique column name. If you know of a good tutorial for Visual Basic & using SQL (Binding sources, datasets, etc), please let me know as I think I'm having a more difficult time grasping it than other aspects. Thanks! Right, my mistake; I guess I meant the above where instead of dataset, i meant a table in my dataset. So to get a list of all the values in a column ...Show All

• SQL Server Send Mail Task limitation

  Hi everyone, I wonder about this task.. which is the limit size for attachments Is it depending of SMTP server Thanks in advance, ...Show All

• SQL Server Scheduled Subscriptions, ScheduleRecurrence and the ICalender Recurrence Rule

  I am working on getting a subscription management interface put together for my product's implimentation of Notification Services. I have a question about the capabilities of the Scheduled Subscriptions, specificaly about the flexibility of the ScheduleRecurrence property. below is a copy of recurrence options from books online... ICalendar Recurrence Options FREQ=DAILY; FREQ=WEEKLY;BYDAY= DaysOfWeekList ;[BYMONTH= MonthsOfYearList ;] FREQ=MONTHLY;BYMONTHDAY= DaysOfMonthList ;[BYMONTH= MonthsOfYearList ;] FREQ=YEARLY;BYMONTHDAY= DayOfMonth ;BYMONTH= MonthOfYear ; It would apear that Daily is the smallest unit of recurrence supported, but we would like to have a recurrence option in a period o ...Show All

• Windows Forms Win Form changes/Save question

  Ok I have a winform that has a left panel naviagation.I use a three tier approach to my Business logic andd data access to a web service that talks to SQL server.I need a way or how to do this in C# to save the current form which ever one is open(IE Users,Companies,Items,etc) to be saved every time a user clicks the main navigation(Left panel to switch forms) HOw can I do this....What is an example of this....Reason we do this is so the user does not have to click a save button but when they move to a new view(form) it needs to save changed data..... ...Show All

• SQL Server SQL Task Returning XML Error

  Hi.. I use an Execute SQL Task to return XML via a stored procedure but the task fails for some reason.. My Settings in Execute SQL Task Editor is: General ResultSet: XML SqlStatement EXEC dbo.myProc ResultSet Result Name = 0 Variable Name = sXml (Variable Type = String) When i run the proc (which uses FOR XML PATH) from Management Studio the following is returned (no outputparemeters are used): <Data> <Sty> <Sys>PXX</Sys> <Ftg>01</Ftg> <Anv>xxx</Anv> <Losen>yyyy</Losen> <Fok>zzz</Fok> <Funk>02</Funk> </Sty> <InkOrd B="N" Id="000945"> <InkOrdNr>000945</InkOrdNr> <DelLevns ...Show All

• Windows Forms datagridview cell validating

  On a form I have a datagridview and input fields. When the row changes in the datagridview the input fields update with the record information. When the row changes I want to verify the data entered in the input fields. I tried doing this in the CellValidating event Handler. However, the event fires every time that the focus switches from the datagridview to the input fields. is there anyway to only fire the cellVerifying event when the row changes to another row, and not when the focus leaves the datagridview. Thanks in advance . I had the same problem. My problem was specifically, when do I call the update method. I found a solution. I used two events. private void dataGridView1_CellBegi ...Show All

• Visual C# CS1525: Invalid expression term 'char'

  temp+=Replace(temp, char (13),"<br>"); temp+=Replace(temp , (char) (13),"<br>"); ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sizeof(Color) struct / Terrain Rendering issue

  I'm working on translating a Terrain generation project from a Direct3D book that I purchased into C#/XNA. I so far have accomplished 1) Generating a height map using the algorithm in the book adapted to C# 2) Taking that height map and rendering it to the screen using a Panel in a Windows Forms app (the panel is passed to the GraphicsDevice). Everything works beautifully. Last night, I built out the classes/structs I needed to convert the heightmap into a grid of patches that then are rendered as a model to the panel. I had some bugs in translating to XNA because of no Mesh object. However, I was able to overcome those. It looks like my terrain is rendering, however, I don't think its correctly using my COLOR data. I built out the s ...Show All