Synchronization Of Business Contacts In Outlook With Small Business Accounting
Jun 10, 2006
Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?
I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.
Has anyone tried this?
Can someone walk me through the process?
Thanks
Debbie
View 1 Replies
ADVERTISEMENT
Jul 20, 2005
Hello,I am not familiar with SQL at all any good sites on install I understandthat best practice is to use two aprtitions one foe logs and one for data.I have it as part of a SBS package.Many thanksNic
View 1 Replies
View Related
Jul 20, 2005
I've developed years ago a small business application (about ten tables,basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox7, most of it developed with wizards and little ObjectPAL coding.Old'n'crappy.Seriuosly thinking rewriting it from scratch using MS SQL server 2000 as theDB platform.Low on time.My knowledge: BASIC: good, C & C++: fair, Pascal: almost nothing;Looking for a RAD tool:- client application will be running on P4 with XP/2000 & 128MB RAM - Mustbe FAST (light .exe)- easy learning curve- Hopefully with wizard: design tables for SQL Server 2000, createrelationships, build automatically forms & reports on existing tables.Thanks
View 13 Replies
View Related
Nov 24, 2007
Hello all, has anybody migrated the BCM database from a stand alone PC to Small Biz Server? We fail to import the data in a correct way. After importing the data into BCM on SBS the clients do not recognise the BCM database any more. Thank you!
View 3 Replies
View Related
Jul 11, 2007
Hi,
We try to install Business Contact Manager for Outlook 2007 and get installation failed without any error. It simply refers to the log file. I have posted below the last 40 lines of this huge log file. The information in there are not vary help full since it refers to error codes that nobody seem to be able to explain. Now this is happening on 3 brand new dell computers running XP Pro. I would be happy for any assistance to either explain the error coded (if any MS guy is monitoring this) or maybe someone had a similar problem and could let me know some options on what I could try to get this resolved and my program installed.
Thank you all very much for assisting me.
Thom
--- Log file last 40 lines (more on request) ---
Property(S): RemoteAdminTS = 1
Property(S): WindowsVolume = C:
Property(S): MsiNTProductType = 1
Property(S): ServicePackLevelMinor = 0
Property(S): AdminUser = 1
Property(S): ServicePackLevel = 2
Property(S): WindowsBuild = 2600
Property(S): DigitalProductID = #xA40000000300000038393431302D3238312D323037393634372D3034383138000800000000000000000000000000000000000000003AD3F42CD592998379FDEF3D020300000000005C9495464B6CAB0D0000000000000000000000000000000000000000000000003236333037000000000000009B2D00008555946CBF070000EC3E0000000000000000000000000000000000000000000000000000000000003316ABDF
Property(S): VersionMsi = 3.01
Property(S): VersionDatabase = 200
Property(S): CLIENTPROCESSID = 200
Property(S): CLIENTUILEVEL = 3
Property(S): CURRENTDIRECTORY = C:Documents and SettingsJustin JongMy DocumentsShareFilesBusiness Contact 2007
Property(S): BOOTSTRAPPED = 1
Property(S): REBOOT = ReallySuppress
Property(S): PackagecodeChanging = 1
Property(S): ProductState = -1
Property(S): PackageCode = {A8529450-48A4-4346-92F8-8A9634381267}
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SOURCEDIR = C:Documents and SettingsJustin JongMy DocumentsShareFilesBusiness Contact 2007
Property(S): SourcedirProduct = {B32C4059-6E7A-41EF-AD20-56DF1872B923}
Property(S): ProductToBeRegistered = 1
MSI (s) (64:0C) [02:39:28:441]: Note: 1: 1708
MSI (s) (64:0C) [02:39:28:441]: Product: Business Contact Manager for Outlook 2007 -- Installation operation failed.
MSI (s) (64:0C) [02:39:28:441]: Cleaning up uninstalled install packages, if any exist
MSI (s) (64:0C) [02:39:28:441]: MainEngineThread is returning 1603
MSI (s) (64:04) [02:39:28:535]: Destroying RemoteAPI object.
MSI (s) (64:9C) [02:39:28:535]: Custom Action Manager thread ending.
=== Logging stopped: 7/12/2007 2:39:28 ===
MSI (c) (C8:50) [02:39:28:550]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (C8:50) [02:39:28:550]: MainEngineThread is returning 1603
=== Verbose logging stopped: 7/12/2007 2:39:28 ===
View 2 Replies
View Related
Jan 5, 2007
Hi
We have SQL Express running very slowly on Small Business Server. Does
anyone know if there is a conflict between the two? Or any ideas on how
to solve our problem?
(Autoclose is set to
false)
Thanks
View 1 Replies
View Related
Oct 30, 2006
I have a merge replication topology that allows some subscribers (clients) to retreive a number for certain columns (ie invoice number, order number, etc).
I have implemented a custom business logic handler to check for inserts from the subscriber and before updating the server, I call a stored proc on the server to generate a new number. I update the data set and call ActionOnDataChange.AcceptCustomData. This works great for the publication db but I am trying to get this new number back into the subscription db. I am using web synchronization so I really don't have a connection back to the subscriber database.
Any Ideas? I was thinking about keeping track of the updates myself and build a sql string and somehow get that back to the subscriber to run updates for those columns... I am wondering if I am pushing the limits of the business logic handler? Was it designed to do this? Of course the easy answer is to modify my client application but I am trying to avoid that at this point.
Any help/suggestions would be greatly appreciated!
View 6 Replies
View Related
Dec 13, 2006
I have an SBS 2003 server that is running SQL 2000 standard edition which was recently upgraded to Small Business Server 2003 R2.
I have installed SQL 2005 workgroup edition on the SBS 2003 R2 server which acts both as an AD server and Exchange server. I installed SQL 2005 for the purpose of using SQL 2005 for my sharepoint services on the Small Business Server R2.
Now I have SQL 2000 and SQL 2005 workgroup edition installed, but I'm unsure whether I can uninstall the SQL 2000 and how to know whether the sharepoint instance is running in SQL 2005 or SQL 2000?
Additionally, I have some MSDE's running for WSUS and Server Reporting which are installed by the Small Business Server installation.
Which tools should I use to become familiar with identifying the databases and which version of the database engine is used for which database regardless of whether it is a SQL instance or a MSDE instance.
How can I identify which SQL versions are not in use and whether I can uninstall if not needed.
Thanks!!
View 3 Replies
View Related
Oct 23, 2007
Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?
I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.
Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.
Thank you
View 1 Replies
View Related
Jan 25, 2007
Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.
A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.
There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.
Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?
Please let me know. Thank you.
View 3 Replies
View Related
Mar 15, 2006
Thanks in advance. What is maximum SQL Server database (*.mdf) file size with SQL Server 2000 as part of Microsoft Small Business Server 2000? (Database files were limited to 10 GB in SBS 4.5 with SQLServer 7.0... has this changed?).
View 1 Replies
View Related
Nov 5, 2007
I'm trying to configure SQL server 2000 (standard edition) to send e-mail on a Small Business Server 2003. There's a great article on how to do this on a SBS 2000 server (KB304967), but it does not apply to SBS 2003. Can anyone point me to a article or white paper on how to configure SQL on a SBS 2003 server to send e-mail. Thanks.
David Neahusan
View 1 Replies
View Related
Apr 23, 2008
Hi
MS Backup in Microsoft windows server 2003 for small business server reports:
<-- Volume shadow copy creation: Attempt 1.
"MSDEWriter" has reported an error 0x800423f4. This is part of System State. The backup cannot continue.
Error returned while creating the volume shadow copy:800423f4
Aborting Backup. -->
The VSS events that I get are 8193 & 6013
The MSSQL$SHAREPOINT events are 17055, 18452 & 18456
These are the main Errors that I get:
Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 8193
Description:
Volume Shadow Copy Service error: Unexpected error calling routine IClientVirtualDevice::GetCommand. hr = 0x80770004.
Event Type: Error
Event Source: MSSQL$SHAREPOINT
Event Category: (2)
Event ID: 17055
User: NT AUTHORITYSYSTEM
Description:
18210 :
BackupVirtualDeviceFile:repareToFreeze: failure on backup device '{74A09E78-8845-47EB-9602-705E4406096C}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 6013
User: N/A
Description:
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: BACKUP DATABASE is terminating abnormally.
Event Type: Error
Event Source: MSSQL$SHAREPOINT
Event Category: (2)
Event ID: 17055
User: NT AUTHORITYSYSTEM
Description:
18210 :
BackupVirtualDeviceFile:repareToFreeze: failure on backup device '{74A09E78-8845-47EB-9602-705E4406096C}5'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
I need to get the Backup System working again urgently.
Any advice will be greatly appreciated
View 8 Replies
View Related
Feb 13, 2006
Dear Sir,
I would like to use sql server 2000 as datasource with visaul web developer express.
My concern here is it compatilbe ?
Thanks
View 1 Replies
View Related
Mar 29, 2004
In relation to my topic:
http://www.dbforums.com/t990566.html
I'm curious as to how much of a difference SQL-server will make to our databases.
Is there anyone who can tell me what kind of version of SQL-server ships with Small Business Server 2003 Premium edition?
I looked on the Microsoft website and it just states that
SQL-server 2000 is included with Small Business Server 2003 Premium edition.
Is there anyone who can help me?
Any thoughts link redirects tips are appreciated
View 8 Replies
View Related
Dec 25, 2005
Anyone knows what the difference is between SQL Standard edition OLPand SQL Server in SBS 2003?I'm interested in purchasing SBS2003 because the price is much lowerthan if you buy OS2003 + SQL2003 separately.
View 1 Replies
View Related
Feb 3, 2005
Guys
Does anyone know of a 3rd party module/plug-in for VS or even some
downloadable code that enables the import of Outlook/ACT and similar contact
information through an ASP.NET page into a SQL Server table with ongoing
1-click button sync.
I need to replicate something similar to the Intellisync tool used in Yahoo
Mail.
regards
Andy
View 3 Replies
View Related
Jun 13, 2006
Hi everyone,
I have to extract, dayly a list of contacts on a exchange server in a table on our EDW on sql server 2005. Is it possible to get the information directly from a dataflow or i will have to developpe a script task ?
Need help desperatly !!!
View 3 Replies
View Related
Mar 15, 2006
Hello:
I tried to synchronize the SQL 2000 database with the SQL mobile server on PDA with SQL server management studio from SQL 2005. I got the error as €œThe buffer pool is too small or there are too many open cursors. HRESULT 0x80004005 (25101) €?. The SQL database file size is 120MB.
I create the .sdf file on PDA with the following C# code:
string connString = "Data Source='Test.sdf'; max database size = 400; max buffer size = 10000;";
SqlCeEngine engine = new SqlCeEngine(connString);
engine.CreateDatabase();
I think the 400MB max database size and 10000KB max buffer size are big enough to hold that SQL database data and I have already successfully synchronized my PDA with another smaller SQL server database file. I have been kept trying and searching this for couple of days and still can not figure it out.
Moreover, the synchronization always stops at the same table.
Please help and a lot of thanks in advance.
View 1 Replies
View Related
Jan 29, 2004
i got this error message in my browser
SELECT permission denied on object 'Contacts', database 'Contacts', owner
'dbo'.
this is the code where it stopped
sqlDataAdapter1.Fill(dataSet11);
//Update the data grid
DataGrid1.DataBind();
Now i finally i grant the access to the database for user ASPNET but it
seems not working yet.
I am running SQL Server
What i am missing ?
Thanks
View 3 Replies
View Related
Feb 10, 2008
I had to do a re-install of SQL 2005 Standand Edition. I
now do not have the BI, I do not know if it came with it or not.
What would I need to install ifit did? I also wanted to
ask: I know that MS Office Excel has the capabilites to sames as
an XML file, but it is not very readable to import into the SQLdatabase. Is there a way to import the XML file into the database via one of the express editions? Thank youDee
View 1 Replies
View Related
Jun 20, 2008
dear gurus,
I want to get the working days between two days..
in a single query.
i will give the start_date '06-02-2008',end_date '06-13-2008' the result should be as below.
06-02-2008Monday
06-03-2008Tuesday
06-04-2008Wednesday
06-05-2008Thursday
06-06-2008Friday
06-09-2008Monday
06-10-2008Tuesday
06-11-2008Wednesday
06-12-2008Thursday
06-13-2008Friday
Thanks in advance.
cool...,
View 5 Replies
View Related
Jul 12, 2005
I want to understand what is Business intelligence and what is functions of it
View 1 Replies
View Related
Sep 24, 2007
I Have a date range and i want to calculate the number of days - the weekends(saturdays and sundays) so that only businessdays are obtained.
A simple table's example:
Name, surname, datebeg, dateend
How can can it be done with sql?
BB
View 3 Replies
View Related
Aug 20, 2007
Hi,
I am wondering what is vb.net method of calculating the prior business day (Monday - Friday).
For example, if today is Monday, Aug. 20, the last business day would have been Friday, Aug. 17.
I have a way to do this in SQL, but not vb.net.
Thanks much
View 4 Replies
View Related
Feb 28, 2008
Ok, probibly an easy question but I haven't been able to find what I am looking for.
If I have a simple class (see below), how would I make the People List avalible to build a report off of?
Thanks
asdf46
Code Snippetpublic class Person
{
public string FirstName { get; set;}
public string LastName { get; set;}
}
// and put them into a list
List <Person> People = new List<Person>();
People.Add(new Person () { FirstName = "Joe", LastName = "User"});
People.Add(new Person () { FirstName = "Jane", LastName = "Smith"});
View 3 Replies
View Related
Apr 11, 2008
Hi all,
I've created a store dimension. Within the store dimension is a CityID column that is related to a City dimension. Currently this city dimension has the following columns:
CityID (primary key --- foreign key for the StoreDim)
CityName
CountyName
StateName
CountryName
...
My SCD's source is being loaded from a query to a Zip table that contains ZipCodes along with cityID, CountyID, StateID, and CountryID that can be joined out to their respective tables to find the information needed to populate my SCD. However, cities can have several number of zipcodes and several cities in different states can have the same names. This causes a problem with eliminating duplicates for my dimension as well as finding a suitable business key.
For example, let's take a case: Washington city, District of Columbia (county), District of Columbia (state), USA (Country)
Now, this city has SEVERAL zip codes so when I create my joins:
SELECT ...
FROM Zip Z
INNER JOIN City C
ON C.CityID = Z.CityID
INNER JOIN County Cty
ON Cty.CountyID = Z.CountyID
So this returns several CityIDs for the same city... which when I try to use for my SCD causes problems because i have several business keys based off my CityIDs so my dimension loaded would look like
CityID CityDesc CountyDesc StateDesc CountryDesc
1 Washington District of Columbia District of Columbia USA
2 Washington District of Columbia District of Columbia USA
3 Washington District of Columbia District of Columbia USA
4 Washington District of Columbia District of Columbia USA
I want to have just ONE record in my dimension for this city.... How would I do this and what would I use for a business key? Also any recommendations on which of these attributes should be historical attributes? I would appreciate any input you guys have.
View 4 Replies
View Related
Jul 24, 2007
The Business Intelligence isn't showing up in the menu with ( Visual Basic, Visual C##, etc). A teckie installed the pro version and said she installed everything, can some one point me in the right direction. We purchase the media and installed from that.
View 2 Replies
View Related
Feb 26, 2008
Or maybe it can't find something it's looking for to make my additional symetrical with everything else. This is from one of my businesslogic files. What causes Visual Studio to not allow me to add something here and have it behave like the other parameters/ I'm talking about ShortDesc. Visual studio inserted () and the Get instead of GET like all the others. It would not allow me to capitalize the "get". There has to be a reason for this. Currently my program is adding all of the fields except the ShortDesc to the table in my database. Does anyone have any thoughts as to why this is the case?
#Region "Pvt Members" Private _ArticleID As System.Int32 Private _UserID As System.Int32 Private _WebSiteID As System.Int32 Private _ArticleTitle As System.String Private _Author As System.String Private _ShortDesc As System.String Private _ArticleText As System.String Private _AnchorText As System.String Private _ShowInDirectory As System.Boolean Private _Active As System.Boolean Private _DateAdded As System.DateTime#End Region#Region "Properties" Public Property ArticleID As System.Int32 GET Return _ArticleID End Get Set(ByVal Value As System.Int32) _ArticleID= Value End Set End Property Public Property UserID As System.Int32 GET Return _UserID End Get Set(ByVal Value As System.Int32) _UserID= Value End Set End Property Public Property WebSiteID As System.Int32 GET Return _WebSiteID End Get Set(ByVal Value As System.Int32) _WebSiteID= Value End Set End Property Public Property ArticleTitle As System.String GET Return _ArticleTitle End Get Set(ByVal Value As System.String) _ArticleTitle= Value End Set End Property Public Property Author As System.String GET Return _Author End Get Set(ByVal Value As System.String) _Author= Value End Set End Property Public Property ShortDesc() As System.String Get Return _ShortDesc End Get Set(ByVal value As System.String) End Set End Property Public Property ArticleText As System.String GET Return _ArticleText End Get Set(ByVal Value As System.String) _ArticleText= Value End Set End Property Public Property AnchorText As System.String GET Return _AnchorText End Get Set(ByVal Value As System.String) _AnchorText= Value End Set End Property Public Property ShowInDirectory As System.Boolean GET Return _ShowInDirectory End Get Set(ByVal Value As System.Boolean) _ShowInDirectory= Value End Set End Property Public Property Active As System.Boolean GET Return _Active End Get Set(ByVal Value As System.Boolean) _Active= Value End Set End Property Public Property DateAdded As System.DateTime GET Return _DateAdded End Get Set(ByVal Value As System.DateTime) _DateAdded= Value End Set End Property #End Region
View 1 Replies
View Related
Mar 22, 2001
Is there any easy way to calulate number of business days between the 2 dates ?
I want to exclude all sat and sun between the 2 dates.
View 1 Replies
View Related
May 10, 2006
I am trying to calculate business hours that an order that is open. The rules are 8am-5pm. For instance the first row, the clock would stop at 17:00, and pick up again at 8am and add on to total business hours. If the order was created after business hours, and the endstamp was before business hours, this would be 0. If created after 5pm friday, and the endstamp was before 8am monday, this would be 0. In the second set of timestamps I have here the order was recieved at 14:39 but took until the following day at 14:49 to be ordered. I imagine I have to use datepart and datediff for this, but other than that I am not sure on how to do it. Any help would really be appreciated!
StartStampEndstamp
6/27/2005 14:356/27/2005 17:41:11
6/27/2005 14:396/28/2005 14:49
6/27/2005 18:486/27/2005 18:54
6/27/2005 11:416/27/2005 11:45
View 7 Replies
View Related
Aug 16, 2007
I'm looking for a DATEDIFF function which will give me the
BUSINESS days difference between 2 dates.
e.g: datediff(day,'08/08/2007','08/14/2007) would normally result in 6 (i think), however in business days this would be 4.
is there such a function?
Thx
View 4 Replies
View Related
Mar 3, 2008
Interesting news article
http://www.theserverside.com/discussions/thread.tss?thread_id=48599
View 1 Replies
View Related
