Seb.Net's Q&A profile

• .NET Development Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool

  Hi My application is working with a DataBase server which is connected through VPN. Some time i get an exception like... "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Inner Exception:>>" Can you please let me know if you have come across any such scenario in your application & any solution for it You need to do 2 things to fix the issue: 1) Increase the Connection Timeout. By default it is 30 seconds. You can assign your own value to it. 2) As other than timout you are also getting the error that "the The timeout period ela ...Show All

• SQL Server Replication problem in SQL Server 2000

  Hi all SQL Server experts! I have created replication on my two servers (production and backup servers). I used wizards to create it and then generated SQL script for deleting and creating replication. For another task I came across the command sp_removedbreplication 'dbname' and I tried to use that for removing replication more easily on the servers. It seemed to not remove everything on the production server and whenever I install replication now, either by using wizards or my generated SQL scripts I get an error icon (red circle with a black X in it) on my Replication Monitor all the way down to Publisher and the publication named with the computer name. Also this icon is on Agents and Log Reader Agents but not on the actual agent. ...Show All

• Visual Studio Express Editions Popups while coding

  So I am new Visual Studio, and am trying to learn vBasic. I can't seem to find a way to turn off the little guide tips. Whenever I start writing MessageBox.Show I get a popup. How do I turn off all of these "helpful" hints I looked in most of the options and can't find anything that seems to control them. I am pretty new to working with visual basic (just started a couple of days ago) so pretty much everything that I am writing is pretty simplistic and I know what I am doing with it...plus for the most part I am copying the book with a few small variations. But for the most part, I find it to be in the way. Maybe as I get more advanced in my coding, it will be more useful. That said, the last lan ...Show All

• SQL Server Hidden member causes Excel to throw error

  Hi, I have an AS2000 utility dimension that hold one calculated member and one 'dummy' member for the fact - dimension join. I use it in a virtual cube to achive currency conversion and I implemented the utility dimension to be able to use it with the aggregrate function that Excel uses on multiple filter selections. I want to prevent this dummy member to appear in my Excel pivot table. I have tried to use the setting 'Hide member if -No name' and it works great when I browse my cube in ASManager but when I browse it Excel 2007 I get a popup message saying something like 'member could not be found...' Any idea Thanks,Christer It has been some time since I have worked with AS2000 but I think th ...Show All

• SQL Server Incremental Update

  Good afternoon, I was wondering if someone could help. I'm busy researching into SSAS's capabilities, specifically Incremental Updates, however this would be the first time I'm working on SSAS, so I don't know where to begin. I've read through the BOL July 2006, and it explains that you have to enable this option; however to me it's not very clear. I followed the steps outlined in the Book; however when I go and update the source table, the partition does not update automatically. Could anyone please let me know if there is a website detailing how Incremental Updates work, and also how to set it up correctly Thanks Colin. Hi Colin. You will at least do an incremental update of your cube and dim ...Show All

• SQL Server Replication: periodic initial snapshot not yet available

  I have a push subscriprion (publisher sql2000, distributor 2005, subscriber sql2005) that periodically (twice per month) changes it's status to " ... initial snapshot not yet available ...". Then I need to mark it as for reinitialization and start the snapshot agent (starting the snapshot agent without marking it for reinitilization doesn't starts the subscription to initilize itself). There is nothing important in the logs. Any suggestion why this may happen The network connections between distributor and subscribers sometimes are broken (it's over VPN), but there is a couple of other replication that goes the same way and they are fine... Has anyone gotten anywhere with this one We're seeing the same issue with SQL 2k5 . ...Show All

• Windows Forms Context Menu Strip

  Hey, by the way my richtextbox is set up I can not set the contextmenustrip I want to use diectly on the control. I have to use the Form1_MouseClick event. So how would I make it so that it only does somthing if the mouse left button is pressed I tryed: private void Form1_MouseClick( object sender, MouseEventArgs e) { if ( MouseButtons .Left) { } } but that does not work... Thanks :) programes25 wrote: if I right clcik the textbox but if I right clcik just outside of the textbox it shows the messaged then the menu... It's exactly what I said. To fix it, you may put the "this.textBox1.ContextMenuStrip = this.contextMenuStrip1;" in the Form1_Load event handler, ...Show All

