Jonas.S's Q&A profile

• Visual FoxPro HTML Reoport Output Includes Vertical Scrollbar

  Using vfp9 report output to html. Finding that report field controls that are set to "stretch with overflow" include a vertical scrollbar (even though displaying entire contents of the field). Has anyone experienced this and/or found a way to eliminate the scrollbars ...Show All

• SQL Server Train mining model - more info

  hi, I newly Installed my SQL 2005.When I try to train my Model its giving me " Key not valid for use in specified state. " Can anyone help me how to figure it out Thanks, Karthik hi Ram, I am using BI Dev Stud to create my dataSource. In the datasource connection,The connection is like this "Provider=SQLOLEDB.1;Data Source=DBSERVER; Integrated Security=SSPI;Initial Catalog=CF2_0_1_Dev.". When i test connection it gets succeeded. In my DataSource View I am using a named Query Like "SELECT StudID,Date,Performance FROM Stud".When i Deploy after creating the dsv its working fine. the content types of the model is like this studid double key, date date key time. performance doubl ...Show All

• SQL Server Select all

  Hi, In my report i have a MultiValue parameter,I am sending those selected parameter value to database.What is the value it send to stored procedure when the user selects the 'Select All' from multivalued parameter. Thanks in advance There is no special "select all" value - this is just a UI concept. Therefore, all available values will be sent as a comma-separated list to the stored procedure. -- Robert ...Show All

• Visual Studio Can't debug on a network share with VS 2005?

  Dear all, I cannot debug my ASP.NET application remotely. I am receiving this error in my web application: Server Error in '/cv2' Application. Dear John, Appreciate your help. I don't think I am using http://remoteserver . I am accessing the folder on the web server files through a share drive on the XP computer, e.g. on the XP computer, I have mounted a drive called U: which leads me to the root of the public web server files. It just seemed quite intuitive to set it up in this way. I believe this would be what you refer to as 'filebased location'. As you say, this could actually be the major debugging block....Could you please give some pointer on how I could try to access the web site as http://remoteserver Side note: ...Show All

• SQL Server SQL server 2000: where are permissions, roles, accesses.... located

  SQL server 2000 If i want to access the permissions, accesses, roles... that a user or an NT domain group has on a specefic database, where do I get them from, in which table and what columns Let s say: I need to check for the user: myDomain/myUser or for the NT group: myDomian/myGroup all the accesses, permissions, roles...etc that the user or the group has on a specefic database called myDatabase. Where is that information located please Like all that stuff: read, right, create table, ...stored procedure...etc plus all the roles for the user. Please I don t want to miss any information that the user ot the group has on the database. Let me know if there are any other columns or types of security that I need to check, because I d ...Show All

• SQL Server Varchar declarations causing problems while using xp_sendmail

  hi, I am using xp_sendmail to semd e-mails. The content of the mail has to be populated with the output from a query. The whitespace in varchar field is not trimmed. As a result, the content in the mail has a lot of trailing whitespace with improper formatting. i tried using rtrim, ltrim, replace() etc to remove the whitespace. These things work fine when executing the query manually, but when i send the query string as a parameter(@query) to the xp_sendmail proc, the problem arises. Please suggest a solution to remove unwanted spaces. process the data to a required format before passing it to xp_sendmail process data to #temp then xp_sendmail the result from #temp ...Show All

• SQL Server Using oledb connection From connection manager in script task

  Is there anyone who tried to use a connection from connection manager to create a new connection in a script task Including the password Now i passed the connection to the script task and called it in the vb script but then the password is not passed into the connect string. Im searching for an example that works with passing the password in the connectstring Any help will be greatfull. Get any errors Chances are you'll have trouble if you're using the native OLEDB connection manager since it's a native object and not a managed connection manager. Try using the ADO.Net connection manager instead. I think that may be the problem. Without any errors or other information, it's just a guess. Kirk Haselden Author ...Show All

