Paul Vacarescu's Q&A profile

• SQL Server Simple recovery and Full backup

  Hi MVPS/MS Experts: Pardon me and my ignorance for asking this question. I just want to understand the backup architecture more clearly. According to BOL (both in SQL 2k and SQL 2k5) in simple recovery mode trasaction log backup is not possible since the log is truncated on checkpoint which is true. Also we know that FULL backup backups both the db and transaction log as well. My question is what happens when a database is in simple recovery mode and a full backup is done. since the tran log cannot be backed up does only the db backup is done when a full backup is done . What exactly happens behind the scenarios . Is it that only the a ...Show All

• Visual C# Constructor does not work the way is should

  Hi guys, I am trying to build a multithreaded port scanner this is my first attempt to program in c#. But my OOP knowledge does not really apply to c#. I have this error which probably anyone can solve but me. I get an error "Method name expected" here is the line that causes the error myThreads[0] = new Thread ( new ThreadStart ( new ScanPort ( "127.0.0.1" ,idx)));  The problem is in the (new ScanPort"127.0.0.1",idx); idx is an integer and scanport is a public class of mine. Here is my scanport class public class ScanPort { String IP; int PORT; public ScanPort( String myip, int myport) { IP = myip; ...Show All

• Windows Forms how to eliminate duplicated values in a databound combobox?

  I have a comboboxService, bound with an ACCESS db table "Service", the displayMember is a column called "serviceContactName", which allows duplicated value in the db. (i.e. one person can be the contact of many services). When I run the app, the combox will contain all the contact names for all services, e.g. if person "Smith" is the contact of 10 services, his name will have 10 duplications in the combobox. How can I make the comboboxService only load the same contactName once plz help If you databinds through datasets you can add a query to your data adapter which include a distinct select on th ...Show All

• SQL Server Excel Connection Manager - Moving between environments

  Hi - I have an issue with the Excel Connection Manager when moving between environments (e.g. from DEV to TEST). 1. My Package contains an Excel Connection Manager X  and an Excel Source Y 2. X has a hard-coded Excel File Path Value:   C:\DEV\FinanceData.xls     X's DelayValidation property = True    Y's ValidateExternalMetaData = False 3. I have 2 Package Configurations:-    3.1 The first one is for "MachineResident" values, such as, drive e.g. D:    3.2 The second one is for "PackageSpecific" values, such as, feed file name   4. I set-up a Scr ...Show All

• Visual C++ Web Browser

  Hi, I'm Robert, and I'm new to C++.  I am using Visual C++ 2005 Express Edition Beta and I'm creating a web browser.  My layout is, for the most part, done, now, I have to implement all of the functions.  I need to find out how to make the File | Edit |View | Favorites (My version of "favorites is different, I just used that name so everyone would be familiar with it) |Tools | Help..... As well, I need to make the browser's buttons work, like Go, Refresh, Back etc AND I've tried to send what I've done so far to people, but it won't work for them, and I'm guessing that I have to put in certain dll files or something, how d ...Show All

• Windows Forms .Net & win98

  Does anyone have any tips for speeding up .Net apps on a slow win98 machine Thanks Scott ...Show All

