Kesava's Q&A profile

• SQL Server Data script task - how to generate multiple rows from one row ? (string splitter)

  Hi in input we have a set of rows, each one with a column containing a string (eg: "AAOOOOAAAOOA"). We'd like to split this string (using a vb.net data script task) into tokens (eg: "AA", then "OOOO","AAA","OO","A"), and to output one line per token. How can we achieve that with a vb.net data script task (Or anything else ) best regards Thibaut Hi Phil thanks for your input as well. Like Darren, I agree that a good rule of thumb is that a pipeline component will work generally faster than a corresponding script component. A script component is generally one-shot code, which generally doesn't get the same level of testing and optimization. In the a ...Show All

• SQL Server what's the error in ini file?

  I failed to install sql server express with ini file.Please tell me the error in ini file. Content of ini file: [Options] USERNAME=user1 COMPANYNAME=corp [ADDLOCAL] ADDLOCAL=All [INSTANCENAME] INSTANCENAME=dev [AUTOSTART] SQLAUTOSTART=1 [SECURITYMODE] SECURITYMODE=SQL [SAPWD] SAPWD=dr3dr233 [DISABLENETWORKPROTOCOLS] DISABLENETWORKPROTOCOLS=2 The command to execute install: setup.exe /setting setup.ini /qn Thanks. hi, first decompress the SQLEXPR.EXE via the /X parameter like c:\..\>SQLEXPR.EXE /X you'll be prompted for a path to decompress to... then, just try to modify the ini file as <setup.ini> [Options] USERNAME=user1 COMPANYNAME=corp ...Show All

• Community Chat 2007 Feels Like Heaven

  2007 Feels Like Heaven. I hear the party children give this year a name you spell with Letters. "Feels Like Heaven" Well, that's also a rhyme. Teach old people to replace the # symbol with numbers. Start with making the newest most modern method 1 next= I don't know anything about code sample. That's why I'm furnishing you this free information. I tried to figure it out for a while too. I think I found the answer ... ...Show All

• Visual Basic Raise Events from one exe to another exe

  Hi... My previous wasn't answered in the first place... Regarding on this issue... I was using a windows service on my current project.... And I would like to fire an event by the windows service, then my application would trigger that said event... Is it possible... Because... I don't wanna use timers on this issue... Regards, John Cuison I think it would get very ugly to try and use "events". But one possibility is using a file system watcher... i.e., your service creates a file, which your application is looking for... ...Show All

• Visual C++ convert string to double

  i have a problem i need to convert a string to double in c++ i used double xxx = atof (yyy ); but if yyy = 5 , 5 the returned value is 5.0000000000000 and if yyy = 5 . 5 the convert is ok and retur 5.500000000 how can i resolve this problem   Sarath. wrote: The function stops reading the input string at the first character that it cannot recognize as part of a number. That's happened here. but if yyy = 5,5  the returned value is 5.0000000000000 In the above case the output is correct. because the string contains a "," which is not used in numerical representation. Not exactly.  In many European countries 5.5 is written as 5,5   mido19 wrote: double x ...Show All

• SQL Server Error message running a SSIS package in a Job

  Hello, I'm having problems when I try to run a package from a job in SQL Server Agent. I have the same package in a server and it works fine,but when I try to install it in a different server I keep getting this error: Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 01:19:10 p.m. Progress: 2007-01-30 13:19:10.40 Source: Delete scripts Execute Process Task Operation Complete: 0% complete End Progress Error: 2007-01-30 13:19:10.57 Code: 0xC0029151 Source: Delete scripts Execute Process Task Description: In Executing "C:\Project_SSIS\Delete_Items.bat" "" at "", The process exit code was "1&quo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. c++ Express

  Hi All, I get an error when trying to install Microsoft Visual Studio 2005 Premier Partner Edition Installer . It tells me that I don't have VS2005 and cannot install. I thought this could be used with the Express editions Is this true I tired to install XNA without this but it would not work. Thank you, Paul Why doesn't XNA integrate with Express editions of Visual studio I think its a missed opportunity here. Lots of my students use the express edition (which is free) and now they still have to invest money to be able to develop games with a framework that is essentially free. Why not keep the costs down and integrate it with express ...Show All

• .NET Development Is IIS Contains an internal SMTP server?

  Hi every body, Is the Internet Information Service (IIS) contains an internal SMTP server No... you have to install the SMTP Service. Go to Add/Remove Programs, Windows Components, Internet and install it. If this is an internet facing server I would strongly recommend against installing it do to security reasons. ...Show All

