Ski_Hard11's Q&A profile

• Visual Studio Team System CREATE VIEW Error!

  Hi, Just installed VSTS - DB Pro and imported my sample database into Database Project. However i getting some errors in my Database View. I have a couple of view which actually point to the tables in different database. For example: I have a DatabaseA with Table1 I have a view in DatabaseB as below: CREATE VIEW dbo.MyRemoteView AS Select * from DatabaseA.dbo.Table1 I have no problem with the view creation in Sql server query analyzer and i actually can view the View from VStudio Server Explorer. However i getting error in VSTS-DB Project and the error message "Invalid object name 'DatabaseA.dbo.Table1'". Is it Database Project in VSTS-DB Pro currently not support "Cross-Database" View Any other settings i need to do ...Show All

• SQL Server What do I need to use SSIS API on a target machine?!

  Hi, I've created an SSIS package to be loaded using my ASP .NET app. This package is kept within the application and loaded via Microsoft.SqlServer.Dts.Runtime.LoadPackage method. My target machine does not have MS SQL Server 2005 installed. So what do I need at minimum to get this up and running What components do I've to install or copy over I tried to copy just the class libraries across. I copied Microsoft.SQLServer.ManagedDTS.dll and Microsoft.SQLServer.DTSRuntimeWrap.dll into my bin directory but I got this error: [COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.] Microsoft.SqlServer.Dts.Runtime.Applic ...Show All

• Visual Studio Express Editions MenuItem Question

  How do I add hyperlinks to Menu Items through the code. I wanted to make it where _Click() event would occur and then it would open up IE for the user and send him to that hyperlink. To be more specific My link would be graphed like this: Menu Item "Links" -> Phoenix Fire Homepage and when they clicked on Phoenix Fire Homepage, it would send them to that website using their default browser. ...Show All

