svend67's Q&A profile

• SQL Server To find all pairs in table that fits to given criteria.

  Task: To find all pairs in table that fits to given criteria. For example: I have a table with id's and weight of people. The task is to find all pairs of people (id's) that their weight in range of 0-5 kg. The result need to be without repetitions of data. id  weight 1   80 2   84 3   81 4   90 So results should be: 1 2 (or 2 1) 2 3 (or 3 2) 1 3 (or 1 3) but not both I'm using MS SQL Server 2000. Question: How to do it in SQL Thank you very much. I run query on the large( ) table (60000 rows) and as result I get strange output. This is a reson why I asked the prev. question.& ...Show All

• SQL Server Report builder functions

  Hi, Does anybody knows a good tutorial or link that handles all the functions of the report builder thanks Do you mean "functions" that can be used in a Report Builder formula, or do you mean general Report Builder "functionality" ...Show All

• SQL Server Building OLAP Cubes

  Hi, In spite of my bad english, i hope you'll understand my question =) I've to build an olap data cube which contains 3 data table... But i couldnt find any document about it. I've heard Adodb, Adomd and Mdx concepts but i have no idea about tehem, i ll be grateful if you help me... I have a similiar problem which i hope someone can help me with. What i would like to know is how to create a Cube from a programming perspective (not using the various wizards provided) For a relational database, i create a connection to the database and then execute SQL commands on it using the SqlCommand ...Show All

• Visual C++ Control Bracket Formatting

  I'm sure this has been asked numerous times, but it is a hard thing to search for.  Anyways, I am using Visual C++ 2005 Express Edition and it writes code like this: if () {    statement; }   I want it to write code like this: if () {    statement; }   How do I do this   Thanks a bunch. According to my knowledge, I don't believe there is a current way of doing that. Please feel free to log a suggestion issue at: http://lab.msdn.microsoft.com/productfeedback/default.aspx Thanks in advance in taking the time to log your suggestion! Thanks, &nbs ...Show All

• SQL Server AMO DataSource ConnectionString Password and ConnectionStringSecurity

  I am creating a datasource using AMO with the password embedded in the connectionstring to the database. After the datasource has been updated to the server, if I load it again, the password is removed from the connectionstring. I tried setting the ConnectionStringSecurity to "Unchanged" but it's reset back to "RemovePassword" when I load the datasource object again. Any ideas on how to avoid entering the password everytime This is not a bug in the product. You are running into the situation when Analysis Server for security reasons strips any passwords from any responcse it sends to the ...Show All

• Visual Studio Tools for Office Is connected to exchange

  How can I check whether Outlook is connected to exchange Hi Hojgaard, If you have not resolved the issue you can post the question on the office.developer.automation newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation Lubo ...Show All

• SQL Server Getting #Error details from deployed report

  I have a report that displays #Error for some field values when deployed on the server. Is there any way to get details on the error Thanks. Most likely the #Error comes from making a call into a custom assembly and insufficient security permissions for that custom assembly to be invoked. You can partially simulate the server environment, if you run the report in the stand-alone preview of report designer. I.e. instead of clicking on the Preview tab, hit F5 which should open a new window for the stand-alone preview. For the #Error you should get warning messages with more details in the output window. ...Show All

• SQL Server SQL Servers Communicating Across a DMZ

  In a proposed architecture, a production SQL Server will live in the DMZ, and an additional internal Production server will reside on the internal network. If Port 1433 is opened on the firewall and access to the DMZ SQL is restricted to only the internal SQL server, is this secure I've been told two stories: 1) That if port 1433 is opened, that a hacker can enter the DMZ and then browse ANY SQL Server on the internal network, not just the internal SQL server mentioned in the proposed architecture above. 2) If you define a rule on the firewall and you use a trusted connection, then ONLY those two SQL servers can communicate with each other ...Show All

• Smart Device Development enable emulator in vs 2005 connect to active sync

  hi , how to i enable my emulator connect to the active sync You can use Device Emulator Manager for the purpose. 1. In activesync File->Connection Settings-> "Allow Connections to one of the following"->select DMA from combo-box. 2. In VS2005, Tools->Device Emulator Manager. 3. Right click on appropriate emulator and connect and cradle. -Thanks, Mohit ...Show All

• Windows Forms Research on Terrarium...Please Help me ASAP!

  Hello to all the developers here! My name is Logas ... I am a student in Malaysia doing my Final Year Project for my Degree.. Well basically my research is on Terrarium....indepth research. but i am stuck .... so here i am looking for help! basically i understand what terrarium is all about and i am impressed that initiative is taken to simulate and prove t ...Show All

• Visual Studio 2008 (Pre-release) Waiting for a process exit to restore window state

  I have a simple WPF app with a Button on a Grid. I want the button to launch an app, minimize the WPF app, wait for the other app to go away, and then restore the WPF app. I thought this might work in the button click handler: System.Diagnostics. Process proc = new System.Diagnostics. Process (); proc.EnableRaisingEvents = true ; proc.StartInfo.FileName = "notepad.exe" ; //proc.Exited += new EventHandler(proc_Exited); System.Windows. Application thisApp = System.Windows. Application .Current; Window myAppWnd = thisApp.MainWindow; myAppWnd.WindowState = WindowState .Minimized; proc.Exited += ...Show All

• Windows Forms IDesignerHost Blocks Mouse Events

  Dear all, I'm in the middle of implementing a development toolkit. In order to enable users to design interfaces (forms), a form is shown in design-mode by using an IDesignerHost object. It is very powerful and reliable as I can make use of other design-time services like toolbox, properties, selection services, and others. I need to show mouse coordinates while  ...Show All

• SQL Server SSIS from VB 6.0 or VB .Net...

  Dear all, How do I to launch a SSIS package from either VB 6.0 or VB .Net languages Anyone told me that from SMO library you can launch but I haven't idea how would I do too.. Thanks in advance for any input or though, Enric Lookup " Loading and Running Packages Programmatically " in Books Online ( http://msdn2.microsoft.com/en-us/library/ms345155.aspx ). You use the Microsoft.SqlServer.Dts.Runtime namespace not SMO. This will certainly work from VB.Net, and in theory it should work from VB6 if there is a PIA (don't know that there is), or just create your own CCW. Never tried, so it may not work, there are some r ...Show All

• Windows Forms Accessing PDF file properties in code

  I am trying to use access the properties of adobe acrobat PDF files.  I am able to edit or add information into MS application properties windows from code using the Built-in properties collection.  For my pdf files in question I can view and change the Title, subject and author by right clicking on the PDF file and then selecting properties. I wish do do this programatically.  Any suggestions There are a few different libraries or working with PDF files.  A list of them can be found at: http://www.windowsforms.net/ControlGallery/default.aspx Category=16&tabindex=12 - mike ...Show All

• Windows Forms How to create ActiveX control having GDI+ capabilities?

  i want to make a web application in .net,where i can draw some circles or rectangles and to change their colors and size...actually i want this application to run on client(i.e through ActiveX control or Like Applet). i found a simple activeX control which doesnt fulfil me requirments.. need urgent help.... ...Show All