Re: Problems with connection to remote database
  Home FAQ Contact Sign in
microsoft.public.outlook.bcm only
 
Advanced search
POPULAR GROUPS

more...

 Up
Re: Problems with connection to remote database         

Group: microsoft.public.outlook.bcm · Group Profile
Author: Luther
Date: Sep 15, 2008 08:36

On Sep 12, 3:24 am, elnex...@gmail.com wrote:
> On Sep 8, 9:01 pm, Luther gmail.com> wrote:
>
>
>
>
>
>> On Sep 5, 4:20 am, i...@elnex.pl
>
>> discussions.microsoft.com> wrote:
>>> "Luther" wrote:
>>>> On Aug 1, 5:14 am, i...@elnex.pl wrote:
>>>>> All PCs can see files on server and can ping server-computer. Other
>>>>> SQL software shows me databases on server but not BCM. I set up active
>>>>> ports, firewalle, anty virus software (I tried even to turn it off). I
>>>>> don't know if it's important but I din't mention that I'm using
>>>>> european - polish(PL)  version.
>
>>>> The locale should only be an issue if the client's locale is different
>>>> from the database's.
>
>>>> If your clients' sql software can see other databases, it's likely
>>>> that it is connecting to the default instance, not the small business
>>>> instance.
>
>>>> Try connecting to port 5356, e.g.:
>>>> sqlcmd -E -S yourserver\mssmlbiz,5356 -d MSSmallBusiness
>
>>>> If your BCM database does not have the default name, replace
>>>> MSSmallBusiness with the name of your database.
>
>>> Hello again
>
>>> I'm Sorry, I didn't answer so long.
>
>>> Thank You Luther for your help but still nothing is better.
>
>>> Is there any debugging mode in BCM to see what happens while he is trying to
>>> establish the connection with database or Is there any Log file created by
>>> the BCM during the connection ?- Hide quoted text -
>
>>> - Show quoted text -
>
>
> So I turned on BCM logs and I received this:
>
> [V]
> [14:25:39.0170212]Microsoft.BusinessSolutions.eCRM.OutlookAddIn.CSUtils:
> DBC: WizardLoop state=Cancel
> [V] [14:25:39.0170212]Iris.Mapi.MessageStore: MAPIException:
> hresult=0xffffffff80040113, message:
> [V] [14:25:39.0170212]Iris.Mapi.MessageStore: Aby u¿yæ dodatku
> Business Contact Manager dla programu Outlook, musisz dodaæ bazê
> danych dodatku Business Contact Manager.
> [V] [14:25:39.0170212]Iris.Mapi.MessageStore:    w
> Microsoft.BusinessSolutions.eCRM.OutlookAddIn.BcmEntryPoints.ShowDatabaseCr­eationUI(IntPtr
> hWnd, String profileName, String& databaseName, String& serverName,
> String& offlineDBName, Boolean offline, Boolean& enableAutoSwitch)
>    w
> Microsoft.BusinessSolutions.eCRM.Mapi.MessageStore.EntryPoints.ServiceEntry­(ISupport
> support, Int32 hWnd, IEntryPoints_ServiceEntry_Flags flags,
> IEntryPoints_ServiceEntry_Context context, PropValue[] props,
> IProviderAdmin providerAdmin)
>    w
> Microsoft.Interop.Mapi.NativeEntryPoints.ServiceEntryImplInternal(Boolean
> bUnicode, IMAPISupport* lpMAPISup, UInt32 ulUIParam, UInt32 ulFlags,
> UInt32 ulContext, UInt32 cValues, _SPropValue* lpProps,
> IProviderAdmin* lpProviderAdmin, _MAPIERROR** lppMapiError) [V]
> [14:25:39.0380233]Iris.Mapi.MessageStore: IMAPIProp::GetProps:Enter:
> 0x00adf6c0
> [V] [14:25:39.0380233]Iris.Mapi.MessageStore:
> MAPIProp::GetProps:Return:
> 0x00adf6c0, 0x00000000
> [V] [14:25:39.0420237]Microsoft.BusinessSolutions.eCRM.OutlookAddIn:
> MenuBarBase:moCommandBarsEvents_OnUpdate: Enter [V]
> [14:25:39.0420237]Microsoft.BusinessSolutions.eCRM.OutlookAddIn:
> MenuBarBase:moCommandBarsEvents_OnUpdate: Exit [V]
> [14:25:39.3590554]Microsoft.BusinessSolutions.eCRM.OutlookAddIn:
> MenuBarBase:moCommandBarsEvents_OnUpdate: Enter [V]
> [14:25:39.3590554]Microsoft.BusinessSolutions.eCRM.OutlookAddIn:
> MenuBarBase:moCommandBarsEvents_OnUpdate: Exit [V]
> [14:25:40.8162011]Iris.Mapi.MessageStore: IMAPIProp::GetProps:Enter:
> 0x00adf6c0
> [V] [14:25:40.8162011]Iris.Mapi.MessageStore:
> MAPIProp::GetProps:Return:
> 0x00adf6c0, 0x00000000
> [V] [14:26:10.7731965]Iris.Mapi.MessageStore:
> IMSCapabilities::GetCapabilities:Enter: 0x048cfe84 [V]
> [14:26:10.7731965]Iris.Mapi.MessageStore:
> IMSCapabilities::GetCapabilities:Return: 0x048cfe84, 0x00000000
>
> Luther could you help me with this ? Do you see anything wrong in this
> logs ?
> it's really very strange becouse I still can log in to the BCMs
> database on server Computer from cmd with the "sqlcmd -E -S yourserver
> \mssmlbiz,5356 -d MSSmallBusiness" command and BCM dosn't see any
> databases in selected location.- Hide quoted text -
>
> - Show quoted text -

Some of the text in your log is not in English, which may be an
indication.

When BCM connects to a database, it checks a few things about that
database, like the version number and locale. BCM will only connect to
databases that are the same version and locale as BCM. If you install
French BCM on one machine and German BCM on another, and share the
database on one the machine, BCM on the other machine won't "see" the
database because the locales don't match. That would explain why
sqlcmd can connect to the database, but the database does not show up
in BCM. You can SELECT * FROM OrgTable to get the locale of a database.
no comments
diggit! del.icio.us! reddit!