Catalin Zima's Q&A profile

• Microsoft ISV Community Center Forums excel formula

  hi, In the formula section, how do you check if the value of a cell is a date Thanks Hi I am not aware of an Excel function that does this directly. Excel stores dates as numbers 1 is 01/01/1900 etc, with the time stored as decimals after the integer. This does allow you to test if the cell contains a number which is equivalent to the date range you are looking for eg the below checks if the value in A3 can be interpreted *** a date between 01/01/06 and 16/09/06. =IF(AND(INT(A3)>=38718,INT(A3)<=38976),"Is my date range","Not my date range") ...Show All

• Visual Studio Team System Open Team Explorer : Specify User Accounts

  Is it possible to force Team Explorer within the .Net IDE to display the logon credentials dialog The reason being I have two accounts configured within TFS : The first is a TFS Server local admin account. This is added to the TFS Administrators groups. The second is my "normal" domain account. This is added (via an AD group) to the contributors group. During normal development I'm logged on to my machine as my domain account and Team Explorer opens with contributors perms. But from time to time I need to log on as the admin. Is there a simple way to do this Thanks. Hi Craig, Since for the first time while connecting to the server the credentials are requested and i ...Show All

• SQL Server Download DTS for SQL 2005 Express

  I'm trying to export a SQL 2005 express database to SQL 2000 without success, really a pain in the ass :-( But I found that it may be a hope but I can't find the page to download the in this page mentioned additional download for SQL 2005 express that will add DTS functionality to it. http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx " DTS runtime Yes Yes (Web download) " Where can I find the additional package to add DTS to SQL2005 express Best Regards Thanks for posting this. Helped with tedious task. To share my install experience with others, also could not find the DTS Wizard after installing the MSI. Did remember from previous use that it could start with a run dt ...Show All

• SQL Server SQL CE 3.0 (Mobile 2005) Max DB Size Question

  Hi everyone, What are the consequences for just setting the Max DB Size to 4GB and letting it go at that Is the MAX Size any arbitrary value I want or must it be close to what the actual database is expected to be Also, why did they default to 128MB Wouldn't it have been better to set it to a larger value Thanks Dorothy Dorothy, Excuse me for butting in, but you can buy Bill's book at http://www.hitchhikerguides.net/ . The purchasing process is a bit confusing, but the book's well worth the money and effort IMO. --rj ...Show All

• Visual C++ C++/CLI problems/issues

  I have some questions on C++/CLI issue. Let me explain my situation: I have an existing native COM dll that contains my logic. It has been tested and works fine with native C++ client using CoCreateInstance. I would like to add a new logic and notice that BCL has a class that I can use. So I add a new source file and header which I compile with /clr since I need to use one of BCL classes (actually, at this point, it is just an empty shell). When I tried to CoCreateInstance in my native client, it couldn’t create. But if I go back to my COM dll project and take out the /clr in my new source file, it works fine. After some debugging, I found out the problem and have been able to fix the issue. However, I would like to get more detai ...Show All

• Software Development for Windows Vista What's with the ports?

   I'm not exactly sure if this is a bug or a feature... but after doiing 6 hours of research... and... Well after running out of places to search and being new to this vista thing, i had to come here... I thought i knew it all... how to properly connect to the internet and forward ports properly... apparently i was wrong! I just noticed that even if i forward all the necessary ports through the router... and even after i disable the vista firewall... i still can't get anything forwarded correctly. Most web sites that test to see if my forwarding is right say this: "Connection Refused". Let's not mention that i can NOT use mIRC... same reason, "Connection refused". Now if i did same thing in XP Pro, disable firewall and forw ...Show All

• Visual C++ Memory window cannot be scrolled much

  When displaying memory, clicking on the scroll bar only allows you to move a limited amount in either direction. Beyond this, in the higher address direction, it shows blank, and will not move past the lower address limit. I can find no documentation on the proper operation of the memory windows, beyond the most rudimentary descriptions. For structures larger than a few Kb, it is necessary to be able to scroll from the base address, but the memory windows apparently don't let you do this. They worked as expected in VS6. The occurrence of this bug is dependent on the memory address and the state of memory. The instance I saw occurred with a large (0x216ab0 bytes) array allocated on the heap at addr ...Show All

