SQL Server Service Pack 2 Release
SQL Server team released sevice pack 2 for all flavors of SQL Express. If you installed Business Contact Manager for Outlook 2007, you are running SQL Express SP1. BCM team has done extensive testing of SP2 to ensure it doesn't cause any problem with BCM functionality. Feel free to install SQL Express SP2 if you are running Business Contact Manager. You can download it from https://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en.
-Mukesh
Comments
Anonymous
February 25, 2007
BCM client cannot synchronize offline database since I've installed SQL 2005 SP2 on the shared server. I've just tried to install SP2 on client machine but it doesn't work better.Anonymous
February 26, 2007
Sorry I was wrong.I've re-installed SP1 on each server/client and it does not work ("Impossible to synchronise")Anonymous
February 26, 2007
Did you complete the steps outlined in the whitepaper?http://www.microsoft.com/downloads/details.aspx?FamilyID=f24267ee-9ad5-4be5-b888-c9a50ae395ca&DisplayLang=enWas client/server synch working before you installed SQL SP2? Double-check your firewall settings and make sure that you go to “Start | Microsoft SQL Server 2005 | Configuration Tools | SQL Server Configuration Manager | Protocols for MSSMLBIZ | TCP/IP | Properties | IP Addresses | IP All | TCP Port” and enter 5356.Anonymous
February 26, 2007
Eddy, Can you drop the Offline database client and recreate it. You can do this by going to Offline->Drop Database.-MukeshAnonymous
March 05, 2007
I am not sure whether this blog covers BCM application programming support issues since I don't see a direct hit on the Tags, but I will ask anyway.I have my business contacts linked to accounts, and I am traversing my business contacts, and would like to be able to retrieve the corresponding accounts based on the "Parent Entity EntryID" field, which was used to link the business contact to its parent account in the first place. I don't know how to retrieve an account based on the "Parent Entity EntryID" field. When I try to "Find" an account based on "EntryID", I am getting a "Condition is not valid" error message.So, if strParentEntity is the business contact "Parent Entity EntryID" field, the following fails:strFind = "[EntryID] = '" & strParentEntity & "'"Set objAcct = objAccounts.Items.Find(strFind)Does anyone know how to obtain a reference to an account object using the business contact's "Parent Entity EntryID" field?Thanks!Anonymous
March 05, 2007
Outlook OM has a method called "GetItemFromID". You might want to use that. Code will look something like this.Set objAcct=namespace.GetItemFromID(<EntryID>)Thanks.Anonymous
April 14, 2007
The comment has been removedAnonymous
April 14, 2007
The comment has been removedAnonymous
April 30, 2009
The comment has been removedAnonymous
April 30, 2009
The comment has been removedAnonymous
January 28, 2011
Running BCM on Win7 and apparently have BCM sp2 upadate. All of a sudden the due date field is no longer grouping or sorting. It is showing "none" for the due date field on the "Business Projects in BCM-[by due date]" current view. The due dates are showing up correctly in individual "Business Project" paine. They will list properly on other current views such as "Business Projects in BCM-[by assigned to]" but will not GROUP properly by due date because it recognizes it as "none". Same issue with start date field. HELP!Anonymous
January 28, 2011
Running BCM on Win7 and apparently have BCM sp2 upadate. All of a sudden the due date field is no longer grouping or sorting. It is showing "none" for the due date field on the "Business Projects in BCM-[by due date]" current view. The due dates are showing up correctly in individual "Business Project" paine. They will list properly on other current views such as "Business Projects in BCM-[by assigned to]" but will not GROUP properly by due date because it recognizes it as "none". Same issue with start date field. HELP!