furmangg's Q&A profile

• SQL Server Stopping job after timeframe

  Is there a way to stop a scheduled job after a particular amount of time has passed I have jobs in which the running SSIS packages wait for a file to appear in a particular folder. As is, the job will wait all day. What I want is the job to fail if after say 5 hours, the file never appears. (Plus for the next day I need to package to "reset" itself with the current date.) That is exactly what you do. Yes, it is a hack. In most places that I work with that have larger numbers of servers, we don't use SQL Server Agent at all and instead purchase 3rd party software to handle all of our jobs. Of course, the 3rd party software handles scheduled tasks for DB2, Oracle, Windows, Unix, and several other sy ...Show All

• SQL Server Problems importing access reports

  I am trying to import my access reports into Reporting services and it doesn't seem to be working.. i am getting this message in my OutPut box in VS 2003 " Error : An error occurred while the report [REPORT NAME] was being imported: The server threw an exception. " it ended up not importing even one report out of over 100+ reports!! just wondering what could be the problem and how could i fix it Current actions already taken: "updated reporting services to SP4", "updated SQL server to SQL Server 2000 3a", and "lastly i am downloading the SP1 for VS 2003 and will install it" Just wondering if someone else had already ran into this problem and cause help me out.. ...Show All

• .NET Development accessing AppDomain of web application ASP .Net

  can we access the AppDomain of a web application in ASP .Net The purpose is to sneak into a web application. I have a web application installed on my machine. there is a desktop application as well with a windows form having a button. Suppose a user logs into the web application. CAN I ACCESS THE USER SESSION ID ON THE CLICK EVENT OF THE BUTTON IN THE DESKTOP APPLICATION plz reply with some code sample if possible. Ravi In the circumstance you are giving I don't believe it is possible. It'd be a huge security hole if you could. Of course cross appdomain communication is possible but in this case you are trying to access an appdomain (or domains) that you didn't create. As they are runn ...Show All

• Visual Studio Express Editions TabControl Help...

  Hi everyone, some of you have helped me with opening a new form NewEvent neform = new NewEvent(); neform.Show(); which i understand just fine but i was wondering how do i open up and new form with the tab control on it, and make it so that when it open it will open straight to that tab instead of click on the tab for example say you have 2 tabs "tab1=Meeting, tab2= Things to do". and then you go to File>New>Meeting or File>New>Things to do, and it will go straight to that tab, also while im here is it possible to open a file for example "Help>How To..." and it will open a pdf file ( HowTo.pdf ) just wondering so it will save me having to ask another question. thanks for anyhelp ...Show All

• Visual Studio Express Editions MS access content change notification

  Hi, How can I know if the access content is changed so that the content is update thank you when there are more than 2 users accessing the database, if one user change the content of the database, a notification is required to inform the other users and the content will be updated. ...Show All

• SQL Server Error Processingn Cube with time dimension

  The strange thing is that- i create two cubes with same data source using the same fact table and the same dimension in both cases. However with the first one i dont define the dimension as a time dimension and the cube processes fine. With the second cube i do define the dimension as a time dimension and then the cube processing errors. The error say attribute key cannnot be found But it was found in the first cube Anyone know what might be causing this Thanks, This is not a good practice to have a nullable key. Although Analysis Services allows you to map null keys to Unknown member in the dimension, it is not a good idea. To solve this problem try define a named calculation in yo ...Show All

• SQL Server Between + '%'

  helloo I have this table Id Code -- -------- 1 10101001 2 10101002 3 10102001 4 10102002 5 60101001 6 60101002 7 60102001 8 60102002 9 60201001 10 60201002 11 70101001 12 70101002 I need to query this table by the following (select id, code from table1 where code between '1' + '%' and '7' +'%') to get all values of codes between (code starting with 1) and (code starting with 7) or for example: (select id, code from table1 where code between '602' + '%' and '7' +'%') ------------------------------------------------------------------------- Im not getting correct answers or let be specific in the second query im not getting codes starting with 7, im only getting codes >= 602 but less that 7, so 7 is not incl ...Show All

• Visual C# Running Service Memory Increasing...

  Hi all, I have created a service that polls a usb device every ~10secs and stores data to a small-ish database (around 10k or 15k records) with every poll. Seems to be running OK, but the Windows Task Manager > Processes tab shows that it is using continuously more and more memory. As I write this, Mem Usage is at 24,516 k and slowly growing. This seems strange to me as it is not a very complex service, does this look like a GC problem I'm very new to coding with database manipulation methods, so I set up a simple access database and have been using table adapters to do all my data transactions. It seems to me there may be an inherent problem in the way I'm doing this, as I have to use the tableadapter.Fill(datatable) method each ...Show All

