docturny's Q&A profile

• SQL Server VB on SQL Server 2005

  hi everyone. i am asking for help. i am a programmer using vb 6 and used to SQL server 2000. i have this new job now and they are using SQL server 2005 and my normal ActiveX connection on SQL 2000 dont work on the SQL 2005. what can i do to check this. thanks a lot in advance to anybody who will give me help. good day. gstServerName = txtServerName.Text gstDatabaseName = txtDatabaseName.Text stDriver = GetIniSetting("DSN", "Driver", "SQL SERVER") gstConnStr = "driver={" & stDriver & "};server=" & gstServerName & ";database=" & gstDatabaseName & "; UID=bmpci; PWD=bmpci" If gcnBMPCI.State = adStateOpen Then gcnBMPCI.C ...Show All

• Visual Studio Express Editions Can I use VBE 2005 classes in Excel 2003 VBA code?

  I have a class library that I'm developing in Visual Basic Express 2005. I can use the classes in other projects in VBE, but I would also like to use them in VBA code in Excel 2003 (i.e. in the VBA code I want to be able to create instances of the classes from the class library).  If that is possible, can someone please give me step by step instructions Are you using a classlibrary project If you are then the command is most likely not supported in VB Express. At any rate, you'll need to do the following two steps manually (from the visual studio command prompt): Export the TypeLibrary Register the DLL You'll have to run the tlbexp and regasm commands respectively. T ...Show All

• SQL Server the error of the SMTP in Sql Server 2005 notification services

  Hi all: I had created the notification services in my  server ,but when I add the subscribers and the subscriptions successfully,it can't send email.The most important is there is no any error to indicate me how to do it . The configuration of the SMTP protocol in the ADF is as following     <Protocol>      <ProtocolName>SMTP</ProtocolName>      <Fields>       <Field>        <FieldName>Subject</FieldName>        <SqlExpression>'Flight notification: '+CONVERT (NVARCHAR(30), GETDATE())</SqlExpression> ...Show All

• .NET Development Measure data-traffic per IP-adress

  I have a pc with a number of devices connected to it. They are all connected via an utp cable. All devices have their own IP-adress. Now I want to measure the traffic of this data. In this way I want to check wether there is activity at the device (scanner). So when the number of bytes during a certain period is below a certain value, it must start another process. This must be monitored per IP adress. I want to use C# code to make this work. It's not my goal to measury the connectivity, I've read several articles on that subject. It's really about the quantity of data. Other recommendations regarding this subject are welcome as well. Thanks in advance! LSPs are intentionally native c/c++ code to keep them small and fast as ...Show All

