MunishGupta's Q&A profile

• SharePoint Products and Technologies BDC and AdventureWorks SQL 2005 Version

  Hi, I'm trying to work with the AdventureWorks sample database SQL 2005 version and BDC in MOSS 2007. The application is correctly defined in MOSS, using the sample XML application definition file for AdventureWorks SQL2000 version. When I try to retrieve data from the web part, I get an error message stating "An error occurred while retrieving data from AdventureWorksSQL2005. Administrators, see the server log for more information". First question - Which server log (MOSS, SQL, others) Also, in the Event Viewer of the server, I found this entry: Could not run query/stored proceedure 'SELECT ProductID, Name, ProductNumber, ListPrice FROM Product WHERE (ProductID >= @MinProductID) AND (ProductID <= @MaxProductID) AN ...Show All

• .NET Development Where is Sysem.ServiceModel?

  I just installed VS 2005 with version 2.0 of the framework. I'm attempting to work through a WCF example. I don't see the ServiceModel in the AddReference list. Is this a 2.0 or 3.0 component So, if I understand correctly do you have to install both the SDK and orcas to get VS 2005 to recognize the System.SystemModel .dll in the AddReference screen I installed 3.0 framework and it still does not show in the list. ...Show All

• .NET Development Check to see if an IPC channel is open

  Hi, I'm pretty new to using IPC remoting, and I was wondering if I could get some help. I've followed the steps in the MSDN examples for remoting between two processes. One is set up as a server and one is set up as a client. It works perfectly when the server is running. My question was, is there a way to check if the IPC channel that the server opens is open before trying to use the singleton object that we are remoting, instead of letting it fail and catching it in a try/catch Is there such a Methods that would look something like : IPCChannel.IsOpen("ipc//ServerApp/SingletonObject") Thanks, Brad ...Show All

• SQL Server Error viewing cube from Excel

  When attempting to connect to an OLAP cube from excel. The Multidimensional Connection returns the error: "Unable to open connection. Cannot connect to the server 'myServername'. The server is either not started or too busy." Can someone please help to resolve this Take a look at the connection troubleshooting guide here: http://www.sqljunkies.com/WebLog/edwardm/ Another suggestion, try and repair your office installation by going through Add/Remove programs in Control panel. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Smart Device Development What is the difference?

  Hi, Is there any difference between dotnet framework 2.0 and .Net compact framework What is the need of compact framework Thanks Yes there is. The .NET Compact Framework enables managed evelopment on Windows Mobile Devices and other devices based on the Windows CE operating system. The key differences are documented here: http://msdn2.microsoft.com/en-us/library/w6ah6cw1.aspx Michael ...Show All

• SQL Server Date format

  I'm trying to build a file-name variable that begins with a 'date'. For example, I need to build logic in a T-SQL script that will access a file called 08032006abc123, with '08032006' being a representation of the date 8/3/2006. Is there a quick/easy way to create this string, based on the date 8/3/2006 (would be nice if there was a date function that would zero-fill) If you can use the date format YYYYMMDD or YYMMDD you can use CONVERT to get the encoded date ( http://msdn2.microsoft.com/en-us/library/ms187928.aspx ) else you can always do this and then rearrange the out string using the SUBSTR ...Show All

• Visual Basic Dealing with null values

  I remember when I was using VB6 that I always used If IsNull() End If statements to check for null records before performing any kinda of calculations, does this still hold true or what is the best way to deal with nulls Davids Learned Alot Today! Something funny with this post spotty and its not you I havent marked this as an answer yet, but it shows up as if I had and I havent Any ideals ...Show All

• SQL Server Error permissions

  I am getting the following error: System.Web.Services.Protocols.SoapException: The permissions granted to user 'MachineName\IUSR_MachineName' are insufficient for performing this operation. ---> I gave anonymous access via Inetmgr directory security and also gave the security permissions direct to folder to for ASPNET and iusr_machinename bith gave full access rights andf also under services gave log in permissions to my account name for reportserver under services. I am so confused now , please can someone help. Thank you very much for the information. If you are trying to turn on anoymous access to RS you must be careful. When anonymous access is turned on every user is seen a ...Show All

