DavidP5's Q&A profile

• .NET Development Data connection failed to open

  Hello, I'm attempting to install a Worker Service responsible for performing regular operations and communicating back and forth to a SQL Server 2005 database on a remote machine. I have a thin client that allows the user to make configurations, and although the first connection can take 20 seconds or so, the client succeeds at communicating with the database. The worker service, however, fails to do so every time. On startup, I attempt to communicate with the server three times: 1) send the current time as the service's boot time, 2) send the current time as the service's "heartbeat", and 3) get outstanding items to process. The first two return the following error in the Application service log: Data connection failed ...Show All

• SQL Server Dynamic FTP Connection

  Hello , I have a table having different ftp url,user name, passwod, port no.I want to copy the file from all the location on my server at. How can I change the connection string/ FTP location for FTP connection manager at rum time in SSIS. Thanks Hi, You should be able to set up a variable and set its value to the Connection expression in the FTP Task. If you right click on the FTP task and then select edit. The left hand menu should show a link for expressions. Add a new expression for Connection and set it to the variable you have set up to store this value. This variable can be changed at runtime using Package Configurations. Does this help at all. Grant ...Show All

• Visual Studio 2008 (Pre-release) Service Configuration Editor and custom bindings

  Is it possible to have the Service Configuration Editor correctly represent an XmlDictionaryReaderQuotasElement property on a custom message encoder in a custom binding I'd like to have Reader Quotas display in the editor with all its properties read/write, as usually seen on a standard binding or message encoding; instead I get a read-only property that displays only the type of the element. I'm using the GZipMessageEncoding binding element from the SDK with a few changes. The config as shown below works when the configuration is applied to the binding element, but it would be nice to have the editor show the Reader Quotas property correctly. <customBinding> <binding name="compressedBinding"> <gzipMess ...Show All

• SQL Server Finding deatail Deadlock info IN SQl Server 2005 Standard Edtion

  We are using SQL Server 2005 with SP2.Originally, we seemed to be having a lot of unnecessary lock escalation occurring to the page and table level. I would like to track down all storedprocedure/queries or function that are being casue of deadlock in sql server 2005 with all deadlock input like transactionID ,command ran,loginID etc.But we have to need to find these information on SQL Server 2005 standard edtion. Is there any tool,command or something like this which track down these information blindly in sql server 2005 without effecting system performance seriously. Ahamd Drshen Use SQL Server Profiler with DeadLock Graph Event. Or use stored procedures sp_create_trace and sp_trace_setevent for collecting profile ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Game Studio Pro

  I just wanted to know if anyone had any info on the cost of XNA GSP, cause i've been surfin on google and found that some rumors are goin around about MS selling new dev kits for 360 for only $100.. Ri-Karou wrote: Found it http://news.cnet.co.uk/gamesgear/0,39029682,49258739,00.htm !! That's talking about the Developer's Club. ...Show All

• SQL Server unique INDEX with upper/lower case

  Hi I can't create unique index like that: 1 - create table abc ( colZ varchar(10) ) 2 - insert into abc values ( "test") 3 - insert into abc values ("Test") 4 - create unique index idx_abc on abc ( colZ ) -- This doesnt work .... duplicate key was found for object name abc...... Is not there difference between "Test" and "test" Can I work around this cheers, The default COLLATION for SQL Server is not case sensitive which means indexes, WHERE clauses, etc. are not case sensitive, this can be overridden at the database, table and column level. Search for COLLATION in books online. ...Show All

• Visual Studio Express Editions MFC Appwizard

  Hey, I don't know, maybe it's a stupid question, but I don't know where to find MFC Appwizard. Is it included in Visual C++ express edition (Don't find it in projects) thanks ...Show All

• SQL Server Dynamic selection of flat file

  I am writing a package where the user uploads a flat file to a web folder. I need to automate this package to run everytime it sees a new file. How can I implement this Can I make a call to a package or a sql server job to run from .net 2.0 Do I need to use a service broker to look for a new file and run the package or a stored proc....I am looking for an async process where user doesnt have to wait for the package to run as it involves data validation of flat file and its huge... Please help!! Appreciate your response... I was wondering about creating a config file in the database and update the Connection string value everytime a new file is uploaded with the new file name And then call the package to run by addin ...Show All

