dragoncells's Q&A profile

• SQL Server Changing "Connection String" in SSIS package ???

  Hi! I create a SSIS Package for ETL on my own machine. During development database was also on my machine. For access to this database an OLE DB connection was defined within a package in BI Development Studio. Everything worked well both in debug mode and testing package itself. Finally I need to load data to a database on a different machine using this package. I used several scenaries: 1) simply copied the package-file to estination machine, open it for execution, in section "Connection Managers" I edited connection string manually - changed server name and Initial Catalog. And try to execute. 2) on the destination machine I manually created an OLE DB connection (using Microsoft Data Link) to a different datab ...Show All

• Smart Device Development Visual Studio Options dialog does not change Device options

  In Visual Studio 2005, I use the Options dialog > Device Tools > Devices to change the drop-down for "Show devices for platform", and then change my Default device to "Windows Mobile 5.0 Pocket PC Device", but as soon as I close the dialog box, the change disappears. The default emulator will not work at all with this project (upgraded to CF 2). Any suggestions Thanks. UPDATE: I suspect that I have to recreate the solution, selecting "Windows Mobile 5.0 Pocket PC" in the project type instead of "Pocket PC 2003". Is there any automated way to do this ...Show All

• SQL Server Encryption related overflow?

  Recently restored a SQL 2000 database to a SQL 2005 Server. The database contains a series of user stored procs (one calls upto 5 other sps) which are all encrypted using 'WITH ENCRYPTION' clause. When run on SQL 2000 Server this runs without error. When run on SQL 2005 Server it reports an error: Msg 565, Level 18, State 1, Procedure SPDM_MP1_SOURCE59, Line 5143 A stack overflow occurred in the server while compiling the query. Please simplify the query. Investigating the error line reported does not reveal any problems with the sp and the error line number reported is not always consistent. However, altering the stored procs so they are not encrypted and it all runs without error. Is there a compatibility issue running SPs e ...Show All

• Visual Studio Express Editions Serial Port multithreading

  Is it possible for YourCOMPort.BytesToRead and YourCOMPort.DataReceived to change while the subroutine, which handles YourCOMPort.DataReceived is still in progress At very high data rates, the data may come in so fast that for example while previous data is being send to display by means of BeginInvoke new data are received. Depending on how Windows and .NET is build this may or may not course BytesToRead to change and/or a new DataReceived event, while the routine which handles this event is still in progress. If events are just boolean signals - not a queue - there may be a risk that if a new event occur while the subroutine, which handles this event is still in progress, the subroutine will not be reactivated (event cleared at exit). ...Show All

• Visual Studio Express Editions Setup problem.

  When I launch the msvcs.exe or the msvc.exe they get to the point where it says " Setup is loading installation components. This may take a minute or 2." It's been like 5-10 right now, is there a fix Tyrael I did a virus scan and nothing came up, also about that log, that was just the first log. Ill post the whole thing [12/30/06,23:00:37] Setup.exe: [12/30/06,23:00:37] Setup.exe: ========== Logging started ========== [12/30/06,23:00:37] Setup.exe: ===================================== [12/30/06,23:00:37] Setup.exe: GetGlobalCustomProperty({481CEF9F-033A-11D3-ACE2-00C04F8EEBA1}) [12/30/06,23:00:37] Setup.exe: GetGlobalCustomProperty(B51015E7-26A5-4c8f-B871-26ABA9BEFB65) [ ...Show All

• Windows Forms Error Code: 0x80070643

  I have tried to install Windows and Office updates utilizing the Automatic installation tool; but, the initialization takes place and none of the updates are intalled. I ran WinDoctor and I am told that I am missing file "ORUN32.exe" and it cannot access "learn32.dll" and "pctree32.dll". I have searched my computer and found the orun32 and pctree32 files but not the learn32 file. I don't know how it got deleted and not sure how to get it back in place to use the automatic update. What do I do to get my Automatic updates to run again Please help me! Reporting back to say that this most arcane procedure worked perfectly. But why Why would one download fail because it couldn't discover how Offi ...Show All

• Visual Studio Team System TFS Administration Tool Setup: Error code 2755

  Hello! I am trying to install the TFS Administration Tool 1.1 on a machine with Windows 2003 Server R2 Standard Edition SP1 and Team Foundation Server. The OS and the TFS are both German versions. When I start the setup of the tool I get the following MessageBox: The installer has encountered an unexpected error while installing this package. This may indicate a problem with this package. The error code is 2755. How can I get this tool installed and running Regards CSharpNewbie22 Excellent! Thanks for posting the reply - hopefully now when the next person has this same problem, they'll run across this thread and your fix :) ...Show All

