Luis Esteban Valencia Muñoz's Q&A profile
SQL Server Capture errors from SSIS Execute Process Task
I have an Execute Process Task within my package that executes a BCP command which outputs the resultset of a query to a file in the network share. It works fine most of the time, however sometimes for unknown reasons, the following error message gets logged in my log table - In Executing "c:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" "Select Comments, SoldToCustomerNbr, ProductGroupingCode, ProductGroupingName, RevSumCategoryCode, RevSumCategoryName, ValidFromDate, DTSCollectPct, DTSPrepaidPct, DTSPickUpPct, DCCollectPct, DCPrepaidPct, DCPickUpPct From ShipmentTypeCustomerBlend" queryout \\xxx\LOG\ShipmentTypeCustomerBlendLog_060719201440.txt -c -t"\t" -SDummyServer -T -e"d:\SSIS Error ...Show All
Software Development for Windows Vista Error when installing my application under Windows Vista RC2 (running object table?)
Hi, I have just discovered that my installation fails on Windows Vista RC2. The installation was written under InstallShield 10.5 professional, as an "Installscript MSI project" and works properly on Windows 2000 and XP. I have recorded a log of the failure: Action ended 12:39:41: CostFinalize. Return value 1. MSI (c) (84:48) [12:39:41:188]: Doing action: SetServerDir Action 12:39:41: SetServerDir. Action start 12:39:41: SetServerDir. Action ended 12:39:41: SetServerDir. Return value 1. MSI (c) (84:48) [12:39:41:188]: Doing action: MigrateFeatureStates Action 12:39:41: MigrateFeatureStates. Migrating feature states from related applications Action start 12:39:41: MigrateFeatureStates. Action ended 12:39:41: MigrateFeatureStates. Return val ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Having a little trouble with XNA Spot tutorial...
I have been doing the How to Draw a 2D Sprite tutorial from xnaspot.com,and I still have a lot to learn and I got all the info inputed and there is one error that I cannot figure out, and that is in the update funtion, I put what I was supposed to, and even tried pasting it, because I have been typing everything to get it down (I would be way past it if I just copied and pasted) and it seems like there should be a }, yet when I put that down it still says }expected, I tried removing it and 9 more errors popped up, so I need to know, what am I doing wrong I would greatly appreciatte any help you guys can give me. I removed that, as I have tried before, and I still get the "expected" I am getting a little bit frusterated becau ...Show All
.NET Development socket errors over VPN
Hi there! We have a client / server control system. Remote Clients talk to the server using windows sockets. All works fine over a LAN, but fails over a VPN or a dialup. In the latter case communications work for a while, then a message is lost (response does not come back or is corrupted), and things fail. I noticed that if I lower the max. size of our messages from 64k to 1K things improve a bit, but then things get really slow because of many trips to the server and back. Anybody have any clue why this is happening The code is written in C++, I am using socket library version 2.0, Windows XP SP2 + all latest updates. Socket routines were implemented using the WSA functions (WSAInit(), WSARecv(), etc). In dialup case machi ...Show All
SQL Server Connecting to Local Database after Application Install
I have created an application which uses a SQL Express database. The program runs fine on the the computer where I built the app, however when I install the app on another computer I get an error telling me that under default SQL Express does not allow remote connections. The problem is that I dont want a remote connection I want a local connection, the database file is on the commputer. How can do get my application to look for the database on the local machine. My connection string is: Data Source=(local)\SQLEXPRESS;Initial Catalog="C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\PLDAQ.MDF";Integrated Security=True I have made sure that the file is in the correct directory. Any help would be greatly appretiated An ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Should my 2D game engine use Vector2s or pairs of floats?
I just recently changed, oh, about a 1000 lines of code in my game engine. Instead of using Vector2 for things like position and size, I decided to use floats instead. Does anyone else use Vector2's as their main position and size data types in their 2D game Right now, I have the code for both versions, and I'm trying to make entirely sure floats are the way to go before throwing one of them away. Any comments Really, I think the best way to answer this question is to ask what other 2D libraries are using out there. Considering compatibility among components, using what is most popular in other component libraries may be the most important thing to consider. Noone wants to use one component that is float-based along with anothe ...Show All
Visual C++ How to build strmbase.lib?
I've got BaseClasses for DirectShow, and I don't know how to build strmbase.lib. I would be grateful for any sugestions. ...Show All
Visual C++ What is the DisAssembly (internal) Code of RoundRect() API (for PostScript equivalent)
Hi, On the following parameter of RoundRect(...Left, Top, Right, Bottom, VRadius,HRadius) is giving correct output on the screen for differect parameter values. 1.) 8.4 -253.9 238.2 -482.9 280 -190 2.) 5.5 -547.4 420 -727 360 -360 3.) 368.2 -247.5 540.9 -533.6 150 -190 But if I use the same value in the postscript code to draw the rounded rectangle, it does not gives the correct output. I have used the below mentioned postscript code to draw the rounded rectangle. Please tell me what logic or algorithm uses the RoundRect() API to draw different types of rouded rectangle with different value. ================================== %!PS-Adobe-3.0 %%BeginProlog %% Set color (c m y k) /CMYK { 255 div 4 1 roll ...Show All
Visual Studio Express Editions BindingManagerBase Position_Changed Problem
Hey Everyone, I have a program that has several textboxes bound to 1 dataset which contains only one table. When the form loads, the data is displayed in the textboxes allowing the user to add, edit, delete, etc., as well as navigate through previously entered records. However, when trying to navigate through the records, it doesn't do anything. The recordCountLabel, which keeps track of the record number that is displayed, changes, but the first record stays on the screen. Here is a little of my code. Protected Enum Record RecordNum DDate Shift ATO Vehicle End Enum Private Sub Form_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load 'Loads data into the 'TripSheetI ...Show All
Visual Studio Unable to open/debug a remote site from VS2005
I am trying to set up a new testing server (running Windows Server 2003 R2) for remote debugging of my aspnet applications with Visual Studios 2005, but am encountering problems with Front Page Server Extensions. When I first try to extend the site, either through IIS (with the Configure Server Extensions 2002 task) or the Microsoft SharePoint Administrator link, the IE browser seems to hang while trying to open fpadmdll.dll from the Microsoft SharePoint Administration site which was installed with fpse. However the extension appears to have been successful since if I try again I can now access the Site Administration Page after entering the username and password. Once here, I try to create a subweb specifying the ...Show All
Visual C# Stream does not support seek operation?
Downloading a bunch of *.csv files I got an exception at #69 (out of total 116): "This stream does not support seek operations."} System.SystemException {System.NotSupportedException} I am wondering if anybody could comment on that. Thanks. Thank you, Tom, I cannot reproduce the error now. I download these files about every day and so far I've done it about a dozen times. Every time this routine worked well except yesterday. It worked this morning as well. For some reason that I do not understand it broke down yesterday. I had no ime to investigate why and I did not repeat a run. I have a control indicator on my form showing me what particular file is being downloaded. You can see that the download code is in a ...Show All
Windows Forms ToolStrip doesn't scale buttons in the overflow menu
Hi there I use several ToolStrips in my application. They are placed in MDI-forms, which are created dynamically at runtime. The application has to adjust to the users DPI-setting. The AutoScaleMode property is fine, but as i see it, it doesn't work for the dynamically created MDIs. Because of this i scale them by myself with the Scale method. This works quite good for everything but the ToolStrip. I have several buttons inside the toolstrip, added with the ToolStripControlHost. When the form is scaled, everything resizes fine, but the toolstrip scales only the buttons that are visible (not in overflow). This is really annoying, and till now, i couldn't find a workaround. Hope someone can help me here. PS: sry, englis ...Show All
SQL Server DTS 2000
Hi, I am having a dts 2000 package which is accessing oracle source and loading data into sql server .The package runs fine when ran individually or from designer. But when it is scheduled into a job, the job is being shown as ran successfully whereas the package is not run or for sure the data is not loaded. I looked into microsoft articles regarding this problem and found that this job will be run under the profile who started the SQL Server Agent.There is another job which is running properly whose owner is xxx. So i changed the owner of my job into xxx. But still the same condition is prevailing, job is being shown as ran successfully while the data is not loaded. Kindly help me on this. Thanks and Regards Arobind ...Show All
Visual Studio Team System MSBuild is ignoring command-line parameters
Hello, I'm using MSBuild.exe to deploy my project. Here's the command that I am using: msbuild /t:SQLDeploy /property:ConnectionString="Data Source= BDONT3IFBSQL1 ;Integrated Security=True;Pooling=False" Chevron.UpstreamSolutions.SqlServer.MinervaRepository.dbproj OK, now note the name of the server which I have highlighted . MSBuild seems to ignore the ConnectionString on the command-line because it deploys it to (local) which is what is defined in the project. And to confirm it, here's the output from MSBuild: Project "C:\TFSProjects\Chevron\Minerva\src\Solutions\Chevron.UpstreamSolutions.SqlServer.MinervaRepository\Chevron.UpstreamSolutions.SqlServer.MinervaRepository.dbproj" (SQLDeploytargets)): Ta ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Where to Find XNA Documentation, Including Tutorials and Samples!
Hey Everyone, The XNA Documentation team wants to let you know that in addition to Spacewar, some great tutorials and "how-to" type articles - including full working source code - are available for you to read and play with! You get them when you download and install XNA Game Studio Express (Beta) - here's where to find them: Start Visual C# Express, and click on "Help" in the menu bar. Select "Contents" from the menu that drops down. This will open up the help viewer. When the help viewer opens, you'll see an "XNA" category. Expand that category, then expand the "XNA Game Studio Express" category under that. You'll find: Frequently Asked Questions Getting Started (co ...Show All
