clint 2's Q&A profile

• SQL Server Can't find SQL Server: SSIS Pipeline performance object in perfmon for 64-bit Server

  I can't find 'SQL Server: SSIS Pipeline' performance object in performance monitor on a 64-bit SQL Server. I see it on a 32-bit. Does anybody know why Thanks From what I have read, one should be able to access these performance counters by applying the following fix: http://support.microsoft.com/kb/941154 However, I followed these instructions, modified the requisite registry entry and rebooted the server. After rebooting, I reviewed the registry entry and then fired up perfmon. I expected to be able to add the counters for SQL Server SSIS Pipeline. They still were not available. Has anyone else had success in applying this fix Is there other information regarding this I am reading ...Show All

• SQL Server Using Look UP Getting error when Insert New Records in SSIS Package

  Hi i am using look up for 5 composite key purpose for Insert new Records and Updated Old Records. I am getting the Follwing Error Information. I cant understand the Error Description Please give any one solution for this : Here i a m pasting the Error Description; "[Insert Destination [14266]] Error: An OLE DB error has occurred. Error code: 0x80040E2F. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E2F Description: "ORA-00001: unique constraint (RDP.SYS_C0020517) violated ". " [Insert Destination [14266]] Error: The "input "OLE DB Destination Input" (14279)" failed because error code 0xC020907B occurred, and the error row dis ...Show All

• Windows Forms Windows Service Problem on 2000 Server

  I have a windows service written in C# on .net 2.0. When it starts it first checks some keys in the registry to make sure they are there. If they are not there it displays a small window to the user to enter them. In the service configuration I have set the Allow Service To Interact With The Desktop. This program works fine on 2003 Server and Windows XP but I cannot get it to work on 2000 Server. It seems it cannot read the registry and is getting stuck somewhere. Does anyknow know if any problems like this on 2000 Server Thanks In Advance. Martin I started from scratch using the template above and now it works. No idea why I cant find any differences in the code except I didnt have the com ...Show All

• SQL Server Microsoft Visual Studio is busy

  I get this message in a balloon that pops up frequently when I am trying to work in the SSIS designer. For example, I get it when working in a DataFlow task, trying to open editors for the OleDb Source and Destination. Is anyone else getting this What could be the cause, it seems to get sluggish. Thanks. TFYR. I'm just using the OLEDB source/destination that were installed when I upgraded my default instance to SS 2005. (I had been using SQL2005 side-by-side previously with SQL 2000). I've also noticed that when scripting objects it will also get sluggish and hangs for awhile on the step where it determines objects in the database. Right now, I've been waiting over 2 minutes to script a single proc out of ...Show All

• SQL Server How can i split the rows in 2 textboxes - Urgent

  Hi, I have a report and its been populating from a sproc. and i have 2 text boxes called both of them are poplulated by Fields!Investment Names, but right i can display the data left to right but i want to display the Data starting top to bottom and then towards the right. I tried grouping the data in this way for one text box = CountRows()/2 > 10 . and this shows all the records one below the other, so is there a way that i can display half the records in one text box and the other half in the other text box. I am going kinda nuts over this. Can someone please help me. Regards Karen Are you trying to display this data in the details region of an object(ie. table,etc) or is this a colu ...Show All

• Windows Networking Development Weird one - Router Death by Vista

  Here's a weird one. It seems that Vista RC2 is routinely killing my ADSL router I have a dual boot system (patched up XP Pro vs Vista RC2). Vista seems to be killing my D-Link DSL-500 like...., several times a day while Vista is running. Has anyone else noticed this I'm thinking.... some sort of weird network plug and play thing (which is disabled - by the way) RickW I have been having problems with my DLink DI-624 rev C. Whenever Vista is booted I cannot connect to the wireless side from my XP tablet. It works fine when Vista is shut down, or I'm running XP. I tried turning off UPnP in the router, and then the router just keeps rebooting. ...Show All

• Visual Studio Express Editions AutoIncrementing UniqueIdentifier column in SQL databse table giving NoNullAllowedException!

  Visual Basic 2005 Express: In my SQL database table, I have a CustomerNbr column. In Database Explorer's table definition it has "UniqueIdentifier" as it's data type, and is set as the PrimaryKey. In the XSD Designer, this field is set as the primary key, AutoIncrement=True. DefaultValue is <DbNull>, but, it won't let me remove this! When I add a record to the DataGridView, it correctly puts a "1" in the CustomerNbr column, but, when I update the record, I get a System.Data.NoNullAllowedException! there are many reasons for it existing. one of our SQL Guru's here did say @@Identity is bad practice and not recommended but rather scope_identity() to be used for the ID ...Show All