• SQL Server Probem in calling reports from ASP.Net page

  Hi, I am integrating RS2005 reports with asp.net page(VS 2005).the scenario is that i have created a home page with a button.when i clicked on button it redirect to another page which contain report viewer control.This control is linked with report server report.Although report is showing when i directly execute the page but when i execute the home page and clicked on button it gives messege " The permissions granted to user 'GGNHTEL866\ASPNET' are insufficient for performing this operation. (rsAccessDenied) " although i have given full control to ASPNET on app folder and report server. Pls suggest me. My answer for similar question http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1246011& ...Show All

• SQL Server sql server databse creation

  hi i dont know it is right forum to ask this question or not. had generated the sql script to create the databse.i had copied the query from there but i gives the static path of mdf files (in query), present on sql server folder without that it does not work. i m using this query to in ExecuteNoQuery method. problem is how to know that in which drive sql server is installed, and get folder location of installed sql server is installed or get the full path of installed sql server. or any other way to creat database through sql script. Actually if you don’t want to give any path information to the create database command, you can just to a: CREATE DATABASE Nameofthedatabase HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de ...Show All

• Community Chat Any language supports Counter?

  On a lot of occations, I want to use a counter like Counter(3). It ranges from 0 to 2. I can add any number to it. If I have 4 when it is 0, I get 1. It will be cooler if I can subtract 4 when it is 1, and I get 0. And, of course, I can define the Counter count at inistailzation stage. Is there any language supports this data type by nature I don't want to define the data type myself. Thanks. I don't know of any language which intrinsically supports this, but that doesn't mean one doesn't exist. You say you don't want to build this data type yourself -- any special reason why not Obviously if you're working in VB you don't have the option, but in C++ this should be a fairly trivial thing to implement, ...Show All

• .NET Development Synchronizing tables in Ms Access

  Hi fellows, I am working on a project which has to synchronize a table automatically. One db is in a remote server and one in the local machine. I am using Ms Access. I have come across with many articles which I had really had hard time understanding. I am not an expert on Ms Access. I am wondering if I can achieve this by writing a code in c#. Would it be possible to do the that Compare two tables and updates both tables with last modified changes (timing). This is being biggest road block for me to complete my project. Please someone help me on this. I do not have any administrator permission on the remote server to install any Add-ins. I really want to achieve this coding. Purpose is a console application will be running and updates b ...Show All

• Visual Studio Tools for Office making a .net call from new excel sheet, using task pane for user control.

  I have a VSTO Excel application (VSTO2005/Office 2003). This application has 5 sheets, but it creates new sheets during user actions. Is there a way to place any control at runtime into a new sheet so that a .net assembly method is called with the location of the cell or sheet where user clicked For example if I could place a special hyperlink into the new sheet which would call some function Class1.StaticFunc1(Range clickRange) it would be ideal. If there is another way to engage a .net method please let me know. Ultimately would be great to also show a custom user control in a task pane when user clicked that hyperlink or invoked it through a HostControl sheet (with design-time buttons). Is there already a way to place ...Show All

• Visual C# inner classes

  Hello, for many years of java I haven't appreciated the inner classes feature, and took it for granted. Now when I'm using c# I know how imporatnt it is. So I tought to ask what others are doing without it. In Java I had something like this: class A { protected String myString = "A"; class B { void myMethod() { myString = "B"; } } } this means that the inner class can access any method or data member (static and non static) of the outer class, and the pointer to the outer class is created without additions to the code. I want it in c#. Is there a way to do it Thanks well yes. that's how java works, and it is pretty goof because you can encapsulate the inner class fuctionality (methods, dat ...Show All

• Visual Studio Strange error when adding CrystalReportViewer control

  I have the latest July CTP installed. When I tried to drag and drop a CrystalReportViewer control to my form, I got the following error messagebox:   --------------------------- Microsoft Visual Studio --------------------------- Failed to create component 'CrystalReportViewer'.  The error message follows: 'System.TypeInitializationException: The type initializer for 'CrystalDecisions.ReportSource.ReportSourceFactory' threw an exception. ---> System.TypeInitializationException: The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception. ---> System.TypeInitializationException: The type initializer for 'CrystalDecisions.Shared.SharedSys' threw an exception. ---> System.Configuration.ConfigurationErr ...Show All

• Visual Basic daylight.start

  I need to get the start and end dates for daylight savings time throughout the world. I can use daylight.start and daylight.nd to get my local dates. From what I found out is that these routines use timezone.xxx which is normally timezone.local. Does anyone know how I can change timezone.local to a differant country within basic or another way I can get these dates Thanks Thanks for the reply, I am not familar with the cultralinfo, from what I read, it sounds like it should work. I tried : Private Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click System.Threading.Thread.CurrentThread.CurrentCulture = New System.Glob ...Show All