CO22006's Q&A profile

• Visual Studio Express Editions Database Connection

  Hi, I am making an application that needs to connect to an sql database, using the database connection wizard, on a remote server. When i type in the path of the database it comes up with a message saying "Attempted to access a path that is not on the disk". How would i connect to this database I am putting in the database file name the path of it http://the path of the database/database.mdf . I am leaving the server login fields blank. Please note that i am not using code to do the connection, i am using the database connection wizard. The database is stored on a remote server (I canot change any server settings.) ...Show All

• Windows Forms Whidbey DataGridView Scroll control info using GetScrollBarInfo fails

  Hi, I used GetScrollBarInfo WinaPI method to get the DataGrid's HScrollBar/VScrollBar Thumb position and other details and this returns perfect result in this case, but the same function when I tried to get the DataGridView's Scrollbar details it returns me false and doesn't populate the ThumbBottom,ThumbTop,rcScrollBar rectangle information. Does anyone know why it doesn't work and how can I get the ScrollBarInfo for the DataGridView control Is there any way that I can get the Thumb information without going thru InterOp Thanks, Nitin Sharma Getting ScrollBarInfo fails for other controls too if EnableVisualStyles is true. Can anyone from Microsoft provides info on if there is any plan gto fix this issue Or else ...Show All

• SQL Server Users in RS2005

  How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005. u can set security by connecting to RS from SSMS. right click report folder or report itself and click Properties. Under Select a page, select Permissions. from Report Manager, click at Show Details at the right hand side of the page. Click Edit next to the report folder or report. there's a security link at the left hand side. hth ...Show All

• Windows Live Developer Forums Polygon Layer

  How can I create custom polygon layer (e.g. ZIP, Census Tract etc.) in VE Can I fill the polygon with different color to produce thematic map Well, let's see: First, this page is just put up to give you ideas of how to import GPX files into your own mashup. You can easily alter it (for your questions like "can I use another GPX format, can I change the colors", etc). Now, here are some more specifics: The HTM page is calling an aspx page. The aspx page simply iterates through the specified GPX (xml) file and generates VEPolygons or VEPolylines. It returns the formatted javascript, and the HTM page just calls eval() on the returned information. I'll make the aspx code available later t ...Show All

• Visual Studio Express Editions Reading 2 lines from a file

  Hi all! It's me (again). I feel really frustrated, because I know that I'm so near to achieving my goal, and yet it seems so far! Problem: I have a text file with 2 lines (it will always be the same): - Line 1 defines the name of the "Plugin" - Line 2 defines the executable path of the "Plugin" A directory (sampledir1) contains an amount of files structured like this. Is there a way to add the names of these "Plugins" to a listbox, but also assign a value to that item, so that when the item is selected, the plugin will launch. Please don't get mad at me for asking so many questions - I'm still a newbie... Thanks! Johannes ListBox.SelectedItem is not a String, so trying to compare it to a String will ...Show All

• .NET Development Network Trace - tracemode and maxdatasize

  Hello, In my application i'm using System.Net.Mail for send mail. I need to log smtp server response so i have enabled trace log, reading instructions in this article: http://msdn2.microsoft.com/en-us/library/ty48b824.aspx (How to: Configure Network Tracing). In the log i want to remove traces in hexadecimal using the tracemode attribute on the switches element setting it to: protocolonly. Unfortunately when i put the tracemode attribute in my xml, Visual Studio 2005 says that it's not declared. I have the same error setting maxdatasize attribute on source element. Can you help me ps. Sorry for my bad english Regards, Fabio. ...Show All

• Visual Studio Toolbox icons defaulting to one icon in 2005

  I have one instance of Visual Studio 2005, long time existing, where most of the icons found in the Toolbox for winform development have taken on one icon instead of the unique icons. It occurs from the button icon to the StatusStrip; which all have the same icon. Is there a way to reset them I hope you haven't done your reset yet - There is indeed a way to reset the Toolbox area ONLY. To do this, right-click anywhere in the toolbox and select "Reset Toolbox." It will remove all your custom controls (which for me isn't a problem because those references tend to move around alot anyway) and it will repair all the tool item icons. ...Show All

• SQL Server Presentation Layer for Analysis Services

  Hi, I have just set up my OLAP. However, I dunno in particular how i can create a client presentation layer for them to access it with drill down, rollup etc. functionalities. CAn you suggest something simple to configure for the presentation layer Thanks. cherrie Do you want to create an own client application for SSAS Do you have an experience in writing front-ends with access to relational datasorces Take a look on ADOMD.NET ...Show All