• Visual Studio Express Editions CType Trouble

  I am trying to make a small amount of code save me from having to manually write everything out. What I have is this so far Dim Box As CheckBox = CType (sender, CheckBox) Dim W As Integer = 1 For W = 1 To W = 7 If CType ( Me .Controls( "rC" & Box.Name.Substring(W)), CheckBox).Checked = True Then CType ( Me .Controls( "rW" & Box.Name.Substring(W)), CheckBox).Checked = False ElseIf CType ( Me .Controls( "rW" & Box.Name.Substring(W)), CheckBox).Checked = True Then CType ( Me .Controls( "rC" & Box.Name.Substring(W)), CheckBox).Checked = False End If Next W I want it to check if rW1 is checked, and if it ...Show All

• Visual Studio 2008 (Pre-release) Calling "transactional web services" within a series of database update calls - is Indigo the only way?

  SCENARIO Suppose I call the following method in a ServicedComponent: public void DoMixedUpdates() {     DoDBUpdateA();     DoDBUpdateB();     CallWebService1ToDoDBUpdateC();     CallWebService2ToDoDBUpdateD();     DoDBUpdateE();     DoDBUpdateF(); } All 6 calls perform DB updates but the middle 2 calls call "plain old" ASMX web services that each then call a component that performs DB update C and DB update D. QUESTION On the current shipping versions of Windows Server 2003, does a) .NET 2.0 with WSE 3.0 or b) .NET 2.0 without WSE 3.0 support the "transactional web service" scenari ...Show All

• Windows Forms Transfering info with Class file

  I have 2 forms Form1.h URL.h I am trying to take the information from "txtURL" on "URL.h" and place it into "wmp->URL" on "Form1.h" i was told i have to use a Class file as information cannot be transfered from Form to Form. So i made a class file "URLC.h" the code in it is //////////////// #pragma once #include "Form1.h" #include "URL.h" namespace M12; ref class URLC { public: URLC(void); int URL; }; \\\\\\\\\\\\\\\ Note: the \\\\\ and ///// are not part of the code, its to show start to finish. i was told that you decalse strings with "int stringname;" so i use int URL; How can i place the info into URLC and then have Form1.h read it when URL.h is clo ...Show All

• SQL Server ERROR: The nested query may be missing an ORDER BY clause.

  Hi, on executing the below query i am getting the following error ERROR: Errors in the back-end database access module. Nested table keys in a SHAPE query must be sorted in the same order as the parent table. The nested query may be missing an ORDER BY clause. even though the order by clause is presenet in the nested query SELECT t.[ProductId], Predict ([Association].[Product Basket],3) From [Association] PREDICTION JOIN SHAPE { OPENQUERY([Adventure Works Cycle MSCRM], 'SELECT DISTINCT [ProductId] FROM (SELECT ProductId FROM ProductBase) as [Product] ORDER BY [ProductId]')} APPEND ({OPENQUERY([Adventure Works Cycle MSCRM], 'SELECT [ProductId] FROM (SELECT ProductId FROM ProductBase) as [Product] ORDER BY [ProductId]')} RELATE ...Show All

• Visual C# HOW TO: Spilt Text File After Specified Line

  Hi All, How can I split a big text file (e.g. 4525 lines of data) into pieces of smaller text file after a specified number of lines (e.g. it will gives us 10 smaller file if the smaller file has maximum 500 lines of data; the last piece will have only remainder 25 lines of data.) Thanks in advance. Hi Leonard, I think the following piece of code does what you want (tested): using (System.IO. StreamReader sr = new System.IO. StreamReader ( @"c:\test.txt" )) { int lineCount = 0; int fileCount = 0; System.IO. StreamWriter sw = null ; string line = null ; do { //every 500th line, create a new Streamwrite ...Show All

• Visual C# Font Dialog with color

  Hi i have the code for diplaying Font Dialog with color but it does not show the color, Only the fonts. Can anyone help This is the code: private void fontsToolStripMenuItem_Click( object sender, EventArgs e) { FontDialog fontDialog1 = new FontDialog (); try { if (fontDialog1.ShowDialog() != DialogResult .Cancel) { fontDialog1.ShowColor = true ; fontDialog1.Color = richTextBoxPrintCtrl1.ForeColor; richTextBoxPrintCtrl1.SelectionFont = fontDialog1.Font; richTextBoxPrintCtrl1.ForeColor = fontDialog1.Color; } } catch ( Exception exp) { System. Console .WriteLine(exp.Message.ToString()); } } Hi, looks like you're setting the dialo ...Show All

• Visual Studio 2008 (Pre-release) tried making a new service with 1 method that simply calls and gets a string from the sql database

  Hosted in IIS right now, directory security is set to anonymous and everything else is unchecked. My service methods all have impersonate.required attributes and principlePermission(securityaction.required,role="mydomain\domain users") on them. however, i keep getting security exception and it faults out. here is my web.config servicemodel info. < system.serviceModel > < bindings > < wsHttpBinding > < binding name = " wsHttpBindingConfig " > < security mode = " Message " > < transport clientCredentialType = " Windows " proxyCredentialType = " Windows " /> </ security > </ binding > </ wsHttp ...Show All