Marauderz's Q&A profile

• SQL Server String character literal in c#

  when i execute in sql this works fine: xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveMainMultiTables.dtsx" /Conn TahoeDB;"Provider=SQLNCLI.1;Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;"' but when i execute in C# i get this value string connect = @"TahoeDB;""Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;"""; xp_cmdshell 'dtexec /f \"D:\\SSISProject\\Integration Services Project1\\ArchiveMainMultiTables.dtsx\" /Conn \"TahoeDB;\"Data Source=SE413695\\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security= ...Show All

• Windows Forms Programicaly creating a ShortCut

  In my Windows Forms application I have created a self-exracting archive (Program Installer) for my main application. How would I go about creating shortcut icon that points to my applications executable file I looked in the System::IO::File class but couldn't find anything and don't know where else I would have to look. C# doesn't use header files. A rough equivalent is Add Reference in the Solution Explorer... ...Show All

• .NET Development exe problem...

  hi.. when i try to run my application on another computer that doesnt have the .net visual studio installed on it, the exe does not run!! knowing that .net frame work 1.1, and 2.0 are installed .. this happened only after i included directX.capture.dll and DShowNet.dll.. dunno if this is related but i get some worning saying that using UCOMIMONIKER is obsolete.. and the exception message is "No device of the category".... it happens here public static void Main(string[] args) { try { Application.Run(new SocketTeacher()); } catch (Exception ex) { MessageBox.Show("line 113\n"+ "\n"+ ex.InnerException + ex.Message + "\n" + ex.Data + "\n"+ ex.S ...Show All

• .NET Development Unable to locate Assembly asdlfkjasdfkljasd

  OK, this one is a real head scratcher. I have a paticuarl application on my beta server that flips out almost every time I modify the source code. It gives me an error saying that the cached assembly doesnt exist. Sounds like a permission issue right But I've checked for all of that... and my other apps work just fine. So I google and find some info on app-pools, so i stick the app in its own app pool. Still.... same problems. I spent an entire day fighitng with this thing... all to no avail. It is a win 2k3 server with .net 1.1, and 2.0 installed. I have currently ONLY .net 1.1 apps setup in IIS. Could this be caused by a flaw in my code If so How This is extremely frustrating because its preventing me from coding :| Someone ...Show All

• Commerce Server 3rd Party Payment

  Hi I'm having trouble figuring out how to implement a 3rd party payment solution from within the starter site. Has anybody used a 3rd party to collect payment from within CS I'm trying to figure out whether I need to create a new payment pipeline, or whether the existing one can be modified. We are planning on using Protx, who provide an ASP.Net integration solution. I'm a newbie by the way, so that might explain why I can't find such a solution. Paul Paul, Unless Protx provides a pre-compiled pipeline component which you can add to your solution, you're going to have to build your own pipeline component which you'll probably end up adding to your checkout pipeline. Due to changes in the o ...Show All

• Windows Forms DateTime format problem in SQL query...

  Hi! I have a DataGridView connected to a dataset and I 've already created a query which searches the entire database in order to extract rows with a certain date. The user enters the desirable date in a textbox. But there is a problem with the date format: I've found that when i enter the date in the following format: MM/dd/yyyy it works fine.But wherever i am using this format: dd/MM/yyyy Visual Studio generates the following error: ''An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.'' Any help how to overcome this problem ...Show All

• Community Chat Free List - Version 1.00.02

  http://www.barrysumpter.com v 1.00.02 - Enhancements: Moved command buttons to Tool Strip after converting all .ico libraries to .gif. (Major undertaking.) Changed Icons. Updated Node icons. A Right-click on a tree node now selects that tree node before displaying the popup menu. I've lighted up a bit with more wording and spelling corrections on this web page. This is a follow up thread from the original here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1103536&SiteID=1 The original thread kind of lost focus. Free Lists is the only app there written in vb.net. Don't worry about the other products. I've only sold 1 of each. So I ...Show All

• SQL Server How to do QTD and MTD in MDX ?

  I want to use the setup as used in the "A different approach to to Time Calculations" http://www.obs3.com/A%20Different%20Approach%20to%20Time%20Calculations%20in%20SSAS.pdf But i still need Month to date and Quarter to date, as sepperate members in the Time calculation dimension (i know i can use the periods to date). As with the other members in the dimension this shall apply to every meassure that might be in the cube. Can someone give an example of how to do it in MDX The YTD looks like this: -- YTD CALCULATIONS ([Time Calculations].[YTD]= Aggregate( {[Time Calculations].&[Current Period]} * PeriodsToDate([Time].[Calendar Hierarchy].[Year], [Time].[Cale ...Show All

• Visual Studio 2008 (Pre-release) SecurityNegotiationException Issue accessing WCF service when Client is in different Machine

  Hi, I have created WCF service and Client. It is working fine, if both service and client are in same system, but if i place the client module in different system which under the same domain, i am getting the security negotiation exception The following is App.config configuration : < xml version = " 1.0 " encoding = " utf-8 " > < configuration > < system.serviceModel > < bindings > < wsHttpBinding > < binding name = " WSHttpBinding_IMetaDataService " closeTimeout = " 00:01:00 " openTimeout = " 00:01:00 " receiveTimeout = " 00:10:00 " sendTimeout = " 00:01:00 " bypassProxyOnLocal = " ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Present() hangs for 10 seconds when mixing DirectX full screen and GDI

  I'm using C# and MDX. When I setup DirectX to go full screen, and then also use GDI to draw on another form on a different display, the Present() function can hang for 10 seconds. When it hangs, even the mouse pointer stops moving. When it comes back to life and I click on a form, it looks like GDI is resetting or something (the monitor goes black for a few seconds, then redraws), and sometimes there is junk on one of the displays. Sometimes it hangs forever, and I have to do a hardware reset to fix the problem. Changing PresentInterval to Immediate fixes the problem, but I'd prefer to have DirectX do the vertical sync for me. Any ideas Thanks, Jeremy > Does this happen with the Mana ...Show All

• Microsoft ISV Community Center Forums WMI.Net 2.0

  The next manged code library for WMI was discussed at TechEd this year and has popped up in a couple of webCasts. -- The WMI.Net 2.0 is supposed to provide writeable properties and invokable methods from managed code. Is there an update on the release Beta program etc... -- I posted an article on MSDN on the writing of WMI.NET v2.0 coupled providers http://msdn2.microsoft.com/en-us/library/cc268228.aspx . It should take care of most questions regarding WMI.NET Provider Extension 2.0. Gabriel ...Show All

• SQL Server Business Intelligence Projects

  how can i make Business Intelligence Projects available in vs 2005 Thanks I installed VS 2005 and SQL SErver 2005 client on a 32 -bit machine. I still don't see Business Intelligence Projects when I open VS2005 and select New - Projects. Can someone help me trouble shoot Thanks ...Show All

• Visual Studio Team System Version vs Changeset

  What is the difference between Version and Changeset When viewing history of an item, I only get changeset numbers but when I am looking at all the files asscoiated with a label (by going into labels, find and then double clicking on the label), I get a Version column with numbers. What I'm really trying do is to find out which version (or changeset) of an item is associated with a label so that I can compare it with another version. But I am getting a bit confused. Any idea how I can compare versions (or changesets) associated with two different labels Hello, Have a look at Richard Berg post in this thread - there he attempts to address the version/changeset definitions question. WBR, E ...Show All

• SQL Server Quick question to check NULL values in input parameters in a stored procedure

  Hi: I have a stored procedure that calls 3 stored procedures. If some of my input parameters are NULL, I would like to skip the call to another stored procedure. Can you someone please help me with this I would like to find out what is NULL, before I execute the other stored procedures. Thanks so much. MA check with is not null example If @Var1 is not null begin exec proc1 @Var1 end If @Var2 is not null begin exec proc2 @Var2 end If @Var3 is not null begin exec proc3 @Var3 end Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• SQL Server Receive "Must declare the variable" When Upgrading to Reporting Services 2005

  We are in the process of migrating our databases to SQL Server 2005 and our Reporting Services Reports to 2005. We have been doing this in a phased approach with excellent success. However, I have a set of Reporting Services 2000 reports that are reading from a SQL Server 7.0 database. If possible, I would like to migrate the reports before we migrate the database (we're not ready to migrate the database yet). When I converted the reports to Reporting Services 2005, I first received an error message regarding my data source. Basically the message says anything developed in Visual Studio 2005 using the Microsoft SQL Server connection type cannot connect to a database prior to Microsoft SQL Server 2000. So I switched the connection st ...Show All