• Visual Basic ComClass and backward compatibility

  Can anybody tell me the recommended way to expose VB.NET classes to COM if we expect the interfaces to change The Microsoft documentation recommends using the ComClass attribute (or template) for classes that need to be exposed to COM, but ComClass doesn't seem to have any provision for backward compatibility when I later add properties or methods to the class. If I just add public members to the VB.NET class, I get a COM interface with the same IID but with additional members. This violates the COM rule which states that COM interfaces must be immutable. Clearly I need to assign a new InterfaceID to the VB.NET class, while still implementing the old interface, and I am struggling to find any documentation on how to do this in a VB.N ...Show All

• SQL Server Output and Error Output write the same table at the same time, stall the process.

  Hi I have Lookup task to determine if source data should be updated to or insert to the customer table. After Lookup task, the Error Output pipeline will redirect to insert new data to the table and the Output pipeline will update customer table. But these two tasks will be processing at the same time which causes stall on the process. Never end..... The job is similiart to what Slow Changing Dimention does but it won't update the table at the same time. What can I do to avoid such situation Thanks in advance, JD Jamie Thomson wrote: You need to do the update and insert serially - meaning in 2 different data-flows. Push the data for the update into a raw file and then consume it in a seperate data ...Show All

• Software Development for Windows Vista Detect when being run as admin via Visual Basic code?

  Does anyone have Visual Basic sample code to detect when an EXE file is being "Run As Administator" or in XP compatibility mode And is there a way to determine if the elevated level is due to "Installer Detection", due to the user right-clicking and choosing "Run as admin", or due to the EXE's preference or manifest saying so Thanks! Nevermind, I think I found what I needed here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=805394&SiteID=1 ...Show All

• SQL Server SaveAs/Export

  Is there away with the reports to code to have them export into a excel template (a specific one) and have each report go into a different tab When I run the reports manually I can save to excel put not a pre-existing template. Each report has 3 to 12 stored procedures it needs to run so I am just not sure how to accomplish this task. Thanks in advance! Stokh okay now that I have a clear mind. I will give each step Files are sent over from Mainframe out to a location they are just .txt files. scheduled task will run DTS when the mainframe program finishes generating the files DTS package fires, itirates through the folder and imports all the .txt files into SQL Database Scheduled task/Bat file/subscripti ...Show All

• .NET Development How to send email to more than one email address in Visual Studio 2005

  The Microsoft Help file says VS2005 makes sending email easy, but it's harder than it used to be. I have a mail Sub that I finally got to work except I can't see how to send to more than one e-mail address. I've searched the web and this domain for an answer to no avail. Can you show me how to send email to more than one email address in VS2005 You can see some things I tried that I commented out. Thank you for your help. Public Sub sendTheMail(ByVal theSubject, ByVal theServer, ByVal theExMessage, ByVal theStackTrace) Dim SendTo As New MailAddress("pserckl@braan.nabran.com, blansup@braan.nabran.com") 'Dim SendTo As New MailAddress("pserckl@braan.nabran.com; blansup@braan.nabran.com") 'Dim SendTo2 As New Mai ...Show All

• Visual Basic upgraded os, now can not find .dll

  I work for a company who just recently updated their OS from Windows 95/ 98 to xp. The most important program they run was custom made and worked fine in the older OS. When it is run on XP it has an error before it even opens saying "Run-time error: Dxinit.dll not found" . I have talked to the original programmer who said that .dll was custom made and needed to be upgraded already to work on 98. My question is this, how can I get the new OS to see this .dll and run the program I have the VB project files and all the info for installing and compiling. It may run. It's not a driver. But here's the thing. win/95 and win 98 had a very different kernel than does XP. Also the the file stru ...Show All

• SQL Server SQL 2005 Reporting Features comparison to SQL server 2000

  Dear all, I am developing a proposal to my company, which is a microsoft select client, for introducing SQL 2005 to a new BI project. The company already has SQL 2000. I would like to have a full tabular format of SQL 2005 Reporting Service Features comparison to SQL server 2000. Most of feature enhancement paper has only tell what is new but not tell about what is already existed and how much it is improved (in quality and quantity). Yes, tabular format is more useful. I tried to search through microsoft.com, technet but still cannot find the relavent one. Would you please give me a web link Please suggest. I am not impersonated myself like a competitor. You can verify my id by sending e-mail to ...Show All

• .NET Development Reading SerialPort (with .Net 2.0)

  Hello, My robot sends me serial messages (packages) starting with a STX (0x02) character and ending with and EOT (0x04) character. Messages may have variable lenghts and within messages (except from first/last character) no other STX (0x02) or EOT (0x04) characters exists. My robot can send multiple messages at any time. How do I configure my SerialPort to extract individual messages from incoming data I was thinking of setting the 'SerialPort.NewLine' character to EOT (0x04) and use the 'SerialPort.ReadLine' for reading complete messages. But how can I make SerialPort execute an event if an EOT (0x04) character is received All tips are welcome. Henk The SerialPort ...Show All