lagu2653's Q&A profile

• SQL Server OLE DB provider "MSOLAP" linked svr "Errors in the back-end database data provider does not support support preparing queries

  Is it that I have a syntax error in the nested OPENQUERY or is there another issue Do I need to specify a different provider in the Server Link such as OLEDB Non-nested OPENQUERYs work fine. I'm generally following theTips and Tricks article. "Executing predictions from the SQL Server relational engine". One problem is the sample doesn't actually complete the example query after the second nested OPENQUERY call. e.g.    SELECT * FROM OPENQUERY ( DMServer , 'select … FROM Modell PREDICTION JOIN OPENQUERY …' ) The SQL Server server link's provider is configured to allow adhoc access. I appears that the inner OPENQUERY cannot be prepared by Analysis Server or the Server link provider but I need to return a ke ...Show All

• Microsoft ISV Community Center Forums How do I open CSV using Excel without deleting leading zeros?

  Hello, Whenever I open up a CSV file or a Text file, Excel treats string like 05710 as a number and turn it into 5710. How do I open up a CSV file and still keep the leading zeros Thank you very much. One way to divine the inner workings of any office document and how to manage it via the interops is to record a macro of the process needed. Once done examine the vba code, it will show settings changes and other items of interest that can lead the way through the tribal knowledge of the interops. If no one has an answer...try posting it in the Discussions in Office Development or for a better responses or Discussions in Automation forum for interop questions. ...Show All

• SQL Server Open SqlCeConnection from an ASP.NET Web Service?

  Help! I am trying to implement a web service that creates and populates a SQL Mobile database file, then returns the created database to a mobile device as a byte array. The database size could be in excess of 500,000 rows, which is why I want to do as much of this preprocessing on the server before it gets to the mobile device. I can't use replication since I have to do some shaping of the data before I can use it on the mobile device. Unfortunately, the web service is throwing the following exception when I try to instantiate a SqlCeConnection object: "System.NotSupportedException: SQL Server Everywhere Edition is not intended for ASP.NET development." Are there any suggestions as to how I can get around this potent ...Show All

• Visual Studio VS2005 Registration Benefits - not allowed access to Registration Benefit Portal

  I just registered my copy of VS2005 Standard Edition that I received at the VS2005 Launch. One of the benefits of registering is free icons, components, etc. When I try to go to the Registration Benefit Portal to download them I get a page stating that the page is missing or I lack authorization. Is there a trick to this -Chris I encountered this same problem yesterday when I registered my copy of Microsoft Visual Studio 2005 Team Suite. However, when I returned today to the Visual Studio 2005 Registration Benefits Portal (accessed by clicking the "Registration Benefit Portal" link in my "Thank you for registering Visual Studio" confirmation e-mail), I was able to access the Portal without any problems. Sorr ...Show All

• Visual C# For Loop

  In the following snippet, I got nothing in "path": for ( int j=arrcolid.Count-1;j==0;j-- )    {     path += arrcolid[j];    }   But in the following snippet, path is "DogCatFox", Why for ( int j=0;j<arrcolid.Count;j++ )   {       path+=arrcolid[j];   } gkantsidis , thks a lot! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpaceWar with a PC controller?

  Hello, I was experimenting the SpaceWar application, but it seems to expect a xbox360 controller instead of a broad PC controller since... well, I'm running it on a PC. Do you know anything about that I should be able to use it. I have a team that wants to use XNA for the PC platform - we could hardly care about the xbox360 at the moment. Forcing our players to have a xbox360 controller when they already have a fully capable controller does not make any sense. Did XNA leave out DirectInput or something I'd hate to drop back into MDX just because of this necessity. If MS has no answer for this, may I suggest that DirectInput should be included in XNA when the program detects its running on a PC Average Joe may not want to play the game ...Show All

• SQL Server How to create a SAPConnection in .Net Code with .NET Data Provider

  In the SQL Server Technical Article Micro s oft .NET Data Provider for mySAP Business Suite is a Code example of how to invoke a BAPI in .Net Code. First line shows how to create a Connection to SAP, but there is no information in which lib the SAPConnection type is stored: SAPConnection con = new SAPConnection ( "ASHOST=<SAPserver >; CLIENT=<client>;SYSNR=<sysnr>;USER=<user>;PASSWD= <password>;LANG=<logon language>" ); con.Open(); Does somebody can help me ...Show All

