Vivek Ragunathan's Q&A profile

• SQL Server "fractional truncation" trying to insert time value into smalldatetime via SQL Native Client ODBC

  The following represents a change in behavior between the SQL Server ODBC driver and the SQL Native Client ODBC driver. I noticed a similar post about this issue, but the scenario below is slightly different. I'm trying to insert a SQL_C_TIME value into a smalldatetime column (SQL_TYPE_TIMESTAMP) via a parameterized insert. With the SQL Server driver, I receive the "fractional truncation" warning with a SQL_SUCCESS_WITH_INFO from the SQLExecute, but the value is still inserted into the table. With the SQL Native Client driver, I again get the "fractional truncation" and SQL_SUCCESS_WITH_INFO, but the value is NOT inserted into table. Here's how to reproduce in ODBC Test. Conn->Full Connect to either drive ...Show All

• Visual C++ Can you please help me

  Hi I am trying to pass a object by reference with pointer into a function and using a method in that object. By seem to me it doesn't work. The object i want to pass is Game and in Game have a function vector <char> getPuzzle (); I pass game into the function bool guess (Game* game){ //do something here vector <char> p = game->getPuzzle(); //do something here too } it will compile but when i run it it come back with the error message This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. Can you please tell me is that the correct way of using it What should i do to avoid this kind ...Show All

• Smart Device Development What is the root directory for the emulator?

  On my development machine I'm trying to make the following code read XML files using VS 2005, VB and the new Device Emulator and I keep getting the file cannot be found exception: Dim xmlStr As String Dim newDS As DataSet newDS = New DataSet() newDS.ReadXmlSchema( "Judges.xsd" ) newDS.ReadXml( "Judges.xml" ) xmlStr = newDS.GetXml() tbResults.Text = xmlStr Does anyone know what folder the emulator is using as it's root folder, or where I should put these files so the emulator can read them I tried using xmlStr = Path.GetFullPath("Test.txt") but all it returns is "\Test.txt" Any help would be greatly appreciated and thanks in advance. ...Show All

• SQL Server Union for two sets with where clause

  Hi, I have situation where I'm returning comparing data from two date ranges in a chart in MS Reporting Services. In regular SQL, I simply do a UNION between two select statements. I also have a dummy column returned to distinguish between the two selects. i.e. Select *, 1 As 'DataSet' from tblData Where startDate >= @sdate AND endDate <= @edate UNION ALL Select *, 2 As 'DataSet' from tblData Where startDate >= @sdate2 AND endDate <= @edate2 In MDX, I've only seen a UNION for the columns, but not with the WHERE clause included. Is it possible to have a where clause for each set What's the syntax Thanks a lot! Okay, what I did was set up aliases for charge amounts so that there would be t ...Show All

• Visual Studio Express Editions Cannot Find "Build a Program Now!"

  Hey, Ok, like I said, when I registered my Visual Basic Express Edition I downloaded P. Pellands "MS VB Express Ed. - Build A Program Now" - but I didn't get any of the sample codes. Is there anyway to get it Was it there to be downloaded and I just blew it Thanks! Code samples can be downloaded from here http://www.microsoft.com/mspress/companion/0-7356-2213-2/ ...Show All

• SQL Server Index on query with both where clause and order by

  What is best index for this query Select * from Table1 whete Table1.C1 >100 and Table1.C2=23 order by Table1.C3 How many index do I need and what column order I would appreciate if some body can put link to complex query index guideline Thanks for help. It's difficult to give an optimal answer without first gaining an understanding of the distribution and volume of your data. For instance if your table contains only one row then a full table scan will be the most efficient way of returning the results . If your table contains millions of rows, yet 99% of the rows satisfy the criteria (Table1.C1 > 100 AND Table1.C2 = 23) then a table scan is still likely to be the most effici ...Show All

• SQL Server Question about RS2k user logon window

  When I'm trying to logon the reporting service main page, the user logon dialogue box will ask you to input the authorized user id and password(It's the account created in windows system). But when I try to open certain report!on my reporting server, this logon dialogue box will be displayed again and I have to input the account and password again. All the reports can be directly opened after second entry. So my quesition is how to setup reporting service so that I can open all the reports directly just after the first entry.That will bother users to browse report!freely only after inputing authority information twice. PS: My platform is Windows 2K Server SP4 + SQL Server 2K SP4. edward ...Show All

• Visual C# How do i use wildchar in query?

  Hi, I have a problem with my sql query. I use: Microsoft SQL Server 2005 Visual Studio 2005 i have a database called Scan, and a table in the database called convert convert consist of 3 coloumns: id, product and barnumber. only one row: 1, 1111111111, 22222222222222 I have a dataset with the table, and when i use the query editor and query for %111% i get the result, but when i do the same from my program i get nothing! if i query for %111%1111% i get the result. the query goes for product which is a string. SQL query "GetDataByProduct" SELECT id, product, barnumber FROM dbo.[convert] WHERE (product LIKE @product) My Sourcecode dbDataSet . convertDataTable cdt = new dbDataSetTableAdapters. convertTableA ...Show All