• Visual Studio Express Editions MFC IN ViSUAL C++ 2005

  Hi all gurus, I am new in this forum learning vc++ 2005 . when I am starting new project I haven’t got option to make MFC console application. Any body who can help on this I am requesting them to help me on this I will highly appreciate on it. Should I have to download anything or should I have to make any setting .. I would like to hear your suggestion .. Thanks in Advance.. Jonathan Caves - MSFT wrote: You can't download a version that supports MFC - you need to purchase at least the Standard edition. While deciding whether and how to purchase the Standard edition, there is also a 90-day trial download of Visual Studio 2005 Professional . It is a bit large (2.6 GB) and I don't know that i ...Show All

• SQL Server store data into temp array

  How can you loop over a data reader and save the current row to a temp array of some sort and return this array back to the caller SqlDecimal total = 0; SqlConnection conn = new SqlConnection("Context Connection=true"); SqlCommand cmd = new SqlCommand(@"SELECT column1, column2, column3 FROM table ", conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (rdr.GetSqlString(1) == "01") { // ADD the current record to a temp list total = total + rdr.GetSqlDecimal(2); } } SqlContext.Pipe.Send(total.ToString()); // RETURN the temp list rdr.Close(); conn.Close(); Hi! Let me clarify: you are writing a CLR stored procedure that has to run ...Show All

• SQL Server Association Rules algorithm [support,confidence]

  In assotiation rules each rule has a [support, confidence] part. In Microsoft Association Rules there is a [probability,importance] measure in each rule and importance can be greater that 1. I found the following in msdn but i'm not sure if i understood correctly. MINIMUM_PROBABILITY: Specifies the minimum probability that a rule is true. For example, setting this value to 0.5 specifies that no rule with less than fifty percent probability is generated. The default is 0.4. MAXIMUM_SUPPORT: Specifies the maximum number of cases in which an itemset can have support. If this value is less than 1, the value represents a percentage of the total cases. Values greater than 1 represent the absolute number of cases that can contain the items ...Show All

• SQL Server Local Report +Sub Report +Parameters

  Ok, I have been struggling with getting a report to run that I can pass parameters to for two days now, I have finally made progress on that front from going to local processing vs remote processing. Now though I am about to pitch my computer underneath a truck if I don't get this solved shortly. I have two subreports as a part of this report. They are supposed to be passed the id value as a parameter from the parent report. I found out that I still have to set data sources for these sub reports, so I attached the subreportprocessing event to the report viewer and attached the datasources that I created. My problem, I assume, is I don't understand how the dataset is supposed to be defined. I have tried three different ways. I built one ...Show All

• Visual Studio 2008 (Pre-release) exception connecting to self hosted singletone server: An existing connection was forcibly closed by the remote host

  (moving the thread to WCF and making an attempt at investigation) hadas1, Do you have firewall enabled or anything else that might get in the way The code that you have seems pretty vanilla to me to have an issue in WCF. Also if you have modified the service re-generating the client could help. ...Show All

• SQL Server Replication between SQL Server 2000 and SQL Server 2005

  Do you know if it is possible to synchronize a database in SQL Server 2000 SP3a (Publisher) and a database in SQL Server 2005 (Subscriber) Has anyone tried it What are the most common problems you faced Are there many differences from the Replication process from SQL Server 2000 (publisher) to SQL Server 2000 (subscriber) Thanks Very Much Not sure if this is the issue you hit: Make sure to use SQL 2005 Management studio to create publication and add subscription for SQL 2000 publisher, you can not connect to SQL 2005 from SQL 2000 Enterprise manager thus will not be able to add SQL 2005 subscription from SQL 2000 enterprise manager. Or you can TSQL script to setup replication programmatically. Thanks, Zhiqia ...Show All

• SQL Server Starting SQL job from a Bat file

  I have the need to start the execution of an existing SQL Server 2005 Agent job from a bat file. The job has dependencies that are impossible to predict, but the dependent environment does have the ability to run bat files from the command line environment. I'm hoping there is a way to write a command line that starts an existing SQL job on the local server. Any ideas Mmm... Using a batch file you can to execute a T-SQL query to start the job, using the osql.exe utility: osql -E -Q "msdb.dbo.sp_start_job N' MyJob '" But i prefers to use the good scripting approach. Then you have a best control. Save this script as a .vbs file, and execute it: Dim oJob, oServer ' Creates the S ...Show All