System.Data.OleDb.OleDbException Unable to initialize data dictionary. Invalid object name ‘SYSTEMINFO’
Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool.
Symptom
When you refresh schemas in the SLX connector schemas you may get the following exception:
System.Web.Services.Protocols.SoapException: System.Data.OleDb.OleDbException: Unable to initialize data dictionary. Invalid object name 'SYSTEMINFO'
Cause
The error “Unable to initialize data dictionary. Invalid object name ‘SYSTEMINFO'” is returned by the SalesLogix OLEDB provider when it is denied access to the following location:
C:\Documents and Settings\Default User
Note: Default User is a hidden folder. You will need to set folder options in Windows explorer to ‘Show hidden files and folders’ to view it.
Resolution
Give account that the SLX Connector web service application pool runs under READ access to the Default User folder.
Note: By default the SLX Connector web service application pool runs under the NETWORK SERVICE account. This can be configured differently by the user so check the application pool identity first before applying the resolution.
