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 17, 2008 09:31

On Sep 15, 8:36 am, Luther gmail.com> wrote:
> 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 whysqlcmdcan 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.- Hide quoted text -
>
> - Show quoted text -
no comments
diggit! del.icio.us! reddit!