• SQL Server CREATE ASSEMBLY ERROR -- an implicit reference of some kind ???

  When I run this ... CREATE ASSEMBLY asmRANDRTCalendaringGateway FROM 'E:\sql\RANDRTCalendaringGateway.dll' WITH PERMISSION_SET = UNSAFE I get this error ... Msg 10301, Level 16, State 1, Line 1 Assembly 'RANDRTCalendaringGateway' references assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. Even though I do not explicity refer to system.w ...Show All

• SQL Server How to create large report?

  Hi, I have been tasked with trying to re-create out in-house reporting solution, based-on powerpoint and SQL Server, using Reporting Services 2005. However when trying to create a demo report I find a number of problems: 1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides) 2) I cannot find a way to set any global report styles for text or charts 3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report Any help/advice would be greatly appreciated, Thanks, Denham H ...Show All

• SQL Server slq reporting 2005

  is there any sampel web site where i can learn how to create a reports in sql server 2005 i'm interested in: 1) how to pass parameters to report thanks. Hi, Here is an example in using report parameters: http://www.odetocode.com/Articles/156.aspx Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• .NET Development Connection pooling

  In my past I took the following course Programming with Microsoft ADO.NET (Material No: 2389BCP) Connection Pooling is covered in detail under Module 2: Connecting to Data Sources; Lesson: Connection Pooling Where the second paragraph on page 39 state the following (citation): When a connection is closed, the connection is returned to the pool and ready for reuse. When a connection is disposed, the connection is deleted from memory. It is not returned to the pool and is not available for reuse. When the last connection in a connection pool is deleted, the pool is also deleted from memory. As we all know when dealing with Web application, enabling Connection Pooling is vital and the reasons are well k ...Show All

• Visual Studio Team System Explorer

  There is a way for use the explorer like a standalone application outside Vs2005 Do you mean internet explorer You can press "ctrl + alt + r" to bring in an IE window to browse. Actually this forum is specific to Team Foundation server administration issue and for general VS questions, try one of VS forums under http://forums.microsoft.com/MSDN/default.aspx ForumGroupID=6&SiteID=1 ...Show All

• Visual C# Odd VS 2005 reference warnings. "The referenced component 'System' could not be found."

  Does anyone know why (or even better, how to fix) VS 2005 randomly generates warnings like: "The referenced component 'Some .NET assembly' could not be found." then when you click on the reference in the Solution Explorer, it magically fixes whatever problem it thought it had How do I stop these warnings from showing up again Thanks for any help with this. dougzhoez Your not alone. I too have seen the same messages. As a matter of fact, I just rebooted my computer and opened a solution in VS2005 and saw: The referenced component 'System' could not be found. The referenced component 'System.Data' could not be found. The referenced component 'System.Deployment' could not be found ...Show All

• .NET Development Accessing via OleDB with an ODBC driver

  It could happen that you have to access a Database striclty via OleDB way For example to gather the schemas information in a standard-unique way with the GetOleDbSchemaTable, instead of the Database dependent GetSchema of the generic "Connection" classes If you have only ODBC driver and you weren't succesful in finding a working OleDB connector, you can try with the MSDATASHAPE oledb connector.   I needed to access a MySql database via OleDB (to gather schemas infos like if I used OleDB generic provider) but i didn't found a working OleDB connector, so i installed the MySQL ODBC 3.51 Driver and found succesful the following:  OleDbConnection oconn= new OleDbConnection (" Provider=MSDATASHAPE ...Show All

• Audio and Video Development Important Notice About Playlist Applications and Timings

  I received this in an email this morning. For those who have heavy use of markup, it could be very important. According to the HD DVD specification (Annex Z.2.2), Playlist Applications may not use the title clock. Although the current version of the Toshiba player/emulator does allow this, because the default clock of a timing section is the title clock, not specifying either the application clock or the page clock when authoring results in a disc that will break in future versions of the Toshiba player. Luckily I used page, but this means that different players have slightly different implementations of iHD what could mean that some discs can't be played on all HD DVD players which will irritate ...Show All