• SQL Server sql connection

  I set up a user called "user1" on sqlexpress" I ran an app I wrote that connects to sqlexpress. From one machine I enter...("computername\sqlexpress"). I then enter user1 and password and the connection connections works fine to the server hosting sqlexpress, but on another machine, when I try to login the same whay I get an error "Login failed for user 'computername\Guest'". I can't understand why this is happening. I never set anything up as "Guest". I entered 'computername\sqlexpress' not computername\Guest". Any ideas out there as to what may going on. thanks I have the sqlexpress set as Mixed Mode and the connection string i'm using is ...Show All

• Visual Studio Where I can found the Hierarchy Chart for .net 2.0?

  Hi,everyone Where I can found the Class (namespace) Hierarchy Chart for .net 2.0 Just like the MFC Hierarchy Chart in MSDN2001 Is it available from microsoft or MSDN Can you give me a link Thank you very much!! Hello shanzy, I'm not a C++ fundy by any means, however these hyperlinks to Microsoft Visual C++ 2005 data may be of help: From within the MSDN May 2006 Document Explorer: ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_vclib/html/1f109428-4b84-4f7c-90a9-e71fe071311e.htm From a Microsoft Search on the internet: http://msdn2.microsoft.com/en-us/library/37f1f848.aspx Both links should take you to the same destination. Hope this is what you're looking for . Frank   ...Show All

• Software Development for Windows Vista Using smartcards in a service - SCardAccessStartedEvent

  Dear all, Migrating our core development platform to Windows Vista, one of our Windows services using smartcards is failing. We have debugged the problem and found that the event provided by the function ScardAccessStartedEvent does not receive notification. This event is supposed to signal when the SmartCard Resource Manager starts. As we have a WaitForSingleObject(event,INFINITE), the service hungs. Testing the same service as an ordinary executable ( registering with -regserver ) I can see it works properly. In XP it works properly both as an executable and service. I have read something about Service Hardening in Vista and I guess it may be caused by privilege reduction. So, I've created some code to enumerate the existing ...Show All

• SQL Server KPI Trend depending on last 4 months

  Hi! I've created a KPI. My problem is on the creation of the MDX trend expression. I'd like trend to depend on last 4 months. I wrote this query which works fine in SQL Server Management Studio : WITH MEMBER [APPEL].[Hierarchy].[My4Months] AS Aggregate( lastperiods(4,[APPEL].[Hierarchy].[ANNEE APPEL].&[2006].&[02]) ) SELECT [APPEL].[Hierarchy].[My4Months] ON COLUMNS, KPIValue("Pourcentage de respect") ON ROWS FROM [Amon] I'd like to obtain the same result in SSAS. So i created a calaculation nammed My4Months with the expression : Aggregate(lastperiods(4,[APPEL].[Hierarchy].CurrentMember)) ...and I entered as trend expression : CASE WHEN (KPIValue("Pourcentage de respect"),[APPEL].[H ...Show All

• Visual Studio Express Editions forms in forms

  what would i write to call a module or a proceduee from another module or procedure  if i had a sub yourname   in a classs mainprog  and yourrname  gives me two options via buttons, oe button is addname, what do i write in yourname to send the program to addname. i have tried addname() call addname() and i get constant errors surly there is a simply code to call a sub from a sub they are all set to public so that was not the answer.  to show the form you use the addname.show which will show the form, but i want to send the program to various places to do something.   Private Sub AddName() ...DoSomething End Sub Private Sub YourName( ...Show All

• Software Development for Windows Vista Different behaviour for sendto() in Vista Beta2

  I am working under a project in which we are testing sending of SNMP traps to different platforms like xp,2003,vista on 32 as well as 64 bit/IA64 machines. The trap is send using UDP sendto() system call. One of the test cases has ip-address of SNMP trap receiver which is not reachable and sendto() returns SOCKET_ERROR on every platform except Vista on 32, 64 and IA 64 machine. On vista we receive some proper value from sendto() system call and so the test case passes which should actually fail. Does vista has some modifications done as far as sendto() system call is concerned. Found the failure reason for our case. Windows Vista created an invalid ARP entry for the IP address that wa ...Show All

• SQL Server Native Exception Error - 0xc0000005 on SQL Server Mobile 2005 Repair

  Hi, I got this access violation as I do a Repair on an SQL Server 2005 mobile edition database. The exception occurs only on a specific type of corruption of my database. The Exception information : ExceptionCode: 0xc0000005 ExceptionAddress: 0x01669a48 Reading: 0x00000014 The log of the corruption is the following : Source : Storage Card\mydb.sdf Destination : \Storage Card\sql8000.tmp Repairing - verMajor: 3, verMinor: 0, verBuild: 5206, verPoint: 0 Time - 2007-17-01 16:31:55.000 Bad Checksum - idPage: 1031, tyPage: 3, iPage: 2 Bad Checksum - idPage: 3828, tyPage: 4, iPage: 1 Bad metadata - m_blobOwner Block page not found - pwszTable: __SysObjects, idPage: 205635 Block page not found - pwszTable: __SysObjects, i ...Show All