bjaroszek's Q&A profile

• SQL Server CogInStr function fails with MSAS 2005

  Hi, Following MDX query works with MSAS 2000 but fails with MSAS 2005: SELECT { FILTER([Product].AllMembers, CogInStr([Product].CurrentMember.Name,"*", 0) > 0) } ON AXIS(0) FROM [Sales] Following error is thrown: [ 1] Microsoft OLE DB Provider for Analysis S: Query (2, 32) The '[CogInStr]' function does not exist. Any pointers on what needs to be done in order to support this query in MSAS 2005 would be appreciated. Thanks and Regards, Santosh Thanks for your response. Yes, in AS2000 it was implemented as a UDF as shown below: command = USE LIBRARY "CogUdf.CogRExp" command = SELECT { FILTER([Product].AllMembers, CogInStr([Product].CurrentMember.Name,"*", 0) > 0) } ON AXIS(0) F ...Show All

• .NET Development SerialPort using RS485 that doesn't support DTR

  Hello, I need to know if there is any way to use the SerialPort component for an RS485 port without full modem support. I'm trying to use serial ports from a programmable serial interface card which does not support full modem signals (DTR, etc). Specifically, the .NET SerialPort component is throwing an IOException when it tries to set the DtrEnable property of the underlying SerialStream when SerialPort.Open is called saying that "The parameter is incorrect". After speaking with the vendor, full modem is not supported for any of the card's channels, so the card's driver returns an invalid parameter error when any of the control pins associated with full modem functionality are controlled. In the vendor's unmanag ...Show All

• Visual C# VS 2003 - Cannot check/uncheck Build checkbox with Configuration Manager

  I am trying to change the build status of a project which is part of my VS solution. However, the Build checkbox will not allow me to check or uncheck the build. None of the files is readonly and I cannot determine if this is due to some setting. I had earlier unchecked the particular project. Can anyone let me know what to do Thanks, Steve ...Show All

• SQL Server populate catalog Full Text Search SQL 2005

  Hi To All I'm trying to populate catalog in SQL 2005, but it doesn't work because in tables there are ntext fields. In SQL 2000 it works normally. I've made some test in both sql server. Why Is there something to set in sql 2005 Thanks Bye Is the problem that the catalog is not populating or you are getting an error when creating Can you post the script ...Show All

• Smart Device Development VS2005 and Smartphone 2003

  Is is possible to develope SP2003 application (C# 1.0 ) under VS2005 I can create the new project, and compile the defaulted windows form ( form1.cs). However, I can't add any item , even a button , on the window form, otherwise the windows form cannot be compiled. After adding any item, the windows form contains the follwoing code: this.mainMenu1 = new System.Windows.Forms.MainMenu( this.components ); this.SuspendLayout(); It's strange, well , they are the code in C# 2.0. So does anyone know what's wrong with my VS2005 Thanks for helping. Thanks Tumanov for helping. Are there really no buttons on SP When I use VS2003, I can add buttons on the window form, and compile it wi ...Show All

• .NET Development System.net.mail problem

    Hi everyone, I have a little problem using the system.net.mail namespace implemented in the following code: Private Sub Envio_Correo( ByVal ruta As String ) 'Creando la instancia del mensaje Dim correo As new MailMessage correo.From = New MailAddress( "b98123839@usmp.edu.pe" ) correo.To.Add( "amonasiq@usmp.edu.pe" ) correo.Subject = "Archivo de Confirmacion de matricula" correo.Body = "Se adjunto archivo de confirmacion de matricula de su respectiva facultad" correo.IsBodyHtml = False 'correo.Attachments.Add(New Attachment(ruta)) correo.Priority = MailPriority.Normal 'Crando la instancia del SMTP cliente Dim smtp As New SmtpClient smtp.Host = "134.5. ...Show All

• Visual Basic RaiseEvent Statement not notifiying event handlers when called from within New Sub

  Hello - The following issue involves code from MSDN which does not work properly. I have tried the code in VS 2005 SP1 and VS 2003. Here is the msdn link. http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbls7/html/vblrfVBSpec8_6_1.asp The problem is that the Constructed Event Handler does not fire when RaiseEvent Constructed is called from the Raiser Class's Sub New (See Following Code): Imports System Class Raiser Public Event Constructed(ByVal Count As Integer) Public Sub New() Static CreationCount As Integer = 0 CreationCount += 1 RaiseEvent Constructed(CreationCount) End Sub End Class Module Test Private WithEvents x As Raiser Private Sub Constructed(ByVal Count As Integer) Handles x.Co ...Show All

• Visual Basic Help with remoting

  Hi I'm having problems finding an easy description of remoting. Im not quite sure of what it even does. I want to have a program that can send and integer value to another program and i was told that remoting was the way to go. Here is what the application should do: In a network there are two computers. The program on computer A is a check in application and when a person checks in, it needs to to send an integer value to a different program on computer B. The program on computer B then uses this integer value to show a few things. Both programs know each others IP adress and both programs is being written in VB2005. Any ideas .NET Remoting Article This should explain things a little ...Show All

• .NET Development reflector tool in .Net

  hi, when i try to open a system dll "sfc.dll" in the reflector tool, then it does not get opened in the reflector. it shows an error "sfc.dll does not contain a CLI header" can anybody tell the cause for this and resolve the issue regards, divya Divya, If this is sfc.dll installed in %systemroot%\system32\ this is a native-code module used in the system file protection facilities the OS provides. The reason you're getting that error is because this is not a managed assembly. Reflector operates on the MetaData present in managed assemblies, which native modules do not contain. Are you having a particular problem with sfc.dll that you're trying to investigate If ...Show All

• Smart Device Development How to create cab installer

  Dear all: I want to create a desktop installer(.EXE) to install in my pocket pc the three cabs required to install SQL Server Everywhere. I'm using WM5 in my Pocket. Can you help me Thanks. Alfredo Mendiola Loyola Lima Peru Hi, You can use NSIS to create installs for multi-cab project (it's free) or there are several other not so free installers to make your installs like ePocketSetup which is the one we use. Hope this helps ...Show All