• Smart Device Development System.TimeZone.CurrentTimeZone

  I am writing an application for a Windows Mobile device using C# and .Net Compact framework. I need to obtain the system timezone or timezone that the user specifies in the Settings/Date and Time area. System.TimeZone is an abstract class and if I do try to call System.TimeZone.CurrentTimeZone I get a NotSupported exception. I have also tried p/invoking GetTimeZoneInformation() and also received a NotSupported exception. I went to pinvoke.net to see what methods are available under coredll.dll and GetTimeZoneInformation is not there, so I have no idea how I am to get the timezone. Thanks Harry System.TimeZone.CurrentTimeZone.StandardName works fine for me – I’ve just tried it on NETCF V2 and PPC ...Show All

• SQL Server 2 sql server

  Hi In the company i work for we have 2 net and 2 server (server 2003) In the same net we have a net-harddisk where server 1 and server 2 can save data and so on we have a sql server on server1 and another sqlserver on server2 Now is the question: Can i have a database on the net-harddisk and then attach this dabase to sql1 and sql2 Regards Alvin Hi, one slight correction / addition, it is possible, but as H. already said not preferable to do this. You could enable la trace flag to make it working, but as network storages are in comparison to a local storage unreliable you should consider storing the data on a local hard disk driver or a certified SAN rather than a plain Shared folder on a network st ...Show All

• Software Development for Windows Vista Certified for Vista. Test Case 32.

  Hello , I've WER implementation from the Winqal Web site ( https://winqual.microsoft.com/help/default.htm#obtaining_a_verisign_class_3_digital_id.htm Developers Guide to WER ) employed in my MFC application, which is working perfectly on XP, but doesn't work at all on Vista. From previous publications I understood, the way to get it working on Vista is the new API only ( http://msdn2.microsoft.com/en-us/library/ms681656.aspx ), which "... has been VASTLY improved ...", but I didn't found any useful example how to embedd this new API in real MFC application. Current code looks like this: #include "Werapi.h" static LONG WINAPI ExceptionFilter( struct _EXCEPTION_POINTERS * pExceptionPointers ) { ...Show All

• Visual Studio Team System Cherry Pick Merge causes conflict

  I know this subject has come up a few times in the forum, and I've read the answers to those - but still not sure I'm following the answer. I am following an admittedly old webcast from TechEd 2005 by Douglas Neumann that talks about TFS Promotion Modeling, and the ability to Cherry-Pick merge a particular changeset. I'm wondering has something changed since the beta when this seemingly worked Very similar to the demo, I have the following setup: DEV branched to QA (changeset 29) DEV class1.cs QA class1.cs Make a change to class1.cs and check it in + add new property called "NewFeature" for the next release (changeset 30) Make another change to class1.cs for a bug fix and check it in + add new property called "BugFix", need this in th ...Show All

• Windows Forms I keep getting old version after instalation...

  I have a C# project, and in the solution I have a setup project a couple of weeks ago I released the program, now I just released another version, to fix a couple of problems, but those people who had a previous version installed keep getting the previous version, while for those who had no previous version it works just fine...On a test machine, I tried removing any reference to the program manually, I cleare all the tmp folders on the pc, went through the registry, but still the same problem... when I run the program instead of running the updated version Iget the buggy version... any suggestions James There is a property in Setup Project "RemovePreviousVersion" by default this is false, y ...Show All

• Visual Studio Express Editions use of "LIKE" statement in Visual Basic

  Hello does anybody who could help me the correct syntax for the following statement Set Data2.Recordset = db.OpenRecordset("SELECT * FROM accession where WHERE num LIKE @brbook(1)") Thanks Edmund Please try one of the vb newsgroups for vb questions. The forums are for vb.net questions. ...Show All

• SQL Server Want to grant authority to execute any stored procedure in the database in SS2005.

  I don't want to give my programmers dbo authority or the ability to change tables. However, I want them to have full authority to create, modify, change, and delete views and stored procedures in specified databases. Is this possible in SQL Server 2005 I gave them the authority to create stored procedures via these commands: grant create procedure to <login> grant alter on schema :: <schema> to <login> Although the specified login can create and modify a stored procedure, it cannot execute it until I run this command: grant execute on <schema.procedure> to <login> ; It slows them down and is unnecessary overhead to have to stop and do this for every stored procedure. Any ideas ...Show All

• Visual Basic Messagebox

  Hi, I know messagebox, msgbox functions are able to post messages, but they need user to send a result to messagebox. Now what i want is I need a messagebox to post information when a function or procedure is running on the background, and when this function or procedure finishs, this information box will disappear. For example, when my application is doing some save tasks, a information box is posted with text "saving now....", after saving is finished, information box is disappeared. Anybody knows how to it Thank you very much! It all depens on where you are putting your close statement....for example the following code works just fine: Dim f As New Form2 Private Sub Button1_Click ( ByVal send ...Show All