• .NET Development Oracle not listed as a data source

  Hi, I am running Oracle 10g express and Visual C# express. I am trying to connect to an Oracle database but when I select Add Connections, I do not see Oracle listed as a data source. I have the Oracle .NET data provider intalled but again, nothing seems to work. I have been banging my head against a wall for the last 3 nights trying to connect to the Oracle database (on the same server). I have done a TNSPING and everything is working with the database. Please help. I am new to .NET/ODBC etc. so please keep answers simple although I do have a lot of C experience from years ago. Thanks. ODP.NET does not show up in the list of data providers in VS2005. This is apparently something they will add in the next ...Show All

• Visual Studio Team System TFS Dual Server Deployment Licensing Question

  One doc I read on TFS licensing said that you need a license for every server you install TFS on. That sounds reasonable but what does that mean in a dual server (separate App/Data tier) deployment Does that mean you need to buy two TFS licenses for a dual server deployment I mean it's a single "logical" server, right Yeah I agree with you on the last point. It's just that our IT folks tend to "over engineer" things, jump straight to the dual server model with SQL installed on an 8 proc server and then complain that they have to buy two TFS licenses (and a separate SQL license for 8 proc support). And we don't have anywhere near the number of TFS users yet or in the near future to jus ...Show All

• Visual Studio Express Editions Is there a trick to avoid the installation of service pack 2?

  Hello, I have a few questions. Question 1 I have just tried to install Visual C++ express edition. Why do I have to use service pack 2 I do not want to install it. It took me 30 minutes to install service pack 2 and I will never use it. Why is that Is there a trick to avoid the installation of service pack 2 Question 2 Someone is writing a software package for me and the compiler of Visual C++ express edition has to be built into the software. Only the compiler! I intend to use the package for my own use, but let's say I am going to sell the package later while the compiler is in it, is that ok But what if a customer of Microsoft like me isn't interested in the security upd ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Maybe I'm an idiot

  First, for some reason I try to use spacewars and after I have the menu open it will not work with my mouse or my keyboard. Also is there supposed to be any graphic editors that come with xna Sorry to waste peoples time, Thanks in advance, Cody 'idiot' isn't a word we like to use round here but if you had searched for forums for 'spacewar keyboard', you would have found a LOT of threads about how to make it work. By default it is controller only. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=682463&SiteID=1 http://www.xnaspot.com/Tutorial_GettingStarted.aspx Please search for your problems before posting. ...Show All

• Visual Studio 2008 (Pre-release) How do I scroll a TreeViewItem into view?

  Is the a ScrollIntoView equivalent for TreeView Here's what I ended up using: treeViewItem.IsSelected = true ; while (treeViewItem != null ) { treeViewItem.IsExpanded = true ; treeViewItem = treeViewItem.Parent as TreeViewItem ; } treeViewItem.Focus(); ...Show All

• Software Development for Windows Vista generic interface issues

  I'm having an issue trying to use a generic typed interface with WWF. I have an interface defined like so: [ ExternalDataExchangeAttribute ()] public interface IInterfaceName <TCommand> where TCommand : ConstraintType { void MethodName(TCommand Request); event EventHandler < ExecuteEventArgs <TCommand>> ExecuteStarted; event EventHandler < ExecuteEventArgs <TCommand>> ExecuteValidated; event EventHandler < ExecuteCompletedEventArgs <TCommand>> ExecuteCompleted; } This compiles fine, but when I try to use this interface as the InterfaceType for a HandleExternalEventActivity in a Sequential Workflow with code separation, the interface name shows as IInterfac ...Show All

• SQL Server Another aggregation design question

  Guys, I model a cube with dimensions, I create the partitions and their aggregations, then I change the dimensions structure or I change the dataview. Cube does not complain about aggregations at any time during the change process. So what is this all about I suspect I should run a re-design of aggregations when I am done with structural changes but I wonder why I am never warned about existing aggregations becoming obsolete So when should you re-design aggregations (I use 30% then I add usage based after a while). Thanks, Philippe Yes, you need to go an re-desing your aggregations after you've made stuctural changes to your dimension: You've added, or removed attrubutes from the dime ...Show All