• .NET Development XML File Storage

  I have designed a Windows Form database and I currently store my data in memory. Now I am looking to store data from a windows form database into an XML file instead of memory. I will need to read and write data to this file and possibly delete it. I have checked around but i am not finding many clear answers. Can someone please help as this is driving me crazy !! Thanks If you are looking for storing a dataset or datatable into an XML file and you are using ADO.Net 2.0. You can use the functions of the mentioned classes. DataSet.ReadXml(filePath); Dataset.WriteXml (filePath); You can also look at the Walkthrough: Reading XML Data into a Dataset . edit: If you are storing much data think ab ...Show All

• Visual Studio Express Editions sign-up number

  Now that I have this number, just where do i register it Thank You for your suggestion, but am a novice and have no idea where to launch the product, click register, or paste. I normally don't dive 'into' my computor, not that confident. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problems auditioning transitions

  Hi, I'm working on some interactive music and I'm having issues auditioning my transitions. Here's what I have going: XACT 2.0 August release A cue named "MusicLevel1" that has IsInteractive set to true. A variable named "Intensity" that has a range of 1-100 A sound "drumloop-low" with two variations of a drum loop A sound "drumloop-high" with two more variations of a drum loop All of my samples are exactly the same length and tempo, and playwave properties inside of the sounds are looping infinitely. I have both drumloop sounds inside of my MusicLevel1 cue. drumloop-low has a range of 1-50 for the variable "intensity". drumloop-high has a range of 50-10 ...Show All

• Visual C++ Legacy MFC app using HWND_TOPMOST

  Hi All... We have a browser-based application that uses an active-X control to spawn off another process. This spawned process is written using MFC. It performs a call to SetWindowPos with HWND_TOPMOST specified - this is so the application will force itself to the top of the Z-Order. And (until now) it works fine... We've found however, that when that that active-X control lives in IE7, the app spawned does not force itself to the top of the Z-order. It gets above all other apps except for the IE7 from which it was spawned. Any ideas as to why IE7 refuses to allow the app to get above its Z-order Hello Re: Legacy MFC app using HWND_TOPMOST Such questions are outside the scope of this f ...Show All

• .NET Development Debug interfaces in real time

  I am thinking of using debugging interfaces to provide flexible diagnostic extensibility to an application running in production. This involves having application to instantiate the debugging interfaces internally and define some breakpoints that will be hit as the application executes (I read about separate debugger thread in 2.0). The code inside the breakpoint will then do some diagnostic activity and let the application go until the next breakpoint is hit. So this is kind of applicaiton debugging itself in its own process at certain points of its execution. Do you think using the debugging interfaces will even be feasible to produce something like this And that it will be stable and have little performance degradation compared to un ...Show All

• Windows Forms RowFilter Problem with DataView

  Hi,   I have two combo boxes allowing the user to filter data by selecting a date from one, and selecting a task type from another.   Now when the user selects a date out of the combo box it creates a RowFilter on the DataView using this date. This works fine.   Again when the user selects a task type from the combo box it again creates a RowFilter on the DataView using the selected type. Again this works fine.   The problem I have got at the moment is that it will only apply one filter either the date filter or the type filter.   Example:   User selects “Today” from the Date combo box. The DataView gets filtered by today’s date.   If the user then selects “Manu ...Show All

• Visual FoxPro Listbox causing error

  Hi I have a listbox in which I fill with values from a SQL based on a selection chosen by the user. The listbox allows the user to select the value they want from the list and enter payments for that person. However my problem occurs in instances where the list box contains more records that are shown in the main listbox window and the user has to scroll down the list. This is usually 500 or more records. When the user selects any of the records nearing the end of the list, the entire application closes with an error saying "Syntax error" and it is going straight to the read events. It however does not tell me where the syntax error is. For any of the records closer to the beginning, everything works fine. Help please. ...Show All

• Visual C++ how to get icon for an extension(e.g .xls)?

  thanks You can query the the keys under HKEY_CLASSES_ROOT and get the default icon for the extension.I know it's not clear please read the following article. it's easy to understand because it's calling system APIs from VB. This article will help you ...Show All