• Visual Studio Team System Can't launch word document from Source Control Explorer

  I cannot view word documents from the Source Control Explorer using a double click or View command. The cursor briefly changes to busy and then resets to the default. Txt documents and .cs documents work fine. Hi Mario, I don't get any error messages. The cursor changes briefly to busy and then back to normal. The file launches fine from Windows Explorer, so I think the file association is fine. I tried an .xls file and it has the same problem. This seems to occur with files that require an external viewer. For example, .txt and .htm files open within Visual Studio in their own tab without errors. There are no errors in the event log and I'm not sure where else to look. Yes, this is very ...Show All

• Smart Device Development inplement edit box popup cut-copy-paste menu?

  In most PPC applications I've seen if you hold down the pointer on an edit box a menu with cut, copy, and paste appears. That's not happening in my app, I get the circle of dots around my pointer but nothng happens. How can I get this menu to appear Hi, The SHRecognizeGesture that you are using is the MFC wrapper defined in the CWnd class, so essentially the message passing etc done by this method shall be the same as the WM WinCE API call that I pointed out. Thanks. ...Show All

• Visual Studio Branch project from batch command line or vbscript ole automation

  Is there anyway that I could branch project using batch command line or vbscript ole automation I search command line reference, but I can't not find parameter for branch source and branch target. Please help. Thanks I want to clarify what you mean when you say "I want to branch $/trunk/project01 to $/projects/01". Are you saying that you already shared $/trunk/project01 to $/projects/01 and now you want to branch it If that is the case then something like this should work: ss cp $/projects/01 ss branch *.* -Luke ...Show All

• SQL Server Authentication

  hey all Not sure if I have this in the right forum - please direct me otherwise people. This is my set-up Windows Server 2003 (NZDEV) Virtual Server (nzvmw1) - Visual Studio 2005 Sql Server Express Edition with Advanced Services Tools = Reporting Services on my computer - I have deployed a report up to the nzvmw1 server using url nzvmw1/reports - I can see everything my user nzdev/user (admin rights) I have two other users - they are users on nzdev (not with admin rights) if they use url nzvmw1/reports - the password screen comes up nzdev/***** and password I set for them - page comes up but no folders I don't know where else to give them permissions (and don't think I should be making everyone Admins ...Show All

• SQL Server data reader source in data flow problem

  hi all, i have a package in ssis that needs to deliver data from outside servers with odbc connection. i have desined the package with dataflow object that includes inside a datareader source. the data reader source connect via ado.net odbc connection to the ouside servers and makes a query like: select * from x where y= and then i pass the data to my sql server. my question is like the following: how do i config the datasource reader or the dataflow so it will recognize an input value to my above query i.e for example: select * from x where y=5 (5 is a global variable that i have inside the package). i did not see anywhere where can i do it. please help, tomer Like I said, the Datareader S ...Show All