• Software Development for Windows Vista Windows Workflow Sept VS Integration Hangs Visual Studio

  As I just posted on my blog : So, I installed the .NET Framework 3.0 Sept CTP today at work. At least, for me, the WF Visual Studio integration causes my Visual Studio to hang on launch using 50% of the CPU indefinetly. If I uninstall WF (RC5), Visual Studio returns to being fine. Its fine with the other CS integrations in the "Orcas Tools" of Sept like Avalon and Indigo wizards. Has anyone else seen this ...Show All

• SQL Server Profit optimisation with OLAP

  Hello, I have some questions arise by a customer project. The customer has many carriers. He must decide which carrier he chooses to get the highest profit. So the customer needs a system which makes it possible to find the optimal carrier for the transportation of goods. Actually this problem is a critical path problem but my question is, is it possible to realize a disposition system for this customer with OLAP and the technologies of the Microsoft SQL Server 2005 And has Excel 2007 any new Tools, who can help me Thanks a lot! ...Show All

• Smart Device Development Connect with GPRS programatically for Pocket PC Client application

  Hi All, I am developing Client Server TCP/IP based application in VB.Net. My Client Application is Smart Device application and going to be run on PDAs. This Client Application will connect with my server via TCP/IP using sockets. My Server Application is win form based application and going to be run on our server. Problem: { My Client Application needs GPRS to be connected. So, if GPRS is not connected, we have to do it manually. I am looking for the way where i can first check status of GPRS and then if it is in disconnected mode, i can connect is automatically using code. } I searched on net for the same and somewhere I found about Connection Manager Class of Open Net CF. But i didn't get any exact way or code sample to do it. I als ...Show All

• Windows Forms Path Conformity Validation

  Does anyone know of an algorithm to check if a string comforms to UNC or drive path It will be good if you can extend it to vefiry a full-pathname specification. NOTE: I'm looking for CONFORMITY checking. you could also try this Regex, although a bit more expensive.... System.Text.RegularExpressions.Regex theRegex = new System.Text.RegularExpressions(@"\\( <TheServer>\w*)\\( <TheService>\w*)\\"); if (theRegex.IsMatch(inputString)) { MessageBox.Show("UNC Path"); } Usage: theInputString = @" \\test " -> false theInputString = @" \\test \path" -> true theInputString = @"C:\" -> false ...Show All

• Visual C++ Mixed mode C++/CLI idiom

  In my C++/CLI components, for each component I create a ref CLR class and a C++ class, the latter which does most of the internal processing and interfaces to the C++ standard library and 3rd party libraries such as Boost. I do this so I can use C++ libraries in my CLR component, especially when the .Net framework does not offer all the facilities which 3rd party C++ libraries have. In order to allow the C++ class to access the properties, methods, and events of the corresponding CLR class I have a pointer to the C++ class as a private member of my CLR class and dynamically create an object of the C++ class, passing a pointer ( ^ ) to the CLR object to the constructor of the C++ class, and assign the resulting C++ object to the pointer in ...Show All

• Visual C++ Napster Visual C++ Runtime Error

  When starting Napster I now get an Error that says Microsoft Visual C++ Runtime Library Runtime Error Program E:\Program Files\Napster.exe The application has requester Napster to terminate in an unusual way. I have contacted Napster and re-installed it along with updating Media Player 10 and in line with other mentions on these forums I have deleted Google toolbar and Mozilla Firefox. I have AVG free and Zone Alarm as firewall and antivirus and i am running XP student with SP2. I have also deleted DivX video software and Itunes and run spyware tools, MS update and Ccleaner. I still get the above error. Can anybody suggest what has happened or what I may do to get Napster working again. Thanks Tony ...Show All

• .NET Development Errors installing .Net F..work 3.0

  While trying to install >NET Framework 3.0 I got several errors: 1) NGEN.exe -- Entry point could not be found: "The procedure entry point CorGetSvc could not be located in the dynamic link library mscoree.dll" 2) Microsoft Visual C++ Runtime Library: "Programs: C:\Documents a... This application has requested the runtime to terminate it in an unusual way. Please contact the application's support team for more information." I stopped installation at this point. In a previous post someone pointed out that a repair to the .NET components would do the trick. Well, .NET F.. is not installed! (any versions) Ideas, please! I am sorry to hear that. Please email me aaronru ...Show All