• SQL Server Connect to external DataBase Via SQLExpress??

  Hi again... I guess this is yet another newbie question (Sorry if its been asked before!) If I have an IP address for an external SQL DB with valid User & Pass... Can I connect to it using SQLExpress on my machine If so can anyone point me towards how to do it, or run through it below (In easy steps as I'm dumb ) Hi ... Many thanks for taking the time to reply, but I am getting this error message Do I have to change any other settings TITLE: Connect to Server ------------------------------ Cannot connect to XX.XX.XX.XX ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be cau ...Show All

• Visual Studio 2008 (Pre-release) Problem when using CollectionViewSource filter with DispatchingNotifyingCollection?

  Hi, I am using DispatchingNotifyingCollection with CollectionViewSource. The code looks like this _wrapperCollection = new DispatchingNotifyingCollection < ObservableCollection < Item >, Item >(Dispatcher, _underlyingCollection); ICollectionVIew view = new CollectionView CollectionViewSource .GetDefaultView(_wrapperCollection) as ICollectionView _listBox.ItemsSource = _view; _view.Filter = new Predicate < object >(filtercode); bool filtercode( object de) { return true; //if return false, it will crash. } The problem if this only works if the filter code didn't filter out any element, if the filter code filters out any element (say I changed it to return false to f ...Show All

• Software Development for Windows Vista Test Case #22: MFC Merge Modules contain tables prefixed with "msi"

  In this test case, one of the requirements is that table in the MSI file are not prefixed with “msi”. We are using merge modules for MFC (as provided by Microsoft) that tables that have the prefix “Msi”. I would imagine that this would fail the requirements. Does anyone have any ideas what is the recommended practice in this case I think you are correct this would fail. Although a practice for pre vista, it appears for vista deployment this is discourged. Let us know you want us to double check this with the logo team. This link (option #2) shows an alternative. This could be done through bootstrapper or chainer exe. http://msdn2.microsoft.com/en-us/library/ms235316(VS.80).aspx ...Show All

• .NET Development checking user permissions on sql server from vb.net windows forms application

  Is there any easy way to check if certain user has login on sql server at all before trying to connect I am using vb.net 2005 and i made some windows forms application with sql server as backend. Windows authentication is setup, too. Hi, Based on my research, you may take a look at link below. http://www.mssqlcity.com/FAQ/Admin/current_users.htm There is a Stored Procedure which will list all the loggined user. But to call the Stored Procedure, we still need to make a connection first. For the .NET side, there is no such approach to check if a user have logged in the SQL Server. A possible way, I think is to use a var to store the current login user. e.g. Once we call Connection.Open and the Connecti ...Show All

• Smart Device Development Mobile development Certifications

  Hi , I work for a software concerrn for 1.5 years in mobile applications for smart phone. my platform is .net and i want to do certifications, i am confused in selecting what kind of certifications to undergo...........pls some one help me out in this......... There is a sticky thread in the General Forum that states there;s a BETA one in place... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=719777&SiteID=1 Thanks ...Show All

• Visual Basic Parse Filesystemwatcher array to Addhandler

  I want to synchronise multiple folders between two servers/shares. The folder-structures are identical but the server name differs. For example: \\Server1\Share\Folder_a\Folder_b --> \\Server2\Share\Folder_a\Folder_b \\Server1\Share\Folder_c\Folder_d --> \\Server2\Share\Folder_c\Folder_d etc. I build a working watchfolder(i) array but how can I pass the array (i) to the addhandler. AddHandler Watchfolder(i).Renamed, AddressOf logrename. Here I lost the relation between de source (server1) and target(server2). Howto keep keep the relation between de Watchfolder(i) event and the logrename action. In the logrename procedure the files must be synced between de source (server1) and target (server2). Arian ...Show All

• Visual C++ How to use an existing bitmap file

  Hello, if this is the wrong place to post this please point me in the right direction. I'd like to know how to use an existing bitmap file in a windows application program I'm working on. I looked up several bitmap functions such as LoadBitmap() and BitBlt(), but I don't see anything about how to actually get information from an existing bitmap file. Any suggestions would be great. Thanks. Hi Sams, For a simple SDI application, we just draw text in view's ondraw function only. What's the problem with painting or using loadimage() in ondraw function I don't much about GDI.Just i implemented few samples .Thanx in advance for ur reply.   Regards, Ch.T.Gopi Kumar. ...Show All

• Visual Basic how do i capture an output screen and paste in ms word as a graphics file?

  i hav made a vb application. now i need to make a help manual in ms word.so,to make my point clearer,i would like to show every instance of my project at run time in this word file. hope it is clear uptil here the thing is how do i capture an output screen and paste in ms word as a graphics file Press the PrintScreen (PrtScr) button (usually next to the F12 function key) to copy the screen to the clipboard and then do a 'Paste' (CTRL+V) in Word. If you want to edit the picture first, then check out Paint.Net which is a free image-editor. Paste the image in there, edit it, save it, and then import or paste it into Word. By the way, why not make a .html webpage manual for easy display in a webbrows ...Show All

• SQL Server Package fails when I schedule it.

  Two scenarios, 1 worked, 1 didn't: First package I execute SQL (select top 10 * from MyTable) in my SQLServer2005 database. I scheduled it and it ran sucessfully. I changed the execute SQL to run against an external Oracle database. (Select * from SomeOracleTable where rownum <= 10). I preview to make sure the query works and it does return a result set. I execute the package in the Visual Studios IDE and it works. I save with encryptAllWithPassword to the SQL server. I go into the scheduler and select the package from SQL Server (as opposed to the file system). I set the step to execute the package off the server. I enter the security key by clicking on the configuration tab. I assume it saves the password to the package. I cl ...Show All

• SQL Server Queue not disabling

  HI There My activated proc is rolling back the transaction and putting the message abck on the queue infinately Normally it disabled the queue after a few rollbacks, i can see in the sql log that it just keeps rolling back and re-activating thousands of times. It only stops when i disable activation on the queue. WHy is the queue not disabling Thanx Sorry that comment was on the wrong post, yes i check sys.service_queues to make sure it is enabled. ANd i check the sql log and can see the activated sp activating and rolling abck thousands of times until i disable actiavtion. I find it very strange it always used to disable becuase of the poison message, but no longer not sure why, i would ...Show All

• Visual C# Is it working?

  Is VB DLL working in C#.net project the DLL is for Internet Transfer Protocol Geert Verhoeven wrote: Hi, Is it VB or VB.NET If it is VB.NET, you can reference it as it was a C# library. If it is VB6, you can use it by using the Add Reference and browse to your DLL. Behind the scenes, a RCW (Runtime Callable Wrapper) will be created. Here is an article that shows Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog thank u very much for your reply ... but where is the article you are talking about and again I appreciate your efforts ...Show All

• Visual Studio 2008 (Pre-release) WPF Text blurry

  Hi, I'm wondering if this is a known problem: I have a multi monitor setup and whenever I move a WPF window from one screen to the other the text becomes totally blurred. Also, moving the window across to the other screens is very slow. Sometimes, this blurry text effect also appears on the main monitor, for example when I expand a combo box, etc. Anybody knows what's going on there Thanks, Tom Hi Tom, This problem has not reported before (the aforementioned SnapsToDevicePixels property does not affect Text). I wonder if your second monitor is actually set to its optimal resolution setting. Does non-Avalon text show up clearly on both monitors -Seema ...Show All