• .NET Development C Style char array returned by an event from a DLL COM

  I am using a DLL (COM interop) in Visual Basic 2005 and can not get the correct values returned from an event. The last argument is a variable length array of char that is returned as a pointer to the first element in the array. The only thing I get is the first byte no matter how many characters are to be returned. For exampe, if the returned value is 257 in two bytes, my value I get is 1. This is the event handler: Private Sub ads_devicenotification( ByRef pTime As TcAdsDll.TimeStamp, ByVal hNotification As Integer , ByVal cbLen As Integer , <MarshalAs(UnmanagedType.LPArray, SizeParamIndex:=128> ByRef pData As ...Show All

• SQL Server How to: Query Time only?

  Hi, I would just like to know if there's a simple way of querying a time disregarding the date. I mean, I want to query all employees that spends time on the office after 5pm. I don't care about the date, I just want the time... Im currently achieving this by using DATEPART function and concatenating it to resemble a time. Is there a shorter way of doing this     cheers, Paul June A. Domag FWIW, here's another variation on that topic: SELECT RIGHT(STUFF(CONVERT(CHAR(22),GETDATE(),13),21,4,' '),9)           --------- 08:25:36 (1 row(s) affected) And in case your HR department ...Show All

• Visual Studio Express Editions Evaluate Code Stored in String

  How can I evaluate / execute code that I have stored in a string I have many textboxes named: tb1, tb2, tb3, etc. I want to run code like this: For i = 1 to 3 temp1 = "Me.tb" & i & ".Value" temp2 = [EVALUATE or EXECUTE](temp1) Next Any suggestions / helps Please also let me know which libraries need to be included. Any help is appreciated. Thank you! Take a look at the MSScript control. I would like to see exactly what you are trying to do. MSScript is quite powerful but it takes some learning. Its not hard, just takes a little practice. You need to make an interface of wh ...Show All

• Visual Studio How to add programmically new WebService project to the VS2005.

    I have written an Add-in editor to the VS2005 . This Editor is some sort of WSDL Editor and allow to define operation, binding port ,,.. After editing of any WSDL file I generate code   ( C#, J#, VB.Net) through using wsdl.exe. I would like to add   programmatically the generated code as WebService project to the running solution. Does somebody knows how to do it There big difference between VS2003 and 2005 concerning the WebService project Said, One way of doing this is shown in the macro code below. You can substitute the paths with the ones that you are using. You need to add a reference to the V ...Show All

• Windows Forms open an application from a windows service

  Does anyone know how to open an application from a windows service I have an application that I have to run while passing command line parameters.  I figured I could open up this application from a windows service while passing the parameters along with the application call.  Does this sound possible   Any help I could get would be greatly apprec ...Show All

• Visual Basic Pipe Buffer

  Hi All:  Is there a buffer in vb2005 that can write to and read to. After a record is read, it will be removed from the buffer, like a pipe   Thanks. Hi, There's several things within the .net framework that you can use like that, depending on your intent. You use an arraylist, a collection, any number of things. If you want to put things in and get them out in the same order, have a look at the queue class (System.Collections.Queue). If you want get them out in reverse order, the Stack class would be better. Also, make sure you check out the generic versions of the classes (Syst ...Show All

• Visual Basic please help me

  Dear Friends,, This Mohamed ilyas 4m uae but native indian, i am working at uae, once upon a time i studied visual basic database application, but now i use that one, code is not woking, i can't understand now, please anybody help me, this code: for sum   text3.text=val(text1.text)+val(text2.text) i want like this all, sum, mul, div,sub, so pls help me i studied like this 4 calculation, but not working now, why , i don't know, please help me, i studied vb 6.0, but this software visual basic 2005 express edition, may be sotware problem i don't know so pleas help me any body, God bless u. ...Show All

• Visual Basic Can I run application(*.exe) that I wrote in VB2005 beta 2 in other computer?

  I copy the "bin" library to another computer and tried to run the EXE file, at the first it ask me to reinstall ".net framework" so I installed from windows update and after that he write that he didn't find debug.... the o.s is windows 98 maybe this is the problem Hi, I guess the framework you installed is .net framework 1.1 (coz you installed it from win update) vs2005 uses .net framework beta 2. You should install it for your exe to run. But given the circumstances that you didn't use any third party products... http://go.microsoft.com/fwlink/ LinkId=52499   cheers, Paul June A. ...Show All

• Smart Device Development Adding CheckBoxes to a ListBox

  Hi, I am trying to add a checkbox to everyitem I add to a listbox. You used to be able to change the style of the listbox in VB 6 to 2-Checkbox, this is no longer avaiable. Does anyone know who this can be done Regards, James ...Show All