• Visual Studio Express Editions Program produces different results on different computers

  Hi all, I wrote a program about six months ago and uploaded it to a site. What the program does is read a text file and puts the results into a database. Obviously the program works ok on my system & I know it works ok on other users systems but I've had 2 reports of the program not working as it should on other systems that are using the same OS as me ( windows XP service pack 2 ) . I told one user to download the latest visual basic runtime files which he did and still there is no difference, I also got him to send me his text file which I tried on my system & it worked ok. The visual basic file he downloaded is ; Visual_Basic_6.0_-VB6-_runtime_SP5.exe I'm no expert on VB, far from it but this sounds really strange ...Show All

• Visual Studio Express Editions Web Browser Help

  Hi, I'm trying to add alot of stuff to my web browser. I searched in google, but I didn't find anything. I tryed writting codes to see if I can get it, but I can't get it :( 1. Favorites 2. View Text Size 3. Web Browser site Name something like this (Visual Basic General - MSDN Forums - Mozilla Firefox) 4. History 5. Enter button when you type in the URL 6. Show the URl in the URL bar for every link. And I'll try to figure out the rest, because I have alot of stuff that I want to learn, but I think it's rude to ask for too much. Thanks. Thanks for all your help, I really appricated it. Now if only I can figure out how to open a new web browser windown when a popup pops up. If you know how to do it, then ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT Audio / Minor Rant

  <minor-rant> Can you please, *please* consider supporting a more low level way to play sounds than XACT. The Microsoft Cross Platform Audio Creation Tool (XACT) is a pain to use. I mean seriously how many devs do you have budget for to maintain this so called "IDE" It might be okay for professional game studios but I don't think it's that simple for the XNA GS crowd. Then again having looked in the XACT forum it doesn't look like a lot of professional studios are using it either. So then you have to ask why are we having it forced on us since this audio content creation tool has so far fallen on deaf ears ;). Perhaps it's a secret plot to get the XACT folk to make it better in future perhaps (hmm bite my tongue) A ...Show All

• SQL Server Mapping table problem

  HI guys I need to put multiple coniditions on my table based on some combinations. Here is my main table- Practitioner DHBName PHOName Practicename PractitionerName Locum YCount NCount 4 Canterbury DHB Partnership Health (Canterbury)-596721 Linwood Avenue Medical Centre Christine Abbasi No 0 1 32 Canterbury DHB Partnership Health (Canterbury)-596721 Felicia House Clinic (Pearson) Nicci Pavey No 0 1 197 Canterbury DHB Partnership Health (Canterbury)-596721 Woodham Road Health Care Peggy Shelton-Agar No 0 1 394 Hawkes Bay DHB Hawkes Bay PHO Limited-587862 The Doct ...Show All

• Visual Studio Express Editions Help Needed for my project

  Hi all I'm just starting out on this programing stuff,A friend send me a program in C# and I am having some trouble getting it to work when I open up the project is comes up with an error WIAfuncs.vcproj is not installed,could someone help me with this And it keeps saying that controlui.exe is missing when I try to start debugging thanks simon Hi Wipermotor, How did your friend send you this project, did it come complete with all the sub-folder and the solution file, or did they just send you the runable file Scott ...Show All

• Commerce Server Catalog Web Service currently unavailable

  Hi, I'm trying to update form Commerce Server 2002 to CS 2007. Now i think i'm pretty far but there are still some problems to solve. One is, that the CatalogWebService isn't available when I want to open ith with the CatalogManager. When i enter straightforward the link to the CatalogWebService.asmx in the Internet Explorer, the Site is loading correctly and shows my some information about the Web Service. What do I have to do so that the CatalogManager can open the WebService Hope you can help me. Thanks I think that im almost there where I wanted to be. Now i can open the Catalog Manager Properly as well as the Marketing Manager. The last problem i have is, that the OrdersWebSe ...Show All

• Visual Studio Team System Changing user while Connecting to Team Foundation Server using Visual Studio 2005

  Hi, I connected to Team Foundation Server usin Visual Studio 2005, with a user name and password. Now whenever I connect to Team Foundation Server, the Studio users that user name and password. I wan to connect using a different user name. How can I do so. I have tried cleaning the history from Internet Options, but it doesn't work. Please help. - Rajiv Rajiv, The client will use your authenticated windows account to connect to TFS. If you need to connect as another user - you can start visual studio with the alternate users credentials (right-click on the icon, run-as). Hope it helps ...Show All