Eric T.'s Q&A profile
Visual Studio 2008 (Pre-release) Cascade delete support ?
Hi, I've hit a problem concerning cascade deletes on foreign keys in SQL. I have in my 'noddy' app again a contact with many address emails . This is managed via a ContactAddressEmail table. This table has a unique PK and corresponding non-nullable FKs. Now I've marked the foreign key betwen Contact and ContactAddressEmail as 'Cascade' for the Delete Rule on the relation. Same for the AddressEmail and ContactAddressEmail relation. When testing in TSQL this is fine - any Contact I delete results in the associated ContactAddressEmail record being removed. Likewise for the AddressEmail record. Magic. However, in LINQ when I db.C ...Show All
SQL Server Web Service Task and Authentication using Soap Headers
I've tried creating several Web Service Tasks and had no problems until I came across one that requires authentication. I have a standalone program to handle this Web Service, but I'm experimenting with SSIS to see if I can replace it. Anyone know how to handle this Thanks -- Scott Pretty sure that is a flat no. There WS task is only good for very simple stuff. You could easily leverage the WS in a custom task/component. For a Script Task or Script Component it would be worth writing/generating the proxy in Visual Studio or similar first. ...Show All
Windows Forms getting the index of a character in ListBox
Hello, i have a ListBox with allot of text on each row. I would realy like to get the index och the character I'm clicking on with my mouse.. I have tried to get it by taking out the x-cord from mouse on the listbox and dividing it with the Font-size. But it is not 100% accurate. Is it possible in some way The font I'm using is Courier New. Regards Well, I need to have the visual effect; when you shoose a row the whole row is selected. Otherwise it could use the textbox. Anyother ideas Regards ...Show All
Visual Basic Copy and Paste in Datagrid
Hello Fellow Developers I am working on a component of my project which has a datagrid. This is a windows application. One requirement I have been given is the end user would like to copy and row and paste it into another row similar to what we can do in Excel. The users have been used to using excel and now they would like to do same type of thing in here. I tried several diff ways of doing it but did not work. I am looking for some direction in helping get this done. Thanks so much You might find these links useful: http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagri ...Show All
SQL Server Can not create unsafe assembly
I try to create assembly with UNSAFE permissions. I granted "unsafe assembly" to my login, set TRUSTWORTHY property ON. Now I have this error: Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5. (Microsoft SQL Server, Error: 15404). How to resolve this Looks like your server isn't able to reach the D.C. to get information on your particular user/group...have you verified connectivity to the domain controller ...Show All
SQL Server installing SQL
I am trying to install SQL enterprise 2005 edition on an XP machine. Is it true that this will not work The config. manager appears but nothing else. If so, will the express version work Thanks in advance. Robert I have now installed the express edition instead (after uninstalling the previous version) and it still does not appear to have installed SQL. Robert ...Show All
Visual Studio When I install VS2003, it always let me restart although I restarted...
Why I restart many times, but it didn't work, also warning me "There is another program need restart" ..... take a look at this similar thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=75714&SiteID=1 let me know if that helps ...Show All
Visual Studio MSBuild Copy Task works intermittently
For some unknown reason, the Copy Task sometimes works, and sometimes doesn't. Does this happen to anyone else I'm running from the command prompt. I haven't encountered any problems using the Copy task as you are illustrating. Maybe it is something besides the Copy task One possibliity that would work on & off would be if you are copying based on an Item. Items are evaluated at the begining of the build, so if you have an item like: <ItemGroup> <CopyFiles Include="**\*.dll"/> </ItemGroup> The CopyFiles will be pouplated at the begining of the build, when you may be ...Show All
Microsoft ISV Community Center Forums Subform Problem
hi all i have a problem that i tried my best to solve it but i can 't till now the problem is i have a form with 2 sub forms in side it built using MS access 2000 currently we moved the database from MS access to MS Sql Server 2000 since then this form no longer works the form idea is that user select the customer id from combo box after update event will do requery for both subforms both sub forms based in a query that select all data from transaction table based on the customer number selected by the user when ommited from the selection the subforms works and displays all the customers regardless the user ...Show All
Visual Studio Team System Trial Edition & Source Control
I received my trial edition today and am about to install it, and I've put the system on the projected budget for next year. But, I'm concerned about what happens if my employer doesn't cough up the big bucks to buy the thing. Particularly the code that is saved in the source control portion. Will it be available when the trial expires Can I get it out easily Thanks for your time. If you are using the 180-day trial edition, you'd no longer be able to get history, checkin, checkout, etc. You would still have the latest copy of the files on your disk. Buck ...Show All
Visual FoxPro HOW TO GO TO SECOND PAGE OF RTF OLEBOX
I am experimenting a form with OLE box containing RTF Text. The content of this is from a memo field. I copied this screen from the Samples\Solutions\Ole TEXT.SCX My question is : When I open the screen, HOW DO I GO DIRECTLY LET'S SAY TO THE MIDDLE OF THE MEMO FIELD WHICH IS THE SECOND PAGE OF THE BOX. INITIALLY IT GOES TO THE FIRST CHARACTER OF THE MEMO FIELD THAT IS DISPLAYED. Kindly help and thank you for your previous help extended. Thank you and God bless you. Rolly You can use SelStart or Find("some text to find") followed by SelLength = 0. ...Show All
SQL Server Need suggestion on loading a 50 million records table from Oracle
All, I need to load a 50 million records table monthly. Any suggestion about the best/fast way to do it Thanks a lot All I tried today; it used 8 hours to load the data just from the Oracle table to the staging table on sql server 2005. It is unacceptable!!! There are must be a better way to do it. In the data flow, there is only an OLE DB source (from Oracle) ----> data conversion transformation(convert the CLOB type) ---------> OLE DB target (SQL server 2005) Do I need to do more in the data flow What should I do Many Thanks ...Show All
Microsoft ISV Community Center Forums Section 1 Footer
Hi, I have a template whose footer is changed at the run time. The template has a different First Page and I modify the footer based upon certain conditions. I am doing this by using the following code Application.ActiveWindow.ActivePane.View.SeekView = wdSeekFirstPageFooter and Then I modify the code. The problem occurs when a section break occurs in the document.Then the first page footer becomes Section1 Footer, and the above code gives an error "Requested view does not exist" Is there anyway I can change the section 1 Footer at run time regards Vishal Hi Vish ...Show All
.NET Development X has encountered an error and needs to close...
In .NET 2.0 it sometimes happens that users of my application receive an error just like in Microsoft programs: X has encountered an error and needs to close. We are sorry for the inconvenience. Would you like to send an report to Microsoft (! ) I don't understand... what kind of exception are that This thing didn't get caught in my general try catch handler... It seems to me that this is a joke :( Thank you for any help! David Sounds like Error Reporting is turned on in Windows. In this case you'll get this if an unhandled exception occurs in your app. How did you define your general t ...Show All
SQL Server Cannot install June CTP on Windows 2003 DC !!!
I am trying to install Sql Server 2005 June CTP on a Windows Server 2003 SP1 primary domain controller with IIS/ASP installed. I get this error (when Sql Server Database Services is being installed: "SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser". And I am not alone! See http://forums.microsoft.com/msdn/ShowPost.aspx PostID=18788 Any workaround or update to be able to install it on a domain controller, Microsoft Thanks! I've been in contact with the TFS team on this issue. As long as you use the April CTP that shipped ...Show All