• Visual C# Assertion Failed error from MonitorDocumentsService during project load

  When loading a solution containing several projects (converted from VS2003) I get the following error message twice: Assertion Failed: Abort=Quit, Retry=Debug, Ignore=Continue  X at MonitorDocumentsService.OnBeforeDocumentWindowShow(UInt32 docCookie, Int32 fFirstShow, IVsWindowFrame pFrame) If I try to debug it just shows disassembly code and doesn't help. If I select Ignore, I can continue and things seem to be OK. Any ideas where to look Thanks! David Hi   I have similar problem for VS2005 projects, when I try to view the code for a design view. It happened after installing Windows Workflow Foundation and the problem still appears afte ...Show All

• Visual Basic Master-Detail User Input Form...

  Hi, I am quite new to VB in general. I am trying to build a database application using Access tables and create a user interface for it using VB2005. The first form I am strugeling with is the Input form that should allow the users to input invoice type records into the two tables, lets say, Invoices and Items. The form shouls use simple forms elements like TextBoxes, ComboBoxes, CheckBoxes and Buttons that will insert the records into the tables when pressed. Could any of you give me a best practice example that would allow me to acomplishe this (Since I am new to VB, I would prefere to do everything as "visual" as possible, I mean during design time.) Thanks a lot in advance, Regards, Gep. ...Show All

• Windows Forms Delete all the files while UnInstall

  Hi All I created a setup project for a windows application with lot more files with respective directories. The DLL files and other few files are not being deleted while doing uninstall/Remove from setup. How to remove these folders and files while doing uninstall/remove. Some time I thought we can call a batch file to remove all the directories and files but for this we need to know where our application is installed (e.g C:\Program Files\MyApplication ). It would be grateful if any helps.... Thanks Check the properties for each of the files you want to remove in the Setup project. Make sure the 'permenant' property is set to false. If it is set to true it will not be ...Show All

• Visual Basic DatetimePicker/Maxlegth Value Violation

  Help- new to VB2005 Having all kinds of problems - any help will be greatly Welcome- and thank for just taking the time to read this. Problem- I'm using a datetimepicker on my database when I go to save it, it works fine, if I don't change the date, once I change the date, the error I receive is "The value violates the Maxlength limit of this column." Is there something I'm missing here. Will I have the same problem If I add a combobox or listbox. So My question is, how do I reslove this problem. Thanks for the help, Wildwylie Basically what the guy above said...make sure your field length for the database is set to receive the number of characters being entered. Also, (I'm not sure how true it is because I never ...Show All

• Visual Basic Binary Fuctions & masked text box question

  is there any way of easily converting numbers eg. from decimal to binary fuctions or whatever also how can i send focus to a masked text box on load, i tried using MaskedTextBoxName .focus() but it didn't work, only seems to work on buttons. than after that how do i send focus of the text box from 1 to another like after it is filled, like 3 numbers, like those on programs typing the registration number. Just copy and paste my code. The code literally drops right in- all you have to do is change the name of the masked edit control to whatever your maksed edit control's name is. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help on some shader issues

  Well the real thing here is that I'm new to the programming pipeline so I kinda need some help on this. The thing is that I want to render primitives but with a custom texture format (CLUT, as in Color Look-Up Table, from the PSx anyone ). This textures instead of having a color have an index that goes to another 1D texture containing the actual color. Imagine this, you have a regular texture that has 4-bytes per color RGBA32, and each component instead of being the brightness level of that color is an index to a 256x1 texture containing the actual color. The problem relies in the fact that you have 4 colors in a "color" or fragment for that matter. But once you get to the pixel shader rendering part you can't 'spawn' new fragm ...Show All

• Visual C# Directory.Exists SUCKS!

  Alright so I am trying to detect if a directory named "C:\\A&B" exists and low and behold, Directory.Exists will not work. Why you ask Well, when I step through the code it changes the string's value to "C:\\AB". Apparently Microsoft thought it would be a good idea to just remove any abnormal characters. To work around this, I just get the directories last modified time and if it exists it returns something otherwise it throws and exception. How do I just discard this IOException to discard the IOException, use a try catch block:   try {    //your stuff } catch (IOException ex) {    //handle it }   however I am unable to reproduce the problem ...Show All

• Commerce Server Biztalk 2006 - New Receive Locations Error

  Hello: I've installed and configured Biztalk 2006 on a Windows 2003 server. SQL 2005 is on a remote machine. when I configure the Application ,I get this error: ************************************************************************************************************** Could not store transport type data for Primary Transport of Send Port '<name>' to config store. The specified transport handler has been deleted from the SSO store. The local, cached version of the Biztalk Server group configuration is out of date. You must refresh the Biztalk Server group configuration before making further changes ************************************************************************************************************** Any ideas or gues ...Show All