• Windows Forms Problems with .SWF files in WebBrowser =(

  The problem is quite strange ... I .Navigate() my WebBrowser to any .swf file, and it appears normally .... imagine it is a flash-game ... I press any button on the flash "scene" and thats OK, but after the first CLICK others don't work o_O ... But they : "don't work" VERY strange: if I click on any button, the button changes its appearence as I would really click on it, BUT - the scene doesn't change - as if I didn't click on it :/ I tested it on MANY .swf's - all the same. And at the same time - if I open the .SWF files in IE - everything is OK. Also I noticed, that clicks begin to work in WebBrowser after alt-tab ... I found the "answer": http://forums.micro ...Show All

• SQL Server Output Buffer Remove Row?

  I am using a script component to create the output buffer dynamically. I use the Outputbuffer.AddRow() call. I then set all the fields I want, and its added to the output and later inserted into the database. If a field value fails it causes an error, but the record is partially inserted upto the point where the set field command caused the error. So if I set 10 fields, and it fails on field 5 it inserts data for the 5 fields that worked and nulls into the others. As a result I have a try catch clause, and if it fails I want to cancell the addition of the new row. Is there a command like RemoveRow(), rollback, etc that can be used to not insert the record in error Sample code.. Try PaymentOutputBuffer.AddRow() PaymentOutp ...Show All

• SQL Server Newbie Question - Automatically update

  Maybe my question is not at the right place but I'm totally new to this. So I have the following scenario: I have a DB with one table with five records. I create a cube on this. Based on the cube I have to show some KPIs. Everyday I have one more record in my table. If someone clicks on this site it has to show the current uptodate KPIs every day. How can I do this If I understand right I have to process the cubes manually to show the actual datas from the DB. Is there a way to automate this somehow thanks for any your help First, thanks for the quick answer it helped me a lot. The only what I don't really know how to process the cube in the Integration services package. Could you please ...Show All

• SQL Server problem about informix's connection in ssis

  hello,everyone.i meet a problem about that the data source is informix database,the text of OLE DB connection is success,but in OLE DB source control table can not loading,why How to settle it or it  can say by this way,how to  connect informix DB in sql server 2005 SSIS rightly pure wrote: hi,Duane,i use the InformixClientSDK2.70forWindow2000 edition,can you tell me which edition i shall use,or can you introduce some editions to me .thank you ! unfortunately, i don't know of an informix ole db provider that i can recommend. i suggest that you conduct a google search to get more information. ...Show All

• SQL Server Render InlineHTML Reports doesnt Render Charts.

  Hello, I have a report that has subreports for each row, that subreport is a Pie Chart. Here is an screenshot. http://www.avansoft.net/~levalencia/ejemplo1.gif Look that the report has an image on the header, It RENDERS fine on HTML, but the Pie Charts doesnt render. The PDF Renders fine. http://www.avansoft.net/~levalencia/1.pdf private void GenerarInPlaceHTML2() { string path = reportPath + strReporte; ReportExecutionService rs = new ReportExecutionService(); rs.Url = reportServerURL; System.Net.NetworkCredential reportCredentials = new System.Net.NetworkCredential(reportUser, userPassword, domain); rs.Credentials = reportCredentials; // see if Report URL parameter is defined ...Show All

• Visual C# close app that is running in the background

  I've written a windows app that consists of an MDI parent and two child forms. The app processes data in text files line by line and ensures various fields that should be numeric are numeric, etc., then rewriutes the data out to another text file. The input media is either CD or 3.5 disk, and the output is written to a LAN drive. The problem I'm encountering is that after shutting down the app, either by the menu option or by clicking on the form's close button (red 'X'), that the process is still running in the background. For instance, today I had to open task manager and manually stop four instances of the app that were running (these were created while testing the app). The running apps were actually preventing me from performing a ...Show All

• Visual Studio Express Editions Hiding other programs

  Is there anyway to hide other program windows, for example lets say I'm on the computer using messenger and looking at hotmail while posting pictures on yahoo and don't want soemone to see what I am doing when they walk in, at that point I would press my predefined keyy and it would all "hide" posible or impossible I don't have any idea's but I need one before the end of the night so please shed some light. Average Joe That send keys thing sounds reasnable if I set my bar at the bottom to auto hide. that would work great. I have lost my code samples on send keys, I did something a while back with them but I forget how to use them. How could I use send keys to press windows button and d when b ...Show All

• Visual Studio asp.net

  How to added the multiple textbox dynamically in asp.net Hi Yes. In HTMLInputHidden is present in HTML. If i use that code i have get only one textbox. Instead of HiddenField, i have used HTMLInputHidden. This is the coding i have used. Dim textbox As New TextBox() Dim i As Integer Dim hi as new HTMLInputHidden() hi.value=0 hi.Value = Convert.ToString((System.Convert.ToInt32(hi.Value) + 1)) For i = 0 To System.Convert.ToInt32(hi.Value) - 1 textbox = New TextBox() textbox.ID = i.ToString() PlaceHolder1.Controls.Add(textbox) Next Please check ...Show All

• Windows Forms Client Area of MDIParent should not be sunken

  Hallo, i have an MDI Application in which all Childs are plugged in the MDIParent without Border. Now i want to change the look of the MDIParent client area without raised border and not sunken. Did you have an idea how i could manage this. Thanks Arnold thank you for your response. I tried to do it in the way you mention, but i got an exception {"Top-level control cannot be added to a control."} Could you give me some code example of how i can do it and how i can plug in a childform (without border) in the frameform. Probably somebody has some idea for me first question with sunken area in mdi parent! Thanks ...Show All

• Visual Studio Express Editions Problem with error C2059

  Hey all, I have just downloaded a SDK from raven software and it was ment to be compiled in Visual c++ but it was supposed to be v7 and I had to convert it to v8 to use it =( anyway here is the error ------ Build started: Project: JK2game, Configuration: Final Win32 ------ Compiling... WalkerNPC.c c:\projects\jedi_academy_sdk\codemp\game\q_shared.h(1242) : error C2059: syntax error : 'type' .\WalkerNPC.c(63) : warning C4005: 'sqrtf' : macro redefinition C:\Program Files\Microsoft Visual Studio 8\VC\include\math.h(309) : see previous definition of 'sqrtf' w_saber.c c:\projects\jedi_academy_sdk\codemp\game\q_shared.h(1242) : error C2059: syntax error : 'type' w_force.c c:\projects\jedi_academy_sdk\codemp\gam ...Show All

• Visual C# NullReferenceException

  Can anybody tell me why this program have one exception of NullReferenceException in the following red line     protected void add(Object Sender, EventArgs E)     {         article.article art = new article.article(); //line 31         string temp_subject;         temp_subject = Server.HtmlEncode(subject.Text);         temp_subject = temp_subject.Replace("'", "`");         art.subject = temp_subject;         string temp_author;         temp_author = Se ...Show All